1 / 37

Workstation & Microcomputer Facilities

Workstation & Microcomputer Facilities. Team 5 Asmita Karandikar, Zach Levine, Michelle Lew, Brian Loo, Mike Lovejoy, Yue Tu Friday, December 7 th , 2007. Overview. Organization summary Simplified EER diagram Relational Design (Schema) Normalization Queries in SQL and Access

caesar-owen
Download Presentation

Workstation & Microcomputer Facilities

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Workstation & Microcomputer Facilities Team 5 Asmita Karandikar, Zach Levine, Michelle Lew, Brian Loo, Mike Lovejoy, Yue Tu Friday, December 7th, 2007

  2. Overview • Organization summary • Simplified EER diagram • Relational Design (Schema) • Normalization • Queries in SQL and Access • Query snapshot • Conclusion

  3. Organization Summary • UC Berkeley Microcomputer Facilities • 12 locations, 7 open to public • Approximately 300 computers total • Approximately 100 full- and part-time staff Evans MF Dwinelle MF Moffitt MF

  4. UC Berkeley Microcomputer FacilitiesDatabase

  5. Relation Design (Schema)Microcomputer Facilities Database

  6. Relation Design (Continued)

  7. Relation Design (Continued)

  8. Access Relationship View 8

  9. Access Interface Example 1 (Edit/Add Computer) 9

  10. Access Interface Example II (Request and Assign Repair) 10

  11. Functional Dependencies 11

  12. Functional Dependencies (cont’d)

  13. Functional Dependencies (cont’d)

  14. Functional Dependencies (cont’d)

  15. Query- Budget Analysis

  16. Query – Budget Analysis (cont’d)

  17. Query – Budget Analysis (cont’d)

  18. Query – Budget Analysis (cont’d)

  19. Query – Budget Analysis (cont’d)

  20. Query – Budget Analysis (Prt Sc)

  21. Query – Budget Analysis Report

  22. Query – Maintenance Mgmt

  23. Query – Maintenance Mgmt

  24. Query – Maintenance Mgmt (cont’d)

  25. Query – Maintenance Mgmt (cont’d)

  26. Query – Maintenance Mgmt(Prt Sc)

  27. Query – Maintenance Mgmt (Prt Sc)

  28. Query – Maintenance Mgmt (Prt Sc)

  29. Query – Maintenance Mgmt (Prt Sc)

  30. Query – Maintenance Mgmt Report

  31. Query – Human Resources

  32. Query – Scheduling

  33. Query – Scheduling

  34. Query – Scheduling

  35. Query – Service Levels

  36. Query – Service Levels

  37. Questions?

More Related