Question: (a) Consider that you are asked to design an entity relationship diagram based on the below scenario: A university consists of a number of departments
(a) Consider that you are asked to design an entity relationship diagram based on the below scenario: A university consists of a number of departments (id, d_name) and each department offers some courses. A number of modules make up each course. Students enroll their Id, full name, and gender in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department.
(b) We can convert any weak entity set to a strong entity set by simply adding appropriate attributes. Why, then do we have weak entity sets? Write about the weak entities for several reasons.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
