database management 37
Database case study
A school district has three schools.
â€¢Each school has its own system to manage records.
â€¢The district office wants to centralize record keeping to provide students and parents with access to teacher and student information.
â€“Phase 1: Teacher contact and Course Assignment information (Note: Course Assignment means homework assignments for a course.)
â€“Phase 2: TBD
â€¢Make high level assumptions and come up with the relational tables for Phase 1
â€¢Draw a Conceptual Data Base Model using the notation in slide title â€œConceptual Data Base Modelâ€ (see slide 24 for an example)
â€¢Define the Logical Data Base Model (see slide 25 for an example)
â€¢You may omit the Physical Data Base Model