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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!