V. A room stores many equipment types, and an equipment type can be stored in many...

Transcribed Image Text:

V. A room stores many equipment types, and an equipment type can be stored in many rooms Activity #2 Given the incomplete ER diagram below: BadgeNo Name TRAFFIC POLICE Rank issues Summon No Offense SUMMON Datelssued FineAmt Timelssued given To LicenseNo DRIVER Name a) Add connectivity information to the diagram based on the following narration: A traffic police officer can issue many summonses. However, a summons can only be issued by one traffic police officer. Moreover, a summons is for one driver, and a driver might get more than one summons. b) c) d) Create a table for each of the entities above; and fill them with at least 3 lines of data each. From the data entered in (b), determine which of the given attributes are identifiers in each table Select one of the identifiers to be the primary key for each table V. A room stores many equipment types, and an equipment type can be stored in many rooms Activity #2 Given the incomplete ER diagram below: BadgeNo Name TRAFFIC POLICE Rank issues Summon No Offense SUMMON Datelssued FineAmt Timelssued given To LicenseNo DRIVER Name a) Add connectivity information to the diagram based on the following narration: A traffic police officer can issue many summonses. However, a summons can only be issued by one traffic police officer. Moreover, a summons is for one driver, and a driver might get more than one summons. b) c) d) Create a table for each of the entities above; and fill them with at least 3 lines of data each. From the data entered in (b), determine which of the given attributes are identifiers in each table Select one of the identifiers to be the primary key for each table