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)