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

(12 marks) 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 CustomSalesCo 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

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 Accounting Questions!

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

2. . 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...

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

this is my assessment which are am going to send you and i need some things about my assessment : Adding some more detail and diving into the case study a bit deeper would really make your points...

PROJ6000: Principles of Project Management Assessment Assessment 2 - this is actually a case study and its called a Individual Report: PMBoK versus PRINCE2 or Agile in contemporary projects . so one...

PROJ6000: Principles of Project Management Assessment 3 - Project Charter Report. Length 2,000 words (+/- 10%) Task Summary After reading the project case study, use it to develop a 2,000-word...

1. Read the case study below. This will form the basis for your Project Charter, because you will assume that you are the project manager for this project. 2. After reading the case study, begin to...

What are relevant costs? Provide several examples for the decision to repair or replace a piece of equipment.

At 1/1/19, Neils basis in his Partnership interest is 100,000. At the end of the year, his allocated share of Partnership Ordinary Business Income was 12,000. He then received the following as a...

BE5.6 (LO 3) Steve Madison needs $250,000 in 10 years. How much must he invest at the end of each year, at 5% interest, to meet his needs?

Hugo decides to buy his Christmas gifts on Black Friday. To simplify his life, he is giving his 10 closest friends scarves for Christmas and everyone else Christmas cards. Hugo is willing to pay up...