American Commercial College of Texas Conceptual Data Base Model Paper

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.

•Phased approach:

–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