q1

Tables (15)

ClassRoom (Untitled9)

  • classroom_key (Key) — Primary key — NOT NULL
  • classroom_number (Field)

Course (Untitled5)

  • course_key (Key) — Primary key — NOT NULL
  • course_name (Field)
  • course_grade (Field2)
  • course_department (Field3)
  • classroom_key (Key2) — Foreign key → ClassRoom.classroom_key — NOT NULL

Date (Untitled10)

  • date_key (Key) — Primary key — NOT NULL
  • day (Field)
  • month (Field2)
  • year (Field4)

Doctor (Untitled2)

  • doctor_key (Key) — Primary key — NOT NULL
  • doctor_name (Field)
  • department (Field2)

Fee Fact Table (Doctor)

  • time_key (Key) — Foreign key → Time.time_key — NOT NULL
  • doctor_key (Key2) — Foreign key → Doctor.doctor_key — NOT NULL
  • patient_key (Key3) — Foreign key → Patient.patient_key — NOT NULL
  • count (Count)
  • charge (Charge)

Game (Untitled13)

  • game_key (Key) — Primary key — NOT NULL
  • game_name (Field)
  • game_manager (Field2)

Instructor (Untitled7)

  • instructor_key (Key) — Primary key — NOT NULL
  • instructor_name (Field)
  • instructor_major (Field2)
  • instructor_department (Field3)
  • instructor_college (Field4)
  • instructor_university (Field5)

Location (Untitled12)

  • location_key (Key) — Primary key — NOT NULL
  • location_name (Field)
  • street (Field2)
  • city (Field3)
  • country (Field4)

Patient (Untitled)

  • patient_key (Key) — Primary key — NOT NULL
  • patient_name (Field)
  • patient_age (Field2)
  • patient_sex (Field3)

Sales Fact Table (Untitled14)

  • game_key (Key) — Foreign key → Game.game_key — NOT NULL
  • spectator_key (Key2) — Foreign key → Spectator.spectator_key — NOT NULL
  • location_key (Key3) — Foreign key → Location.location_key — NOT NULL
  • date_key (Key4) — Foreign key → Date.date_key — NOT NULL
  • count (Field)
  • charge (Field2)

Semester (Untitled6)

  • semester_key (Key) — Primary key — NOT NULL
  • semester_name (Field)
  • semester_start_day (Field2)
  • semester_end_day (Field3)
  • semester_year (Field4)

Spectator (Untitled11)

  • spectator_key (Key) — Primary key — NOT NULL
  • spectator_name (Field)
  • status (Field2)
  • phone (Field3)

Student (Untitled4)

  • student_key (Key) — Primary key — NOT NULL
  • student_name (Field)
  • major (Field3)
  • status (Field4)
  • university (Field2)

Time (Untitled3)

  • time_key (Key) — Primary key — NOT NULL
  • day (Field)
  • month (Field2)
  • year (Field4)

University Fact Table (Untitled8)

  • course_key (Key) — Foreign key → Course.course_key — NOT NULL
  • instructor_key (Key2) — Foreign key → Instructor.instructor_key — NOT NULL
  • student_key (Key3) — Foreign key → Student.student_key — NOT NULL
  • semester_key (Key4) — Foreign key → Semester.semester_key — NOT NULL
  • count (Field)
  • avg_grade (Field2)