Task1_3
Tables (5)
Course (Untitled2)
- 강좌 번호 (Course Number) — integer — Primary key
- 분반 (Description) — Integer
- 학기시수 (Number of Semester hours) — integer
- 수준 (level) — Character
- 제공부서 (offering department) — Character String
- 강좌 이름 (Course Name) — Character String — NOT NULL
- name — character string — Foreign key → Department.name
- department code — character string — Foreign key → Department.department code — NOT NULL
- social security number — integer — Foreign key → Student.social security number
- student number — integer — Foreign key → Student.student number
Department (Untitled)
- name — character string — Primary key
- department code — character string — Primary key — NOT NULL
- office number — character string
- office phone — character string
- college — character string
Grade report (Untitled3)
- social security number — integer — Foreign key → Student.social security number
- student number — integer — Foreign key → Student.student number
- student — character string
- section — character string
- letter grade — character string
- numeric grade — Character
Section (Untitled4)
- section number — integer — Primary key
- instructor — character string
- semester — character string
- year — integer
- course — character string
- social security number — integer — Foreign key → Student.social security number
- student number — integer — Foreign key → Student.student number
Student (Untitled5)
- social security number — integer — Primary key
- student number — integer — Primary key
- Student's name — character string
- current address and phone — character string
- permanent address and phone — character string
- birthdate — integer
- sex — character string
- class — character string
- major department — character string
- minor department — character string
- degree program — character string
- city — character string
- state — character string
- zip of the student's permanent address (Field) — character string
- student's last name — character string
- name (name2) — character string — Foreign key → Department.name
- department code — character string — Foreign key → Department.department code — NOT NULL