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
Get step-by-step solutions from verified subject matter experts
