The following E-R diagram (Figure 6.19) represents students registering for classes for...

The following E-R diagram (Figure 6.19) represents students registering for classes for a single semester. Assume that the Registration table can hold a complete history of each individual student’s registration events. For example, if James has registered for six semesters while attending the university, then the Registration table will contain six separate records (rows) for James.

a. Determine the maximum cardinalities for the E-R diagram and draw the diagram using Microsoft Visio (or other software).

b. Then provide primary keys for each table and show how the tables would be linked together in a relational database such as Microsoft Access.