EssayNICE | 24/7 Homework Help

Essaynice Will Help You Write Your Essays and Term Papers

Answered » You can buy a ready-made answer or pick a professional tutor to order an original one.

Assignment help 5426

by | Jun 24, 2023 | Posted Assignments

You need to analyze the sample data set 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)