Reference no: EM13848108
Finalize a data model and DDL. Make any needed changes to the attached ERD and Physical Data Model. Include any SQL needed for the database, the DDL, the DML to manage the customer and employee rows, and the 3 SELECT statements.
Create a star schema and the DDL to create the Star schema for the data warehouse. Implement a single Fact table to track all orders with the following dimensions: Time, Customer, Product, and Employee
Include all DDL including primary and foreign keys; feel free to create new or needed primary keys.
Develop a specific and detailed discussion about the ETL process is to be used to move data from the OLTP environment to the data warehouse.
This solution 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 with discussion on Data Warehouse Design
A description of the ETL process
Provide reference for the whole solution
Attachment:- Database Design.docx
|
Rogen corporation manufactures a single product
: Rogen corporation manufactures a single product. the standard cost per unit of product is shown below: DM 1 pound plastic at $7 per pound - $7.00 DL 2.5 hours at !12.30 per hour. 30.75
|
|
Are there gender or racial stereotypes portrayed here?
: Are there gender or racial stereotypes portrayed here?
|
|
Communication plays an important role
: Q: Communication plays an important role in any career. Do you think there should be monitoring of communication techniques and styles between different levels within the same company/business.
|
|
Conduct research on managerial communication
: Conduct research on managerial communication - outside of the textbook, focusing on the questions posed in theoutline:
|
|
Create the star schema for the data warehouse
: Develop a specific and detailed discussion about the ETL process is to be used to move data from the OLTP environment to the data warehouse - Create a star schema and the DDL to create the Star schema for the data warehouse.
|
|
Effective meetings are not only integral to achieve
: Effective meetings are not only integral to achieve team goals and successful completion of tasks, but also are reflective overall of team functioning. What are the ways a manager can organize effective productive meetings.
|
|
Define components of the acronym smart in goal setting
: Identify at least four forces in the general environment of organizations and provide an example of each for an industry or business. How do these forces differ from the external stakeholders in the task environment?
|
|
Create your own function that accepts one input parameter
: Create your own function that accepts one input parameter and returns a float number. You decide the theme. You should provide the pseudocode and an example call. Be sure to provide an overview of what your function is doing.
|
|
Problem based on laplace transform
: Show transcribed image text Y(s) = ? Discontinuous Forcing Functions: Problem Take the Laplace transform of the following initial value problem and solve for Y(s) = Laplace {y(t)}: y'' - 2y' - 35y = S(t) y(0) = 0, y'(0) = 0
|