Question: Question 3 (2 points) A small college database has the following structure. A department has many lecturers. A lecturer belongs to only one department. The

 Question 3 (2 points) A small college database has the following

Question 3 (2 points) A small college database has the following structure. A department has many lecturers. A lecturer belongs to only one department. The department offers many different courses, and many lecturers can teach a single course. Lecturers can also teach more than one course. Many students enroll for many courses Draw an ERD for this system using the (min, max) notation. Question 4(3 Draw ERD segments, with (minmax)to reflect the following: 1. An apartment has one or more rooms. A room belongs to one apartment 2. A person may own many apartments and an apartment is owned by one and only one person. 3. An architect may design many buildings and a building is designed by at least one archtect

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!