1 / 36

HOPE TECHNOLOGY SCHOOL

HOPE TECHNOLOGY SCHOOL. Final Presentation – Dec 9, 2011. Agenda. Project Background Project Evolution (DP I, II & III) ER Diagram Relational Schema Forms Queries Normalization Analysis. Our Client. Hope Technology School + Palo Alto, CA (2001) +”Technology as the Great Equalizer”

seda
Download Presentation

HOPE TECHNOLOGY SCHOOL

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. HOPE TECHNOLOGY SCHOOL • Final Presentation – Dec 9, 2011

  2. Agenda • Project Background • Project Evolution (DP I, II & III) • ER Diagram • Relational Schema • Forms • Queries • Normalization Analysis

  3. Our Client • Hope Technology School • + Palo Alto, CA (2001) • +”Technology as the Great Equalizer” • + Partnered with H.P. • + Aims to raise special education standards around the world • + Help them Operate and Expand

  4. Purpose Results For The World

  5. Problem Paper Is

  6. Solution Database “Streamlines & Centralizes the flow of knowledge and leads to breakthroughs” –

  7. ER Diagram

  8. ER Diagram

  9. ER Diagram

  10. ER Diagram

  11. ER Diagram

  12. Relational Schema Strong Entities 1 Child(HIDp, CID3,Relationship,Lname, Fname,DOB,Financial Aid) 1a Student(HID1,SIDp, Expected_Grad_Date) 1b Alumni(HID1, AIDp, SID1a,DID5, Grad_Date, HS_Name, HS_Grad_Date,College,College_Grad_Date, HS_GPA, Employment) 1c Therapy_Patient(HID1, TIDp) 2 Staff(StIDp, DID5, Lname, Fname, Position, Bdate, Email, Phone, Address, SSN) 2a) Employee(StID2, EIDp, Wage,Position) 2b) Volunteer(StID2, VIDp) 2c) Teacher(StID2, TEIDp,Salary) 2d) Therapist(StID2, THIDp,Salary, Title) 3 Primary_Contact(CIDp, DID5, Lname, Fname, Phone, Email, Address) 4 Vendor(VendorIDp, DID5,Name, Type) 5 Donor(DIDp, Name, Phone_N, Email, Total_Value_Donated, Address)

  13. Relational Schema Strong Entities 6 Resource_Type(RTIDp, DID5, DonID12, Type) 6a Software_Type(RTID6, SFTIDp, Name, Version, Price) 6b Hardware_Type(RTID6, HTIDp, Name, Version, Price) 6c Facility_Type(RTID6, FTIDp, Facility_Type) 6d Supply_Type(RTID6, SUTIDp, Supply_Type, Price/Unit) 7 Specialty_Area(SpecNamep, Field) 8 Wish_Tech(PIDp, VendorID4,StID2, Status, Value, Name) 11 Transaction(TranIDp, VendorID4,BID10,CID10, DID12, DonID12,StID2, Date, Time, Amount) 20 Class(CoIDp, RTID6c,FTID6c, Course_Name, Year/Semester, Subject, Class Level, Start_Time, End_Time)

  14. Relational Schema Weak Entities 9 Standardized_Test(SIDa,Test_Namep, Grade, Month/Year, Accomodations) 10 Bill(CID3, BIDp, Date, Amount, Items) 12 Donation(DID5, DonIDp, Date, Category) 13 Software_License(LicNump, RTID6a,SFTID6a, Serial_Num14, RTID14, HTID14, License_No, Date_installed, Expiration_date, Warranty) 14 Hardware_Inventory(Serial_Nump, RTID6b, HTID6b, Condition) 15 Facility(RoomNump, RTID6c, FTID6c, Capacity, Condition) 16 Supply_Item(ItemNump, RTID6, d, SUTID6d, VendorID4, RTID6c,FTID6c, Last_Quantity_ordered ,When_Arrived ,Expiration) 17 Schedule(Sched_Nump, StID1a, Start- Date/Time, End-Date/Time, Name of Event, Comments) 18 Attendance(Date_Timep, CoID20, Present/Total) 21 Grade(GIDp, SID1a, TEID2c,CoID20, Grade, Comment) 22 Technology_Session(Date_Timep, HID1Serial_Num14, RTID14,HTID14,RTID6a,SFTID6a, StID2, SpecName7,ISPID24,SID24, Pass/NotPass,Goal_Description,Total_Time,Comments) 23 Therapy_Session(Date_Timep, HID1, SpecName7,StID2d, THID2d, ISPID24, SID24,Total_Time,Pass/NotPass,Goal_Description, Comments) 24 ISP(ISPIDp, SID1a, CID3, History,Comments)

  15. Relational Schema N-M Relationships 25 H_F_WasUsedIn(RoomNum15, RTID15,FTID15,Serial_Num14, RTID14,HTID14, Date, Time) 26 V_F_WasIn(RoomNum15, RTID15,FTID15,StID2b, VID2b, Date, Time) 27 S_A_IsRecordedIn(Date_Time18,CoID18, HID1a,SID1a) 28 H_S_IsUnderJurisdictionOf(Serial_Num14, RTID14, HTID14, StID2, Date, Time) 29 S_SA_HasSkillsIn(StID2,Specname) 30 ISP_SA_DefinesGoalsFor(ISPID24,SID24,Specname7,Year)31 V_A_AssistsA(StID2b,VID2b,StID2) 32 T_C_Teaches(StID2c,TEID2cCoID20) 33 S_C_IsInA(HID1a,SID1a,CoID20) 34Sch_F_TakesPlaceIn(SchedNum17,SID1a,RoomNum15,RTID6c,FTID6c)

  16. Relational Schema Multivalued Attributes 35 Diagnosis (ISPID24,Diagnosis) 36 Medication (ISPID24,Medication) 37 Allergy (ISPID24,Allergy) 38 Immunization_Record (ISPID24,I_Record) 39 Service (HID1a,SID1a,Service) 40 Service (HID1c, TID1c, Service, Assessment) 41 Item (DID12, DonID12, Item,Value) 42 Equipment (RoomNum15, RTID15,FTID15, E_Name)

  17. Forms: New Student

  18. Forms: Technology Session

  19. Forms: Technology Session

  20. Queries: Teacher Performance

  21. Queries: Teacher Performance

  22. Queries: Project Management Analysis

  23. Queries: Project Management Analysis SQL

  24. Queries: Therapy Demand Forecast

  25. Queries: Therapy Demand Forecast • Access Output SQL

  26. Queries: Upgrades

  27. Queries: Upgrades

  28. Queries: Markovian Quality Control

  29. Queries: Markovian Quality Control

  30. Normalization Analysis

  31. Normalization Analysis

  32. Normalization Analysis

  33. Normalization Analysis

  34. Normalization Analysis

  35. Next Steps • Complete Forms and Reports • Online Server • Security

  36. Questions ?

More Related