In class practice: Turn each ER diagram into a database diagram by identify the primary keys and creating foreign keys. Insert new columns or tables as needed. Also, if necessary, specify what must be done to enforce maximum and minimum cardinality (referential integrity constraints, NOT NULLs, and candidate keys).