Question: Demonstrate how would you set up a relational database for the following data. Express your design completely, showing all the data fields and records


Demonstrate how would you set up a relational database for the following data. Express your design completely, showing all the data fields and records in the proper places based on the data below. You will need to show all your tables filled with data from below. You will not have to provide record layouts for any of your tables. The data for your database is in the narrative below: A small online sales/retail company called OnlineSalesCo sells accessory items for cell phones, tablets, and notebook computers. See the sample data below. James Brown; 78 Smithfield Drive; phone: (214)356-6756; credit# 345234476; purchase no.'s 81254.1 - 81254.3; purchases: (1) Blue Cell Phone Cover - $24.95; (1) Touch Screen Clear Overlay - $14.95; and (1) Cell Phone Car Adapter - $35.00. Linda Foster, 23-446 Roman Street; credit # 445334978; purchase no.'s 82368.1 - 82368.2; purchases: (1) Red Tablet Case; $45.95, (1) Cell Phone Car Adapter - $35.00. Cameron Packer; 996 Blanket Cove; credit # 886445234; phone: (423)775-3445; purchase no. 83565.1; purchases: (1) Black Leather Notebook Case; $95.00. Linda Foster, credit # 445334978; purchase no. 84250.1; purchases: (1) Touch Screen Clear Overlay; $14.95. Notes: The owner would like to use the customer credit number as a way of locating each customer in the system. Purchase numbers have a one-to-one relationship with products. In assessing the design, you consider each customer transaction (above) occurred on a different business day for each week in the month of September 2020. Arrange the data according to relational database concepts learned in class. a) Show the data in one table (file) with all your data records. a. Explain why this would not be a good way of organizing data on disk. b) Convert the unnormalized sales table (file) to a relational database design. Fill each database table in your design with data from the question such that no information is lost. Identify the data fields, primary key, foreign key, and compound keys. a. Describe why it is better to store data on disk in this way rather than all in one table. c) Create an Entity Relationship Diagram for the Database
Step by Step Solution
3.41 Rating (160 Votes )
There are 3 Steps involved in it
Step 1 of 1 a Explanation Relational Database A relat... View full answer
Get step-by-step solutions from verified subject matter experts
