자동화 과제

테이블 (7)

Department

  • Key (DepNo) — int(5) — 기본 키 — NOT NULL
  • Field (Name) — char(20)
  • Key (ManagerNo) — int(10) — 외래 키 → Employee.Key — NOT NULL
  • Field (ManageStarDate) — Date

Employee

  • Key (EmpNo) — int(10) — 기본 키 — NOT NULL
  • Field (Name) — varchar(5)
  • Field (ID) — int(13)
  • Field (Gender) — char(1)
  • Field (Address) — varchar(30)
  • Field (Wage) — int(10)
  • Key (SupervisorNo) — int(10) — 외래 키 → Employee.Key — NOT NULL
  • Key (DepNo) — int(5) — 외래 키 → Department.Key — NOT NULL

Untitled (Project)

  • Key (ProNo) — int(5) — 기본 키 — NOT NULL
  • Field (Name) — varchar(20)
  • Key (DepNo) — int(5) — 외래 키 → Department.Key — NOT NULL
  • Field (Field2) — 외래 키

Untitled (Family)

  • Key (Relation) — char(2) — 기본 키 — NOT NULL
  • Field (Name) — varchar(5)
  • Field2 (Gender) — char(1)
  • Field3 (BDay) — date
  • Key (EmpNo) — int(10) — 외래 키 → Employee.Key — NOT NULL

Untitled (Location)

  • Key (LocNo) — int(5) — 기본 키 — NOT NULL
  • Field (Name) — varchar(20)
  • Field (Address) — varchar(30)

Untitled (Department location)

  • Key (LocNo) — int(5) — 외래 키 → Untitled.Key — NOT NULL
  • Key (DepNo) — int(5) — 외래 키 → Department.Key — NOT NULL
  • Field (Field2) — 외래 키

Untitled (JoinProject)

  • Key (ProNo) — int(5) — 외래 키 → Untitled.Key — NOT NULL
  • Key (EmpNo) — int(10) — 외래 키 → Employee.Key — NOT NULL
  • Key (SupervisorNo) — int(10) — 외래 키 → Employee.Key — NOT NULL
  • Field (Hours/w) — int2