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: 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

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!