DBMS 과제1

테이블 (6)

A grade report

  • social security number (social_security_number) — UUID — 외래 키 → Student.social security number
  • student number (student_number) — UUID — 외래 키 → Student.student number
  • department name (department_name) — VARCHAR — 외래 키 → Student.department name
  • department code (department_code) — VARCHAR — 외래 키 → Student.department code
  • course number (course_number) — 외래 키 → Student.course number
  • student name (student_name) — VARCHAR
  • section — VARCHAR
  • letter grade (letter_grade) — VARCHAR
  • numeric grade (numeric_grade) — INT

Course (Untitled3)

  • course number (course_number) — BIGINT — 기본 키
  • course name (course_name) — VARCHAR
  • description — VARCHAR
  • number of semester hours (number_of_semester_hours) — BIGINT
  • level — VARCHAR
  • offering department (offering_department) — VARCHAR

Department (Untitled2)

  • department name (department_name) — VARCHAR — 기본 키
  • department code (department_code) — VARCHAR — 기본 키
  • office number (office_number) — BIGINT
  • office phone (office_phone) — BIGINT
  • college — VARCHAR

Student (Untitled)

  • social security number (social_security_number) — UUID — 기본 키
  • student number (student_number) — UUID — 기본 키
  • department name (department_name) — VARCHAR — 외래 키 → Department.department name
  • department code (department_code) — VARCHAR — 외래 키 → Department.department code
  • course number (course_number) — BIGINT — 외래 키 → section.course number
  • name — VARCHAR
  • current address (current_address) — VARCHAR
  • current phone (current_phone) — BIGINT
  • permanent address (permanent_address) — VARCHAR
  • permanent phone (permanent_phone) — BIGINT
  • birthdate — VARCHAR
  • sex — VARCHAR
  • class — VARCHAR
  • minor department (minor_department) — VARCHAR — NOT NULL — 존재한다면
  • degree program (degree_program)

section (Untitled4)

  • course number (course_number) — BIGINT — 외래 키 → Course.course number
  • instructor — VARCHAR
  • semester — VARCHAR
  • year — BIGINT
  • course — VARCHAR
  • section number (section_number) — INT

student_2 (Untitled5)

  • social security number (social_security_number) — UUID — 외래 키 → Student.social security number
  • student number (student_number) — UUID — 외래 키 → Student.student number
  • department name (department_name) — VARCHAR — 외래 키 → Student.department name
  • department code (department_code) — VARCHAR — 외래 키 → Student.department code
  • course number (course_number) — 외래 키 → Student.course number
  • city — VARCHAR
  • state — VARCHAR
  • permanent address (permanent_address) — VARCHAR
  • last name (last_name) — VARCHAR