수습_연습
테이블 (4)
Department (Untitled)
- Dept_ID (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
- Dept_Name (Field) — VARCHAR2(25)
- Dept_Tel (Field2) — VARCHAR2(12)
Professor (Untitled3)
- Professor_ID (Key) — VARCHAR2(3) — 기본 키 — NOT NULL
- Name (Field) — VARCHAR2(20)
- Position (Field2) — VARCHAR2(10)
- Dept_ID (Key2) — VARCHAR2(10) — 외래 키 → Department.Dept_ID — NOT NULL
- Telephone (Field3) — VARCHAR2(12) — unique
SG_Scores (Untitled4)
- Student_ID (Key) — VARCHAR2(5) — 기본 키 — NOT NULL
- Course_ID (Key2) — VARCHAR2(5) — 기본 키 — NOT NULL
- Score (Field3) — NUMBER(3)
- Grade (Field4) — VARCHAR2(2)
- Score_Assigned (Field5) — Date
Student (Untitled2)
- Student_ID (Key) — VARCHAR2(7) — 기본 키 — NOT NULL
- Year (Field2) — VARCHAR2(1)
- Name (Field) — VARCHAR2(20) — NOT NULL
- ID_Number (Field3) — VARCHAR2(14) — NOT NULL
- Addeess (Field4) — VARCHAR2(40)