SQL, Data EDO, SNOWFLAKE
Budget: ₹600 – ₹1,500 INR
For this project you will design, make and load (small amount of data) to your Data Warehouse?
Please provide the design (in Dataedo or any graphical way)
Show the DDL to create the objects, be sure to have referential integrity and surrogate keys.
Show the DML to load the data.
Show the queries of some results
Provide some color:
- Is it Star or snowflake?
- Any challenges?
- What is the grain for the fact(s) table?
- Why were the dimensions chose?
Use PgAdmin, you can create a new shipment database.
ATTACHED is the shipment ER Model
Please provide the design (in Dataedo or any graphical way)
Show the DDL to create the objects, be sure to have referential integrity and surrogate keys.
Show the DML to load the data.
Show the queries of some results
Provide some color:
- Is it Star or snowflake?
- Any challenges?
- What is the grain for the fact(s) table?
- Why were the dimensions chose?
Use PgAdmin, you can create a new shipment database.
ATTACHED is the shipment ER Model