$1.)$ Specify the minimum number of relationship sets needed in order to:

a$.$ Link the courses that a student is enrolled in and the assignments that have been assigned to

that student

b$.$ Link assignments to courses

c$.$ Link Instructors to the courses they teach and the assignments in each course

$2.)$ For each of the relationships in part $1,$ indicate:

a$.$ The mapping cardinality

b$.$ Whether the participation of each entity set in the relationship is partial or total

c$.$ Any attributes of the relationship set

$3.)$ Which of the entity sets from assignment $1$ should be a weak entity set? What is the

identifying relationship? What is the owner entity set? What is the discriminator for the entity set?

$4.)$ Draw the entity relationship diagram for the homework tracking application. Use look$-$across

mapping cardinalities, and specify the minimum and maximum cardinality,

$5.)$ Reduce E$-$R model to a relational model. Be sure to specify the following:

a$.$ All tables in the model. If it is possible to eliminate a table, without losing information or

introducing the need to store null values, you should do so$.$

b$.$ The primary keys for each table.

c$.$ All foreign keys.