Create a data mart based on the star schema

1. Create a star schema for this data based on your analysis of the requirements and understanding of the domain. They must be reasonable and justifiable. Clearly show major measures, dimensions and their attributes. Use a software program to create the model.

E.g. ERDplus (https://erdplus.com/standalone) or MS Visio.

Don't use plagiarized sources. Get Your Custom Essay on
Create a data mart based on the star schema
Just from $13/Page
Order Essay

2. Create a data mart based on the star schema using SQL Server Database Engine. Schema/data mart requirements (may or may not align with your design; but for consistency please meet the following minimum requirements).

o The fact table should include at least three measures: actual enrollment (the first number of the last column), original enrollment, maximum seats.

o Design at least four dimension tables.

o Create all primary keys, relationships (foreign keys), appropriate data type/length, and other constraints.

3. Create a SQL Server database diagram and take a screenshot of the diagram.

Leave a Reply

Your email address will not be published. Required fields are marked *