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: Customers SalesStaff Employeeld 1003 1004 1005 SalesPerson Mary Smith John Hunt Martin Hap Sales Office Chicago New York Chicago Office Number 312-555-1212 212-555-1212 312-555-1212 Customer Ford Dell Boeing Customer GM HP Apple a 18 points) Name (ie, phrase or short sentence) four business purposes for creating this spreadsheet b) (8 points) Convert the above data into tables satisfying 2NF. 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 (or FK), Descriptori, .... 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
