PART 1: TAL Data Warehouse
- Transforming TAL TPS to TAL DW
- ETL → OrderDetail
- Extract, Transform, Load
- Expanded Time Dimension: Time2015
Part 2: CAT DW [Relation Listing]
6. Reports (10 Bonus pts. each Report & Query):
1) TAL Subtotal Orders by Customer (3 Bonus pts).
- Include SQL for Query used for Report
2) TAL Subtotal Orders by Items (3 Bonus pts).
- Include SQL for Query used for Report
3) CAT Subtotal Trip Reservations Total Fees by Month -----
- Include SQL for Query used for Report
7. Summary of Requirements (TAL & CAT)
- Star Diagram (ERDPlus Diagram 2 pts Bonus)
- ETL SQL code for appropriate NEW tables
- DataSheet Views all tables; and Index Pane Views
- Relation Lists; with appropriate Relation Notation
- Bonus: Append/Merge New FL Data to TAL
- Bonus: Reports with Queries
Attachment:- Assignment.rar