Homework answers / question archive / I need someone to look over my SQL commands for a database management course

I need someone to look over my SQL commands for a database management course

Computer Science

Share With

I need someone to look over my SQL commands for a database management course. The gist of the assignment is:The data-mart includes the following tables:

1. Course Dimension: Table includes generic info about every course. It doesn't include info about offerings, only the courses.
2. Time Dimension: Table uses semesters to mark the pass of time. Because semesters may have names that are not sequential, a surrogate TimeID attribute is created with consecutive values to mark the sequence (first semester is 1, second 2, etc.). Assume this table was already created for you and it exists.
3. Faculty Dimension: This table includes all relevant information about a Faculty member.
4. Fact table: Contains all primary keys of the dimensions tables and the average grades of all courses offered with the same CourseID during the same semester by the same faculty member

The star-schema for this data-mart is as follows:

Question: Tutoring is needed to Design and draw a star-schema for a new data-mart that will keep track of the grades made by students in courses. This data-mart will have the same Time and Course Dimensions that the first data-mart shows, but will have a Student Dimension with information about a Student instead of the Faculty Dimension. This information includes StudentID, names, major and school. The Fact table will also change and it will hold the grade obtained by a student in a course in a semester.