I have a Data Warehouse assignment due in a couple of days, and I've been busy reading up on Data Warehouses, Data Marts and Star Schemas lately. Oracle and databases are not really my best subjects, so I'm looking for some feedback on what I've done so far, just to verify that I'm on the right track - or not.

Here's a summary of the assignment:

"Citi has decided it wants to use the data it has available to analyse the time being spent on projects and activities. [...] They have decided to implement a Data Warehouse which will take data from the 3 databases. [...] Design A star schema for the Data Warehouse specifying: the tables and attributes for the DW, and the datatypes of each attribute."