Question: Star Schema - Fill in the table's fields. table [ [ Table Name? ] , [ ] , [ ] , [ ] ,
Star Schema Fill in the table's fields.
tableTable Name?
Table Name?
Table Name?
Table Name? Please resubmit this document with your completed "Star Schema" design. see page
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 Dimension tables in the current design page but you don't need to use all four. HINT:
maybe only three may be used.Please resubmit this document with your completed Star Schema design. see page
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 Dimension tables in the current design page but you dont need to use all four. HINT: maybe only three may be used.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
