Using the shorthand notation introduced the text

Database: Lab 1 Assignment

Lab 1.1:

For each of the following pairs of related entities, indicate whether (under typical circumstances) there is a one-to-many or a many-to-many relationship. Then, using the shorthand notation introduced in the text, draw a diagram for each of the relationships.

e. INSTRUCTOR and COURSE

f. COURSE and SEMESTER

b. The fact that the driver’s name is a 30-character field.

c. A photo image of the driver

h. The fact that the driver’s birth date must precede today’s date by at least 16 years.