Creating the star schema for the data warehouse

Assignment Help Database Management System
Reference no: EM132232669

Question: 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."

Reference no: EM132232669

Questions Cloud

How does the study of threats modeling help us : A responsible Citizen practices leadership, ethics, global awareness, and personal responsibility. How does the study of Threats Modeling help us contribute.
Discuss best practices use to mitigate the perceive problems : Research: Research and discuss best practices use to mitigate some of the perceive problems with cryptology from your research in discussion one.
Write a paper using the threat modeling techniques : Write a 3 to 5 page paper with proper APA formatting using the threat modeling techniques we have gone over thus far to uncover any threats that jump.
How the given theories and knowledge could be applied : Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied.
Creating the star schema for the data warehouse : 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.
Describe the given password policy : The 10 GPO Policies on the website are listed below. Select one of these policies. Write something beneficial or positive about the use of the policy.
Research on algorithm that is used in daily life : Research on Algorithm used in Daily life. For example, Map reduce algorithm. The citations should be in APA Style and should be plagiarism free.
Demonstrate a connection to your current work environment : Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment.
Develop network management strategies : CIS 532 Develop network management strategies to include resource monitoring and data collection and interpretation. Use technology and information resources.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd