FIT3003代写、代写SQL设计编程

日期：2022-10-01 09:47

S2 2022 MajorAssignment Marking Guide

TASK MARKING CRITERIA MARK

C1 Data Warehouse Design and Transformation

ER Diagram Provide ER diagram with correct relationships, clear identification of PK and FK for each table.

45

Data Cleaning Identify five correct data errors and perform appropriate data cleaning.

Star Schema Version-1 with explanation on difference

Star schema design is correct with all dimensions, fact measures, and its relationship.

Star schema version 1 has a high level of aggregation while version 2 has no level of aggregation.

Provide sufficient explanation on the difference between Star schema version 1 and 2.

Provide sufficient understanding on the difference between different levels of aggregation.Star Schema Version-2 with explanation on difference

Determinant dimension and Temporal dimension explanation

A clear explanation on whether an Determinant dimensionn is used.

A clear explanation on whether an SCD dimension is used. If yes, what type of SCD it is and reasons for the choice.

C2 Star/Snowflake Implementation

Star Schema Version-1 implementation

Correctness of the star schema implementation.

Implementation is interconnected with the star schema design.

Codes run without errors.

SQL statement presented in the PDF file.

Zero mark for the implementation if SQL files are not runnable or Missing SQL files or Submitting wrong SQL files. 25Star Schema Version-2 implementation

C3 Reports using OLAP Queries

OLAP Reports (Reports 1 to 4)

Correctness in using OLAP functions.

Results of SQL statements match with snapshot of the OLAP reports 1-4 (included correct attributes, orders, grouping).

Codes run without errors.

The query questions are written in English, provide clear explanation on how it will be helpful for the managers. 16

Report with Roll up and Partial Roll up (Reports 5 to 6)

Report with Moving and cumulative aggregates (Reports 7 to 8)

C4 BI Reports&dashboard

A dashboard with four reports Correctness, interactivity, and informativity of the dashboard. 8

C5 Final Recommendations/Suggestions

Final suggestion

Provide a suggestion with a valid supporting data.

The suggestion must contain a valid supporting data from the MonCity database and Star schema. 6

Additional Criteria

Report Document Readability Report is neat and clear with sufficient headings and consistent format. Up to 10 marks

deductionCode Readability Codes are given with proper comments and indentation.

Timely submission of correct and relevent files

10% penalty each day for late submission.

All required files are provided according to the submission checklist.

Contribution equality

Unequal contribution between members may result in penalty.

Weekly Contributions will be checked by the allocated tutor regularly during the labs.

Major asssignment checkpoints

Checkpoints 1, 2

The checkpoint will be conducted during the Week 7 and Week 9.

Please check MA specification for more details. 2%