1. Create a star schema for this data based on your analysis of the r
** “sample-data.zip” include several HTML files showing class registration data **
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.
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.
Data explanation
- CRN is course section offering id, and should be unique across semesters (not exactly sure)
- Course section codes: 9xx – online, 8xx – hybrid, 0xx – in-classroom
- Course number: 1xxx-4xxx (undergraduate, 1 to 4 for freshman, sophomore, junior, and
senior), 5xxx and above for graduate
- CCSE courses have five prefixes: IT, CS, SWE, CGDD, CSE
- The last column are the three types of enrollment headcounts:
actual enrollment number in the end/initial enrollment number before registration deadline/max available seat
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.