Demonstrate how would you set up a relational database for the following data. Express your design...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
Step 1 of 1 a Explanation Relational Database A relat... View the full answer
Related Book For
Materials and process in manufacturing
ISBN: 978-0471656531
9th edition
Authors: E. Paul DeGarmo, J T. Black, Ronald A. Kohser
Posted Date:
Students also viewed these accounting questions
-
How would you set up a plain column-and-knee milling machine to make it suitable for milling the flutes on a large twist drill?
-
How would you set up a study to evaluate the effects of an on-line training program versus a lecture-based approach?
-
How would you set up a horizontal milling machine to cut both sides of a block of metal simultaneously?
-
Prepare a forecast of after-tax cash flows for fiscal 2022, 2023, and 2024 for each of the two financing proposals, assuming the following: Revenue increases 5% annually. EBITDA margin is 15%. ...
-
Consider the following transactions for Derry Drug Store: Jun. 2 Derry buys $23,000 worth of inventory on account with credit terms of 2/15, n/30, FOB shipping point. 4 Derry pays a $110 freight...
-
Use the superposition principle to find io and vo in the circuit Fig. 4.79? Figure 4.79 For Prob. 4.11. 10 10 20 6 A 40 4 +30 V 10
-
Describe the forms of evidence presented by a plaintiff at trial.
-
Prince Corporation holds 75 percent of the common stock of Sword Distributors Inc., purchased on December 31, 20X1, for $2,220,000. At the date of acquisition, Sword reported common stock with a par...
-
What is the output of the following code? Enter your answer in the box below. public class CitiesInFrance public static void methodA () { } methodB(); System.out.println( "Bourdeaux"); public static...
-
What size loan must we take today with a 6% compound interest rate to have end-of-year payments of $1400, $1320, $1240, $1160, and $1080 for the next five years, respectively? In other words, if you...
-
1. Consider the following I type instruction: op rs rt constant or address Where the opcode = addi, rs = $s2 and rt=$s1. The value of register $s2 is 01001010, and the constant value is = 11101110....
-
How is domestic law (family and marriage) in Islamic law similar to Civil law?
-
How do legal frameworks, such as international treaties and conventions, contribute to establishing norms of accountability on a global scale, and what mechanisms exist for enforcing compliance among...
-
On January 1, 2022, Kingbird Outfitters signed a fixed-price contract to have Builder Associates construct a major plant facility at a cost of R$3,920,000. It was estimated that it would take 3 years...
-
The Jasmine Tea Company purchased merchandise from a supplier for $ 3 6 , 9 0 2 . Payment was a noninterest - bearing note requiring Jasmine to make five annual payments of $ 9 , 0 0 0 beginning one...
-
When a company is looking for a new CEO to replace the current CEO who is planning to retire in one or two years, should the company choose an internal candidate or an external candidate? Discuss.
-
For a Newtonian fluid: ( ( A ) ) shear stress is proportional to shear strain ( ( B ) ) rate of shear stress is proportional to shear strain ( ( C ) ) shear stress is proportional to rate of shear...
-
(a) Given a mean free path = 0.4 nm and a mean speed vav = 1.17 105 m/s for the current flow in copper at a temperature of 300 K, calculate the classical value for the resistivity of copper. (b)...
-
Why might you use a shrink fit rather than welding to join two steel parts? What does the word shrink imply?
-
How does the Guerin process reduce the cost of tooling?
-
What are the six major mechanisms that can be used to increase the strength of a metal?
-
Catherine Rampell is an economics writer for the Washington Post. In an article in 2023, she observes that the average U.S. tariff rate on mens underwear is 11.5 percent. The average rate on womens...
-
An opinion column in the Wall Street Journal argued that Americans enjoy comparative advantages in [service] sectors such as construction and engineering, but global trade in services is weighed down...
-
An article in the Wall Street Journal explained that despite rising national security tensions between the United States and China in 2023, trade between the two nations was rising. China is a...
Study smarter with the SolutionInn App