360 likes | 500 Views
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”
E N D
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” • + Partnered with H.P. • + Aims to raise special education standards around the world • + Help them Operate and Expand
Purpose Results For The World
Problem Paper Is
Solution Database “Streamlines & Centralizes the flow of knowledge and leads to breakthroughs” –
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)
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)
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)
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)
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)
Queries: Therapy Demand Forecast • Access Output SQL
Next Steps • Complete Forms and Reports • Online Server • Security