Mapping Conceptual Database Designs to Logical Designs

1. For the ER diagram shown below, perform the ER-to-relational mapping: write down each relational schema, and indicate any referential constraints. Identify primary keys for each schema.

2. For the ER Diagram of the lecture notes (the Employe-Department-Project example), use the ER-relational mapping guidelines to convert the diagram into a relational database schema. For each of your relational schemas, indicate the primary and foreign keys.