Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

Here I am attaching refer slides.

image text in transcribed

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Illuminated

Authors: Catherine M Ricardo, Susan D Urban

3rd Edition

1284056945, 9781284056945

More Books

Students also viewed these Databases questions

Question

What does Processing of an OLAP Cube accomplish?

Answered: 1 week ago