Question: Please help me in this question in simple wording. Please answer. a b c all parts. Here I am attaching refer slides. Design a simple

Please help me in this question in simple wording. Please answer. a b c all parts.

Please help me in this question in simple wording. Please answer. a

Here I am attaching refer slides.

b c all parts. Here I am attaching refer slides. 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:

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? 18 Database Owner_ID Owner Name Jim 2 Joan . 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 Pet_ID 1 2 3 4 5 Pet Name Owner ID Fifi Butch 1 Clover Animal Tank Event_ID Pet_ID Date Type 1 1 08/20/1999 litter 2 1 08/20/2020 vet 19 Another database example student_id name age subject_id name teacher 1 Akon 17 1 Java Mr. J 2 Bkon 18 2 C++ Miss C 3 Ckon 17 3 C# Mr. C Hash 4 Dkon 18 4 Php Mr. PHP student_id subject_id marks 1 1 98 1 2 78 2 1 76 3 2 88 21 Owner ID DOwner Name Jim Joan Data Warehouse Pet ID Pet Name Owner ID Fifi Butch Clover Animal Tank 4 . Denormalized to intentionally combine Data warehouse (denormalized two tables) multiple tables into a single table Results in duplicate data in some columns Reduces number of joins necessary to query related data Online Analytical Processing (OLAP) systems Data warehouse (denormalized three tables) Pet_ID 1 2. 3 4 5 Pet Name Owner Name Fifi Joan Butch Jim Clover Joan Animal Jim Tank Jim Event_ID Pet_ID Date Type 1 1 08/20/1999 litter Pet_ID Pet_name Owner_ID Owner_Name Event_ID Date Type 1 Fifi 2 Joan 1 litter 2 1 08/20/2020 vet 08/20 /1999

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