과제1
테이블 (12)
Course (Untitled3)
- Course Number (Key) — int — 기본 키 — NOT NULL
- course name (Field)
- description (Field2)
- number of semester hours (Field3)
- level (Field4)
Course_Section (Untitled9)
- Course Number (Key) — int — 외래 키 → Course.Course Number — NOT NULL
- Section Numver (Key2) — 외래 키 → Section.Section Numver — NOT NULL
Current Information (CopyOfUntitled7)
- Student number (Key) — int — 외래 키 → Student.Student number — NOT NULL
- city (Field)
- state (Field2)
- zip (Field3)
- phone (Field4)
Department (Untitled2)
- Department Code (Key) — int — 기본 키 — NOT NULL
- name (Field)
- office number (Field2)
- office phone (Field3)
- college (Field4)
Department_Course (Untitled8)
- Department Code (Key) — int — 외래 키 → Department.Department Code — NOT NULL
- Course Number (Key2) — int — 외래 키 → Course.Course Number — NOT NULL
Grade Report (Untitled5)
- Student number (Key) — int — 외래 키 → Student_Grade.Student number — NOT NULL
- Section Numver (Key2) — 외래 키 → Section_Grade.Section Numver — NOT NULL
- letter grade (Field3)
- numeric grade (Field4)
Permanent Information (Untitled7)
- Student number (Key) — int — 외래 키 → Student.Student number — NOT NULL
- city (Field)
- state (Field2)
- zip (Field3)
- phone (Field4)
Section (Untitled4)
- Section Numver (Key) — 기본 키 — NOT NULL
- instructor (Field)
- semester (Field2)
- year (Field3)
Section_Grade (Untitled11)
- Section Numver (Key) — 외래 키 → Section.Section Numver — NOT NULL
Student (Untitled)
- Student number (Key) — int — 기본 키 — NOT NULL
- name (Field) — varchar(30)
- SSN (Field2)
- sex (Field4) — varchar(1)
- birthday (Field3)
- class (Field5)
- degree program (Field8)
Student_Department (Untitled6)
- Student number (Key) — int — 외래 키 → Student.Student number — NOT NULL
- Department Code (Key2) — int — 외래 키 → Department.Department Code — NOT NULL
Student_Grade (Untitled10)
- Student number (Key) — int — 외래 키 → Student.Student number — NOT NULL