Advanced database design final project

Assignment Help Basic Computer Science

Reference no: EM132884346

Advanced Database Design Final Project

Topic 1: Real World or personal demonstration.

1. Demonstrate something you have done at work, at class, at home, etc. where you have used OLTP, Data Warehouse, NoSQL, or Hadoop.

2. Get Approval of the topic from the Professor.

Topic 2: Project Part 1 - The Normalized OLTP Database.

3. What data needs to be captured from the sees website for orders, shipments, customer information, and customer payments?

4. What is your basic database schema?

5. Why did you choose this schema?

6. How often would you need to back up this database?

7. At Sees, who would you expect to use this database?

8. What would you expect your standard reports from this database to be? Describe them in general.

Topic 3: Project Part 2 - The Data Warehouse Database

1. What was your proposed Data Warehouse Bus design? Briefly explain why you made the choices you did for your bus.

2. How would you propose getting your data from your OLTP database into your DW?

3. What were the 5 aggregates you proposed, and why did you propose them?

4. Why would Sees management want to have a Data Warehouse?

5. Who in the Sees management team would use the Data Warehouse, and what do you think they would use it for?

6. What information could management get out of the Data Warehouse?

Topic 4: Project Part 3 - The Document Database

1. The topic is to compare and contrast this approach with the approach used in Project Part 1.

2. Can the same Customer data be captured into MongoDB as you captured into the OLTP database?

3. Compare the ease of storing a customer's purchase into MongoDB vs storing a customer's purchase into your OLTP database.

4. Compare the ease of reporting on product purchases from MongoDB vs reporting those same product purchases from an OLTP database.

5. Speaking as a DBA, which platform gives you more control over your schema, the OLTP database or MongoDB? Explain your answer.

Speaking as a programmer, which platform gives you more flexibility over the schema and schema redesign? Explain your answer.

Reference no: EM132884346

Questions Cloud

What are some qualities nietzsche would say a fulfilled life : What are some qualities Nietzsche would say a fulfilled life should have, and why these qualities would be good to have. Why are difficulties a major part in li

What are the best measure to comply to avoid violations : Why healthcare compliance is so important in healthcare organizations? What are the best measure to comply to avoid violations?

Use for anger management training : Based on the production company Netflix, Identify the training methods that you will use for anger management training.

Is the state justified in redistributing wealth : Robert Nozick and John Rawls' debate by articulating a well-reasoned defense that addresses the question: Is the state justified in redistributing wealth?

Advanced database design final project : Demonstrate something you have done at work, at class, at home, etc. where you have used OLTP, Data Warehouse, NoSQL, or Hadoop.

Organization development theorists : Conduct research on three (03) organization development theorists and briefly explain each of their theories.

Explain scientific cognitivism : Explain scientific cognitivism and how proponents of such a view would explain our aesthetic appreciation of the Grand Canyon (be specific!).

What is cultural appropriation : What is cultural appropriation? Name at least two different kinds of appropriation and give a description of each along with an original example of each

About how these concepts apply to your life : Think about how these concepts apply to your life, and describe how you use devices such as these in your day-to-day life.

User Account

All Pages