2주차 과제

테이블 (7)

Copy Of Untitled (DEPARTMENT)

  • Key (dno) — char(3) — 기본 키 — NOT NULL
  • Field (dname) — char(30)
  • Field (phone) — char(11)
  • Field (manageStartDate) — date
  • Field (ssn) — char(30)
  • Key (managerSsn) — char(30) — 외래 키 → EMPLOYEE.Key — NOT NULL

EMPLOYEE

  • Key (ssn) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field2 (address) — char(40)
  • Field3 (phone) — char(11)
  • Field4 (bdate) — date
  • Field5 (salary) — int(10)
  • Field (gender) — char(1)
  • Field (email) — char(30)
  • Key (dno) — char(3) — 외래 키 → Copy Of Untitled.Key — NOT NULL
  • Key (supervisorssn) — char(30) — 외래 키 → EMPLOYEE.Key — NOT NULL

Untitled (PROJECT)

  • Key (pno) — char(30) — 기본 키 — NOT NULL
  • Field (pname) — char(30)
  • Field (description) — text
  • Key (dno) — char(3) — 외래 키 → Copy Of Untitled.Key — NOT NULL

Untitled (DEPENDENT)

  • Key (ssn) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (birthDate) — date
  • Field (gender) — char(1)
  • Field (relation) — char(10)
  • Field (status) — char(50)
  • Field
  • Key (ssnEmployee) — char(30) — 외래 키 → EMPLOYEE.Key — NOT NULL

Untitled (LOCATION)

  • Key (locationlD) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (abbress) — char(40)
  • Field (phone) — char(12)

Untitled (DEPARTMENT_LOCATION)

  • Key (dno) — char(3) — 외래 키 → Copy Of Untitled.Key — NOT NULL
  • Key (locationlD) — char(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (WORKS_ON)

  • Key (workonID) — integer — 기본 키 — NOT NULL
  • Field (hour) — float
  • Key (ssn) — char(30) — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Key (pno) — char(30) — 외래 키 → Untitled.Key — NOT NULL