1. Explain the distinctions among the terms primary key, candidate key, and superkey.

2. Define each of the following: Weak Entity, Multi-valued Attribute, Weak Relationship

To answer exercises 3 & 4, you will be providing most of the entities, attributes, and relationships for a given database in the form of an E-R diagram. Since many of the database requirements are not given; it is up to you to design the databases (one per exercise) and to include the information you are given into the overall E-R diagram design --other than the inclusion of the information in each exercise, there is not one right database design.