database_hw1_2018550002

테이블 (5)

대학교 (The university)

  • social security number (SSN) — UUID — 기본 키 — NOT NULL
  • student number (student_number) — UUID — 기본 키 — NOT NULL
  • student name (student_name) — VARCHAR
  • current address and phone (cur_add_phone) — VARCHAR — NOT NULL
  • permanent address and phone (perm_add_phone) — VARCHAR
  • brithdate (birthdate) — TIMESTAMP — NOT NULL
  • sex — VARCHAR — NOT NULL
  • class — VARCHAR — NOT NULL
  • major department (major_department) — VARCHAR — NOT NULL
  • minor department (minor_department) — VARCHAR
  • degree program (degree_program) — VARCHAR — NOT NULL
  • city — VARCHAR
  • state — VARCHAR
  • zip of the stusent's parmanent address (zip_parm_add) — VARCHAR
  • last name (lastname) — VARCHAR

성적 (grade)

  • social security number (SSN) — UUID — 외래 키 → 대학교.social security number — NOT NULL
  • student number (student_number) — UUID — 외래 키 → 대학교.student number — NOT NULL
  • course number (course_number) — VARCHAR — 외래 키 → 섹션.course number — NOT NULL
  • letter grade (letter_grade) — VARCHAR
  • numeric grade (numeric_grade) — BIGINT

섹션 (SECTION)

  • course number (course_number) — VARCHAR — 외래 키 → 수업.course number — NOT NULL
  • instructor — VARCHAR
  • semester — VARCHAR
  • year — BIGINT
  • section number — BIGINT

수업 (COURSE)

  • course number (course_number) — VARCHAR — 기본 키 — NOT NULL
  • course name (course_name) — VARCHAR
  • description — VARCHAR
  • number of semester hour (num_of_semester_hour) — BIGINT
  • level — VARCHAR
  • offering department (offering_department) — VARCHAR
  • name (name2) — VARCHAR — 외래 키 → 학부/부서.name — NOT NULL
  • department code (Dep_code) — VARCHAR — 외래 키 → 학부/부서.department code — NOT NULL

학부/부서 (DEPARTMENT)

  • name — VARCHAR — 기본 키 — NOT NULL
  • department code (Dep_code) — VARCHAR — 기본 키 — NOT NULL
  • office number (office_number) — VARCHAR
  • office phone (office_phone) — VARCHAR
  • college — VARCHAR