수습_연습

테이블 (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)