HW1_P3

Tables (6)

Course

  • Course_name (Course_number) — string — Primary key — NOT NULL
  • Name — string — Foreign key → Department.Name — NOT NULL
  • Department_code — string — Foreign key → Department.Department_code — NOT NULL
  • Course_number (Course_name) — string
  • Credit_hours — int
  • Field (Level) — string
  • Field (Offering_department) — string

Department

  • Name — string — Primary key — NOT NULL
  • Department_code — string — Primary key — NOT NULL
  • Office_number — string
  • Office_phone — string
  • College_name — string

Untitled (Student)

  • Key (Student_number) — string — Primary key — NOT NULL
  • Name — string — Foreign key → Department.Name — NOT NULL
  • Department_code — string — Foreign key → Department.Department_code — NOT NULL
  • Field2 (SSN) — string
  • Field3 (Current_address) — string
  • Field4 (Current_phone) — string
  • Field5 (Permanent_address) — string
  • Field (Permanent_phone) — string
  • Field2 (Birthdate) — date
  • Field3 (Gender) — string
  • Field4 (Grade) — string
  • Field (Major) — string
  • Field2 (Minor) — string
  • Field3 (Degree_program) — string

Untitled (Enrolls)

  • Course_name (Course_number) — string — Foreign key → Untitled.Course_name — NOT NULL
  • Name — string — Foreign key → Untitled.Name — NOT NULL
  • Department_code — string — Foreign key → Untitled.Department_code — NOT NULL
  • Key (Student_number2) — string — Foreign key → Untitled.Key — NOT NULL
  • Name (Name2) — string — Foreign key → Untitled.Name — NOT NULL
  • Department_code (Department_code2) — string — Foreign key → Untitled.Department_code — NOT NULL
  • Field (Student_number) — string
  • Field2 (Section_identifier) — int

Untitled (Grade_Report)

  • Course_name (Course_number2) — string — Foreign key → Untitled.Course_name — NOT NULL
  • Name — string — Foreign key → Untitled.Name — NOT NULL
  • Department_code — string — Foreign key → Untitled.Department_code — NOT NULL
  • Key (Student_number) — string — Foreign key → Untitled.Key — NOT NULL
  • Name (Name2) — string — Foreign key → Untitled.Name — NOT NULL
  • Department_code (Department_code2) — string — Foreign key → Untitled.Department_code — NOT NULL
  • Field (Stuent_number) — string
  • Field2 (Section_indentifier) — int
  • Field3 (Letter_grade) — string
  • Field4 (Numeric_grade) — int

Untitled (Section)

  • Course_name (Course_number) — string — Foreign key → Course.Course_name — NOT NULL
  • Name — string — Foreign key → Course.Name — NOT NULL
  • Department_code — string — Foreign key → Course.Department_code — NOT NULL
  • Field (Instructor) — string
  • Field2 (Semester) — string
  • Field3 (Year) — int