Question: Develop a data model for the following partial university course offerings ; We would like to record the name, email, phone and ID about each

Develop a data model for the following partial university course offerings ;

We would like to record the name, email, phone and ID about each student.

We would like to record the code, name and ID of each course.

A student may register in zero or many courses

A course can be registered in it zero or more student

We would like to record the name, phone, address and ID of every faculty

A faculty may teach zero or more courses.

A course is delivered by only faculty. A faculty advises many students.

A student has only one advisor.

A faculty may have one dependent or more

We would like to record name, relationship of every depend

A course should have one or more textbooks

A textbook can be used by one or more courses.

We need to record the title, ISBN, publisher and year for every textbook.

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 General Management Questions!