Question: Star Schema - Fill in the table's fields. table [ [ Table Name? ] , [ ] , [ ] , [ ] ,

Star Schema - Fill in the table's fields.
\table[[Table Name?],[],[],[],[],[],[],[],[],[],[]]
Table Name?
Table Name?
Table Name? Please re-submit this document with your completed "Star Schema" design. (see page 2)
Project description:
Please use the TAL database. Your task is to redesign the TAL database into a Data Warehouse.
Fill each table with the field names for each table. Please use (as much as possible) ALL of the
fields in the TAL database. Don't forget to label your table.
TAL data schema: As it exist now. Remember that this is an OLTP design. You will need to
change it into an OLAP design (Data Warehouse). I recommend that you use a star schema. I
have 4 Dimension tables in the current design (page 2) but you don't need to use all four. HINT:
maybe only three may be used.Please re-submit this document with your completed Star Schema design. (see page 2)
Project description:
Please use the TAL database. Your task is to redesign the TAL database into a Data Warehouse. Fill each table with the field names for each table. Please use (as much as possible) ALL of the fields in the TAL database. Dont forget to label your table.
TAL data schema: As it exist now. Remember that this is an OLTP design. You will need to change it into an OLAP design (Data Warehouse). I recommend that you use a star schema. I have 4 Dimension tables in the current design (page 2) but you dont need to use all four. HINT: maybe only three may be used.
Star Schema - Fill in the table's fields. \ table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!