A description on the features of enhanced erd

Assignment Help Database Management System

Reference no: EM13786233

Based on the feedback you have received with respect to your data model and DDL, now is your chance to implement the final changes. Make any needed changes to your ERD and Physical Data Model and submit for final review. Include any SQL needed for the database, the DDL, the DML to manage the customer and employee rows, and the 3 SELECT statements. In addition, submit the star schema and the DDL to create the Star schema for the data warehouse.

You want a single Fact table to track all orders with the following dimensions: Time Customer Product Employee Be sure to include all DDL including primary and foreign keys; feel free to create new or needed primary keys. Finally, a specific and detailed discussion about the ETL process is to be used to move data from the OLTP environment to the data warehouse.

Your submission should include the following: A description on your approach The features of your enhanced ERD A discussion about handling the M:M relationship between customer and products The approach used to ensure 3NF Required SQL statements for the database Star schema for the fact table and its 4 dimension tables The DDL for the Star schema for the data warehouse A description of the ETL Add the Data Warehouse Design and discussion about the ETL process to the project template section titled "Web and Data Warehousing and Mining in the Business World." Name the document CS352__IP5.doc. Submit your Word document and make sure that it contains: A Screenshot of the ERD, logical data model from previous assignments. The DDL to create the tables, including the table definition and the primary and foreign key definitions 1-2 pages describing the solution Star Schema DDL for a Star schema 2-3 paragraphs about the ETL process

Reference no: EM13786233

Questions Cloud

Estimate the machines production under these conditions : Estimate the machines production under these conditions using the travel time curves given in the Caterpillar Performance handbook.

Sense of your own value & the goodness of life : In writing this paper, ignore the taboo about boasting and bragging. What besides your achievements brings you happiness and a sense of your own value & the goodness of life?

Disposal of high-level radioactive waste. : Why is this not a good idea? Explain what can happen at a subduction zone and what might occur if the waste were buried there.

What capacity should their involvement be : The entire SDLC process can be very lengthy and require a lot of planning. Who are the people that should be involved in the SDLC process? In what capacity should their involvement be?

A description on the features of enhanced erd : A description on your approach The features of your enhanced ERD A discussion about handling the M:M relationship between customer and products The approach used to ensure 3NF Required SQL statements for the database Star schema

Model fit the human performance data : Kozma et al. present a contemporary mathematical model of human behavior under some environmental constraints. How well does their model fit the human performance data? Is their solution algorithm blind overall to error reduction between input and as..

What are the phases of SDLC : What are the phases of SDLC? Please select one of the SDLC phases and describe it. What should be accomplished in that phase?

How are women represented in novel the good cripple : How are women represented in the novel The Good Cripple by: Rodrigo Rey Rosa? Who are these women? Is gender inquality a key issue in this novel? How so, Why?

Discuss the importance of integrating sales and operations : In this lesson, we discuss the importance of integrating sales and operations. This idea of integrated management is indeed a key tenet of supply chain and operations management practices today.

User Account

All Pages