Question: Create a conceptual data model relationship based on the business rules outlined below Students live in housing Housing belongs to a school A school has

Create a conceptual data model relationship based on the business rules outlined below

Students live in housing

Housing belongs to a school

A school has Instructors

Instructors have classes they teach

Students take classes

Students are identified by their student ID and also have an address to their school housing, first, last name, list of classes they take

School housing has an address, and number of rooms in the housing

Instructors have a instructor ID, first, last name, and a class ID for the classes they teach - Classes have a Class ID, a name, a time when they are taught, and an Instructor who teaches it

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!