PLEASE SEE ATTACHED
2. Draw and Entity-Relationship Diagram for the following: Sales of inventory are made to customers by salespeople. After the sale, cash is received by cashiers. (10 Marks – 3 Marks for Structure, 4 Marks for Entities, 3 Marks for Relationships)
3. Data Table Normalization. Using the “UN-Normalized Parking Ticket Data in the Table below,
transfer the Data to Third Normal Form (3NF). Identify Primary and Foreign Keys linking the Tables. (10 Marks – 7 Marks Tables, 3 Marks Primary/Foreign Keys)
Social Security Last First Phone Number Name Name Number 123-45-6789 Curry Dorothy (916)358-4448
License Plate Ticket State Number Number CA 123 MCD 10151
10152
10121 CA 253 DAL 10231
12051
Date 10/15/10 10/16/10 11/12/10 10/23/10 12/5/10
Code Fine
A $10 B $20 B $20 C $50 A $10
134-56-7783 Mason
0 comments