MIS_60210872_박상민

테이블 (12)

BELONGS

  • Empno — int — 외래 키 → EMPLOYEE.Empno — NOT NULL
  • Deptno — int — 외래 키 → DEPARTMENT.Deptno — NOT NULL

CONTAINS

  • Partno — int — 외래 키 → PART.Partno — NOT NULL

DEPARTMENT

  • Deptno — int — 기본 키 — NOT NULL
  • Depname — varchar
  • Floor — int

DEPENDENT

  • Depname — varchar — 기본 키 — NOT NULL
  • Sex — varchar

EMPLOYEE (EMPLOYEE_1)

  • Empno — int — 기본 키 — NOT NULL
  • Empname — varchar
  • Title — varchar
  • Salary — decimal
  • City
  • Ku
  • Dong

MANAGES

  • Empno — int — 외래 키 → EMPLOYEE.Empno — NOT NULL
  • Projno — int — 외래 키 → PROJECT.Projno — NOT NULL
  • Startdate

PART

  • Partno — int — 기본 키 — NOT NULL
  • Partname — varchar
  • Price — decimal

POLICY

  • Empno — int — 외래 키 → EMPLOYEE.Empno — NOT NULL
  • Depname — varchar — 외래 키 → DEPENDENT.Depname — NOT NULL

PROJECT

  • Projno — int — 기본 키 — NOT NULL
  • Projname — varchar
  • Budget — decimal
  • Location — varchar

SUPPLIER

  • Suppno — int — 기본 키 — NOT NULL
  • Suppname — varchar
  • Credit — int

SUPPLIES

  • Projno — int — 외래 키 → PROJECT.Projno — NOT NULL
  • Partno — int — 외래 키 → PART.Partno — NOT NULL
  • Suppno — int — 외래 키 → SUPPLIER.Suppno — NOT NULL
  • Quantity

WORKS_FOR

  • Projno — int — 외래 키 → PROJECT.Projno — NOT NULL
  • Empno — int — 외래 키 → EMPLOYEE.Empno — NOT NULL
  • Druation
  • Responsibility