I have attached two files one is the assignment and one is the assignment that one of the students did i want the assignment to be like that but it has to have nothing copied from the solved assignment. Let me know if its doable so that i can give you the oracle link and login so that the sql work can be done there.

All tables created correctly. Appropriate implementation of integrity rules Same as excellent. Optimised table creation with minimum code and full set of constraints All data sources are correctly identified, efficient transformation rules are set and all data are loaded correctly Same as excellent. Minimum data sources and optimised ETL code produced, any potential problems discussed Excellent justification for all requirements with excellent comparison between most OLTP and DM queries Same as excellent. More than one solutions are presented and difference discussed.

Excellent 80-89% Outstanding 90-100% Same as previous, and correct multiplicity, no unjustified redundancy As excellent. Minimum set of dimensions and facts in fact table. Perfect granularity Excellent choice of tables, and attributes, primary & foreign keys Same as excellent. Clear explanation on the map from star schema to logical relations.