Home » Developer & Programmer » Data Integration » DW/Star Schema assignment - looking for feedback (Oracle 9i, Win)
icon5.gif  DW/Star Schema assignment - looking for feedback [message #283343] Mon, 26 November 2007 16:15
syff
Messages: 1
Registered: November 2007
Junior Member
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."

Here's an ERD of one of the databases (the other two databases are almost identical):
> http://www.tilhtml.no/citi-leeds-erd.png

And here's my unfinished up-for-consideration Star Schema:
> http://www.tilhtml.no/citi-star-schema.png

If somebody could take two minutes and just look through what I've done, and tell me what's good and bad about the Star Schema, I'd be forever grateful.

Two quick questions regarding the facts table:
1) What should its name be?
2) Which values should it be holding, in addition to the foreign keys?

Thanks!
Previous Topic: Directions for learning
Next Topic: Is there a maximum size of OWB maps?
Goto Forum:
  


Current Time: Thu Mar 28 03:42:24 CDT 2024