Pick and define 5 key terms from the list below. Use at least 30 words for each definition. data mining, database, data warehouse, operational data, organization data, OLTP, OLAP, denormalization, CRISP-DM, and out-of-sync data
Part 1: Pick and define 5 key terms from the list below. Use at least 30 words for each definition. data mining,
Design a simple relational database for Amazon with at least three tables. Answer the following questions for your design: a. What might a data set look like given your database after denormalization? 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?
Step by step
Solved in 4 steps