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