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