Design a simple relational database for Amazon with at least three tables (refer to slides 18,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Design a simple relational database for Amazon with at least three tables (refer to slides 18, 19 and 21). Answer the following questions for your design: a. What might a data set look like given your database after denormalization? (refer to slide 21, the pet example. Include at least one observation/row of data. You may use makeup/fake data.) b. What questions might be answered with this (denormalized) data? You may assume the data set is big. c. Are there any privacy/security issues related to your (denormalized) design? How would you protect against these issues? Organized grouping of information within a specific structure Relational databases most common today Relate tables to one another in a logical fashion Tables are broken apart to reduce redundancy through normalization Event_ID ● ● Database 1 2 Pet_ID 1 1 Date 08/20/1999 08/20/2020 Owner IDDOwner Name Jim Joan Pet ID Type litter vet 21 1 2 31 4 5 Pet Name Fifi Butch Clover Animal Tank Owner ID 1 18 Another database example student_id 1 2 3 4 name Akon Bkon Ckon Dkon student_id 1 1 2 age 3 17 18 17 18 subject_id 1 2 1 subject_id 2 1 2 3 4 marks 98 78 76 88 name Java C++ C# Php teacher Mr. J Miss C Mr. C Hash Mr. PHP 19 1 ● 2 Data Warehouse Denormalized to intentionally combine multiple tables into a single table Event_ID ● Results in duplicate data in some columns Reduces number of joins necessary to query related data Online Analytical Processing (OLAP) systems Pet_ID 1 1 Date 08/20/1999 Type litter 08/20/2020 vet 1 Fifi Owner IDDOwner Name Jim Joan 1 2 3 4 5 Pet ID Data warehouse (denormalized two tables) Pet ID 2 4 Pet_ID Pet_name Owner_ID Owner Name Joan Pet Name Owner ID Fifi Butch Clover Animal Tank Data warehouse (denormalized three tables) Event ID Pet Name Owner Name Fifi Butch Joan Jim Clover Joan Animal Jim Tank Jim 1 Date 08/20 /1999 21 Type litter Design a simple relational database for Amazon with at least three tables (refer to slides 18, 19 and 21). Answer the following questions for your design: a. What might a data set look like given your database after denormalization? (refer to slide 21, the pet example. Include at least one observation/row of data. You may use makeup/fake data.) b. What questions might be answered with this (denormalized) data? You may assume the data set is big. c. Are there any privacy/security issues related to your (denormalized) design? How would you protect against these issues? Organized grouping of information within a specific structure Relational databases most common today Relate tables to one another in a logical fashion Tables are broken apart to reduce redundancy through normalization Event_ID ● ● Database 1 2 Pet_ID 1 1 Date 08/20/1999 08/20/2020 Owner IDDOwner Name Jim Joan Pet ID Type litter vet 21 1 2 31 4 5 Pet Name Fifi Butch Clover Animal Tank Owner ID 1 18 Another database example student_id 1 2 3 4 name Akon Bkon Ckon Dkon student_id 1 1 2 age 3 17 18 17 18 subject_id 1 2 1 subject_id 2 1 2 3 4 marks 98 78 76 88 name Java C++ C# Php teacher Mr. J Miss C Mr. C Hash Mr. PHP 19 1 ● 2 Data Warehouse Denormalized to intentionally combine multiple tables into a single table Event_ID ● Results in duplicate data in some columns Reduces number of joins necessary to query related data Online Analytical Processing (OLAP) systems Pet_ID 1 1 Date 08/20/1999 Type litter 08/20/2020 vet 1 Fifi Owner IDDOwner Name Jim Joan 1 2 3 4 5 Pet ID Data warehouse (denormalized two tables) Pet ID 2 4 Pet_ID Pet_name Owner_ID Owner Name Joan Pet Name Owner ID Fifi Butch Clover Animal Tank Data warehouse (denormalized three tables) Event ID Pet Name Owner Name Fifi Butch Joan Jim Clover Joan Animal Jim Tank Jim 1 Date 08/20 /1999 21 Type litter
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
What should be considered when creating podcast content?
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
(A) If the percent yield for the formation of urea in Example 4-13 were 87.5%, what mass of CO 2 , together with an excess of NH 3 would have to be used to obtain 50.0 g CO(NH 2 ) 2 ? (B) Calculate...
-
In an automated filling operation, the probability of an incorrect fill when the process is operated at a low speed is 0.001. When the process is operated at a high speed, the probability of an...
-
A converging lens has a focal length of 88.00 cm. An object 13.0 cm tall is located 155.0 cm in front of this lens. (a) What is the image distance? (b) Is the image real or virtual? (c) What is the...
-
A 2-m-diameter pipe made of finished concrete lies on a slope of 1-m elevation change per \(1000-\mathrm{m}\) horizontal distance. Determine the flowrate when the pipe is half full.
-
Venetian Company has two production departments, Fabricating and Assembling. At a department managers meeting, the controller uses flexible budget graphs to explain total budgeted costs. Separate...
-
If triangles ABC and DFG are similar triangles and side DF = 218, what is the value of side DG?
-
Complete Alvins Music Inc.s (AMI) 2020 Form 1120, Schedule D, and Schedule G (if applicable) using the information provided below. Neither Form 4562 for depreciation nor Form 4797 for the sale of...
-
Ralph purchases a painting for display in the reception area of his business' office. This painting is a work of art that is expected to appreciate in value. a. May Ralph capitalize and depreciate...
-
o pts Please answer the next question based on the following quotes on currency options contracts for Swiss francs (CHF), where each contract has 62.500 CHFs Exercise prices, call and put premiums...
-
Naz Sdn. Bhd. involves in a car maintenance program. Listed below are the business rules for the company. (1) (2) (3) (4) (5) (6) A customer can own many cars Some customers do not own cars. (a) (b)...
-
Required: 1. Include a logical data-flow diagram of the current dispatching system, 2. Propose improvement to the logical data-flow diagram to the dispatching system and state the expected benefits...
-
Katrina owns undeveloped land with an adjusted basis of $300,000. She exchanges it for other undeveloped land worth $750,000. Assume that Katrina holds the land as an investment. If an amount is...
-
Periodic inventory by three methods; cost of goods sold The units of an item available for sale during the year were as follows: Jan. 1 Mar. 10 Aug. 30 Inventory Purchase 180 units at $108 224 units...
-
In accounting, what is a ledger?
-
How much more interest will be earned if $5000 is invested for 6 years at 7% compounded continuously, instead of at 7% compounded quarterly?
-
Is it good or bad for corporations to rely on vendors for computing support? List arguments both for and against reliance on vendors as part of your answer.
-
How can CSSs and XSL help to ensure design consistency when designing an Internet-based electronic commerce system?
-
Review the material in Chapter 4 on corporate and information systems strategic planning. How are these processes different from BPR? What new perspectives might BPR bring that classical strategic...
-
How does the estimated ending inventory impact the individual income tax return ending inventory, cost of goods sold, net profit, and net income? Find out by adding an additional column for 2015 and...
-
Input information from the SBA Personal Financial Statements given to Sharptop Bank into a spreadsheet. a. Separate personal items (e.g., residence) from business items (e.g., inventory). b....
-
If the tax return or insurance claim is misstated, did Greg Larsen commit some form of financial statement fraud?
Study smarter with the SolutionInn App