Database case study
Aschool district has three schools.
Eachschool has its own system to manage records.
Thedistrict office wants to centralize record keeping to provide students andparents with access to teacher and student information.
Phasedapproach:
-Phase1: Teacher contact and Course Assignment information (Note: Course Assignmentmeans homework assignments for a course.)
-Phase2: TBD
Makehigh level assumptions and come up with the relational tables for Phase 1
Drawa Conceptual Data Base Model using thenotation in slide title “ConceptualData Base Model”(see slide 24 for an example)
Definethe Logical Data Base Model (see slide 25 for an example)
Youmay omit the Physical Data Base Model