Question: Problem 8 (24 points) List all the tables and any candidate key relationships using the standard format ENTITYNAME (PrimaryKey ForeignKey, Descriptor). Create the corresponding table


Problem 8 (24 points) List all the tables and any candidate key relationships using the standard format ENTITYNAME (PrimaryKey ForeignKey, Descriptor). Create the corresponding table and show sample data. Explain your reasoning You manage your sales staff using the following spreadsheet (first three rows) that satisfies the INF criteria: Sales Staff Employeeld 1003 1004 1005 Customer2 GM Customer3 Salesperson Sales Office Mary Smith Chicago John Hunt New York Martin HapChicago OfficeNumber 312-555-1212 212-555-1212 312-555-1212 Customer Ford Dell Boeing HP Apple a) (8 points) Name (i.e., phrase or short sentence) four business purposes for creating this spreadsheet. b) (8 points) Convert the above data into tables satisfying 2N. Use the format ENTITY (PrimaryKey, ForeignKey for FK). Descriptori, Descriptorn) Final answer in this box c) (8 points) Convert the data into tables satisfying 3NF. Use the format ENTITY (Primarykey. ForeignKey for FK), Descriptor1, ... DescriptorN) Final answer in this box
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
