Problem
Design, make and load (small amount of data) to your Data Warehouse Shipment?
Provide the DIMENSIONAL design (in DB Schema 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?
Using PgAdmin, create a new shipment database and create the objects and load some data.