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