1. Engineering
  2. Computer Science
  3. a small online salesretail company that sells accessory items for...

Question: a small online salesretail company that sells accessory items for...

Question details

A small online sales/retail company that sells accessory items for cell phones, tablets, and notebook computers . see the sample data below. Arrange the data according to relational database concepts learned in class.  Create an Entity – Relationship Diagram  Show all your tables filled with data from below.  Identify the Keys and the foreign keys of the tables you create.  Make sure you minimize data repetition.  James Brown; 78 Smithfield Drive; phone: (214)356-6756; credit# 345234476; purchase no. 81254; purchases: Two (2) Cell Phone Cover - $24.95; One (1) Touch Screen Clear Overlay - $14.95; and Three (3) Cell Phone Car Adapter - $35.00.  Linda Foster, 23-446 Roman Street; credit # 445334978; purchase no. 82368; purchases: (2) Tablet Case; $45.95, (1) Cell Phone Car Adapter - $35.00.  Cameron Packer; 996 Blanket Cove; credit # 886445234; purchase no. 83565; phone: (423)775-3445; purchases: (2) Black Leather Notebook Case; $95.00.  Linda Foster, credit # 445334978; purchase no. 84250; purchases: (1) Touch Screen Clear Overlay; $14.95.  Jordan Monclova; 75 Clearwater street; phone (214)8745632; credit # 458753217; purchase No: 85897; purchases: (2) Cell Phone Cover - $24.95; (2) Leather Notebook Case; $95.00; and (1) Cell Phone Car Adapter - $35.00 Note

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution