Data Mart and Schema Assignment

You need to analyze the sample dataset and understand the relevant business (terms, rules, data, etc.),

The Analyse data set is the class registration data that will include departments, semesters, faculty information.

You need to design a star schema for this data and analysis the requirement showing major measures, dimensions and their attributes. Use any software program to do the modeling.

Design a data mart based on the star schema using SQL Server Database Engine, with the fact table meeting requirement like actual enrollment (first number of the last column), original enrollment, maximum seats.

Design a least four dimension tables with primary keys, foreign keys, appropriate data type/length and other constraint.

Create SQL server database diagram and take a screenshot.

Take screenshot of the star schema(logical design) using modeling tools like ERDplus.com

Take screenshot of the SQL server data mart (database)