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

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!