Make sure all coaches ID only appear once in your results g Indicate how many

Make sure all coaches id only appear once in your

This preview shows page 5 - 6 out of 6 pages.

NOT in a 3-months or 6-months membership. Make sure all coaches ID only appear once in your results. g. Indicate how many customers took a Beginner Boxing class with a coach hired between 2015 and 2019 (included)
Image of page 5
The following questions relate to Chapter 9 Question 5 (10 pts) Daly College wants you to help design a star schema to record grades for courses completed by students. Consider the following four dimension tables and their respective attributes: Dimension Table Attributes Professor ProfName, Title, DepartmentID, DepartmentName Course Section CourseID, SectionNumber, CourseName, Units, RoomID, RoomCapacity Student StudentName, Major Period Semester, Year You can also consider the following information about Warriors College : During a given semester, the college offers an average of 300 course sections with only 1 professor for each section. Each course section has an average of 40 students, and students typically take five courses per period. The Database will contain data for 30 periods, meaning a total of 10 years. Each year has a Fall, Spring and one Summer period. Records about CourseGrade must also be recorded as a fact. Based on these information, answer the following questions : a. Design a star schema for this problem. (5 pts) b. Estimate the number of rows in the fact table. (3 pts) c. Estimate the total size of the fact table (in bytes), assuming that each field has an average of 4 bytes. (2 pts)
Image of page 6

You've reached the end of your free preview.

Want to read all 6 pages?

  • Spring '14
  • B MAK
  • Deltron 3030, 31st century

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask 0 bonus questions You can ask 15 questions (10 expire soon) You can ask 15 questions (will expire )
Answers in as fast as 15 minutes