Sales Schema

The interaction with a data warehouse using MS SQL to understand the dimension tables and fact tables of the Internet Sales Business Data Mart using MS SQL Server Management Studio. You will then describe the extraction, transformation, and load process for the Internet Sales Business Data Mart

1. For the Internet Sales Business Process:

A. Define the grain in business terms.

B. Identify and provide a description for each dimension.

C. Identify and provide a description for the facts that are being measured.

D. Identify the various uses (fields in the Internet Sales Fact Table) for the date dimension.

E. Describe the fields used by the date dimension.

F. Draw the dimensional model (you may use MS Visio, an ER tool, or hand draw). Show the dimensions, fact table, primary keys, foreign keys, and cardinality of relationships.

G. Query each table. Show the SQL statement and first 10 rows of the table.

2. Review the ETL process for the Internet Sales Business Data Mart in a 350- to 450-word summary.

The summary should review the entities in the business matrix model for the Internet Sales Business Process. As part of the summary, you need to review three of the 34 Kimball ETL subprocesses (i.e., data cleansing system, error event tracking audit dimension creation) in respect to the Internet Sales Business Data Mart.

3. Answer the following for the Sales Schema of the AdventureWorks2012® database.

  1. Identify and provide a description for each table.
  2. Draw the entity relationship diagram (you may use MS Visio, an ER tool, or hand draw). Show the entities, attributes, primary keys, foreign keys, and cardinality of the relationships.
  3. Query each table. Show the SQL statement and first 10 rows of the table.

Rubric for step 3

3. Transactional Database Concepts
A. Student identifies and provides a description for each table in the Sales Schema.
B. Student draws the entity relationship diagram, showing the entities, attributes, primary keys, foreign keys, and cardinality of the relationships.
C. The student queries each table, showing the SQL statement and first 10 rows of the table.

All work should be in MS Word with screen shots for each requirement.

Do you need help with this assignment? Or a different one? We got you covered.

Quality Guaranteed

Any Deadline

No Plagiarism