What data set look like given database after denormalization

Assignment Help Database Management System

Reference no: EM133766358

Discussion Post: Data Analytics & Business Data Mining- Introduction to Data Mining

Part A

Pick and define 5 key terms from the given list below. Use at least 30 words for each definition.

Data mining, database, data warehouse, operational data, organization data, OLTP, OLAP, denormalization, CRISP-DM, out-of-sync data

Part B

Design a simple relational database for Amazon with at least three tables (refer to slides 17, 18, and 20).

Answer the following questions for your design:

1. What might a data set look like given your database after denormalization? (Refer to slide 20, the pet example. Include at least one observation/row of data. You may use makeup/fake data.)

2. What questions might be answered with this (denormalized) data? You may assume the data set is big.

3. Are there any privacy/security issues related to your (denormalized) design? How would you protect against these issues?

Reference no: EM133766358

Questions Cloud

Who are the two theorists that you chose : Who are the two theorists that you chose? What time period did each theorist live in? How did each theorist view child development/growth/education?

Gram positive bacteremia and septic shock : The Nurse Practitioner is caring for a patient with gram positive bacteremia and septic shock.

Describe how stress impacts the immunity of a person : What are the different types of immunities and give an example of each? Describe how stress impacts the immunity of a person.

High blood pressure-sweating and irritability : Darlene is a 67-year-old woman who has been admitted to the hospital with rapid heart rate, high blood pressure, sweating, and irritability.

What data set look like given database after denormalization : What might a data set look like given your database after denormalization? What questions might be answered with this (denormalized) data?

Discuss the parties to a contract and how they are affected : Discuss the benefits of different parties contracting for healthcare in Saudi Arabia. Discuss the parties to a contract and how they are affected.

What culture or religion that stands out to you as important : In thinking about your cultural reflections, what is a culture or religion that stands out to you as important - what would you want to learn more about?

ED for treatment of wound infection on her right leg : Case study immunity Anna Parker is a 26-year-old female coming to the ED for treatment of a wound infection on her right leg.

Examine the similarities you see in the different facilities : Examine the difference and similarities you see in the different facilities. Explain how the law impacts how these two facilities operate?

User Account

All Pages