CIS 624       Fall 2004               Extra Credit Assignment – Data Staging

Due: Start of Class on 11/30/04

Task:

            Identify at least 10 things that have to be done in doing data staging that results in the attached star schema, starting from the attached 3NF database. Be as specific as possible (e.g. how is the “Lead Vocals” brought into the Recording?).  The idea is to create a detailed design for the staging process (i.e. I’m not looking for management tasks such as “create a high level plan, decide on data staging tools …”. I’m looking for more along the lines of a detailed plan, transformations that need to be done, etc). Your answer should be neat and easy to read.

I don’t expect that anybody what get everything that needs to be done (remember, this is more complicated than anybody expects it to be. The idea here is to stop thinking in the abstract and really see the work that has to be done).