Answer Happy

Page 5 of 5 0 ZOOM + In the following conceptual ER diagram, do the following tasks: 1- Convert the conceptual ER diagram to a logical ER diagram suitable for a relational database. (10 Marks ] 2- Clearly identify each primary key and foreign key. State any justifications or assumptions you make. Remember, you may have to create new entities. [8 Marks] 3- Write down the list of entities attributes, primary keys, and foreign keys of relational model according to the logical model in part (1) [5 Marks) Supplier date time PK supplierno 1..1 enrolls 1..1 0. Player Staff 0..4 PK playerNo PK staffNo 1. 1..1 1.. 1..1 plays Manages 1. Owns awarded to Game 0. PK game No numPlayers Console PK consoles Optional, 1..1 0..1 Prize Table Top ConsoleGame Minature PK prizeNc army ruleSet 1.. has

Page < 5 of 5 - ZOOM In the following conceptual ER diagram, do the following tasks: 1- Convert the conceptual ER diagram to a logical ER diagram suitable for a relational database. (10 Marks) 2- Clearly identify each primary key and foreign key. State any justifications or assumptions you make. Remember, you may have to create new entities. [8 Marks] 3. Write down the list of entities attributes, primary keys, and foreign keys of relational model according to the logical model in part (1) [5 Marks) 1.1 M AU 24 Pw PE U 1. 1. 1.1 Gare PK Console готвует 4- 11 1 Table Top Care Mat Priso VY 1