Page 5 Of 5 0 Zoom In The Following Conceptual Er Diagram Do The Following Tasks 1 Convert The Conceptual Er Diagra 1 (109.26 KiB) Viewed 30 times
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!