Section Relationshine 25 For the problem isted below, create an entity relationship diagram (ERD) using these constraints Please add your student name and number to the exam paper. List all entities, attributes, primary key and foreign keys in the relational model (note: not all attributes are given so you will have to apply your knowledge of ER modelling, system analysis when listing attributes) . Each relationship must be shown and must have the correct cardinality: ER Case Study A large organization has many departments that hire many employees. The organization has several parking lots, which are used by the staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate). Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number Section 3 Normalization - 25% Look at the un-normalized table shown in Figure 1. Normalize the table to the 3rd Norm Form. Please show the first normal form, second normal form and the third normal form. Invoice Table QUANTITY INVOICE NUM 14216 14219 14219 14224 INVOICE DATE 11/15/2021 11/15/2021 11/15/2021 11/16/2021 11/16/2021 11/18/2021 11/15/2021 115/2021 1 V18/2021 1/18/2001 11/11/2021 ITEM ID CA75 AD72 DT12 LD14 KUSI FS12 PF19 UF39 KHS1 Q092 WB49 LP73 DESCRIPTION Enclosed Cat Litter Station Dog Feeding Station Dog Toy Gut Sot Locking Small Dog Door Wild Bird Yood (25 lb) Aquarium (55 Gallon) Pump & Filter Kit Underground Fence System Wild Bird Food (25 lb) Quilted Stable Blanket Insulated Water Bucket Lang Pet Carrier QUOTED PRICE $37.99 579,99 $39.99 $17.99 SI5.99 1 $124.99 $74.99 2 $19.99 $19.99 $109.95 + $74.95 $5495 201 Section Relationshine 25 For the problem isted below, create an entity relationship diagram (ERD) using these constraints Please add your student name and number to the exam paper. List all entities, attributes, primary key and foreign keys in the relational model (note: not all attributes are given so you will have to apply your knowledge of ER modelling, system analysis when listing attributes) . Each relationship must be shown and must have the correct cardinality: ER Case Study A large organization has many departments that hire many employees. The organization has several parking lots, which are used by the staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate). Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number Section 3 Normalization - 25% Look at the un-normalized table shown in Figure 1. Normalize the table to the 3rd Norm Form. Please show the first normal form, second normal form and the third normal form. Invoice Table QUANTITY INVOICE NUM 14216 14219 14219 14224 INVOICE DATE 11/15/2021 11/15/2021 11/15/2021 11/16/2021 11/16/2021 11/18/2021 11/15/2021 115/2021 1 V18/2021 1/18/2001 11/11/2021 ITEM ID CA75 AD72 DT12 LD14 KUSI FS12 PF19 UF39 KHS1 Q092 WB49 LP73 DESCRIPTION Enclosed Cat Litter Station Dog Feeding Station Dog Toy Gut Sot Locking Small Dog Door Wild Bird Yood (25 lb) Aquarium (55 Gallon) Pump & Filter Kit Underground Fence System Wild Bird Food (25 lb) Quilted Stable Blanket Insulated Water Bucket Lang Pet Carrier QUOTED PRICE $37.99 579,99 $39.99 $17.99 SI5.99 1 $124.99 $74.99 2 $19.99 $19.99 $109.95 + $74.95 $5495 201
