Design an Entity-Relationship Model (ER Diagram) for the modeling scenario of your choice. Use entities (rectangles), relationships (diamonds) and attributes (ovals) to model the information above. Clearly indicate primary keys (underlined attributes) and the cardinalities with which an entity participates in a relationship (express the participation of an entity to a relationship with a pair of (minimum, maximum) or alternatively, you can use the arrow notation of the textbook).

Phase II

Translate your Entity-Relationship Model (ER Diagram) from the question above into a logical model (DB Schema). For each relation in your schema, provide its name, attributes and keys (underlined attributes).