과제

테이블 (7)

LOCATIONS (Untitled3)

  • location_id (Key) — 기본 키 — NOT NULL
  • country_id (Key3) — 외래 키 → 컨트리(COUNTRIES).country_id — NOT NULL
  • street_address (Field)
  • postal_code (Field2)
  • city (Field3)
  • state_province (Field4)

디파트먼트(DEPARTMENTS) (Untitled4)

  • department_id (Key) — 기본 키 — NOT NULL
  • department_name (Field)
  • manager_id (Field2)
  • location_id (Key2) — 외래 키 → LOCATIONS.location_id — NOT NULL
  • country_id (Key3) — 외래 키 → LOCATIONS.country_id — NOT NULL

리전(REGIONS) (Untitled)

  • region_id (Key) — 기본 키 — NOT NULL
  • region_name (Field)

임플로이(EMPLOYEES) (Untitled5)

  • employee_id (Key) — 기본 키 — NOT NULL
  • manager_id (Field7) — 기본 키
  • job_id (Field9) — 기본 키
  • name (Field)
  • email (Field2)
  • tel (Field3)
  • hire_date (Field4)
  • sal (Field5)
  • bonus (Field6)
  • dept_id (Field8)

잡스(JOBS) (Untitled6)

  • job_id (Field9) — 기본 키
  • job_id (Field92) — 외래 키 → 임플로이(EMPLOYEES).job_id
  • JOB_TITLE (Field)
  • MIN_SALARY (Field2)
  • MAX_SALARY (Field3)

잡히스토리(JOB_HISTORY) (Untitled7)

  • job_id (Field9) — 기본 키
  • start_date (Field)
  • end_date (Field2)
  • department_id (Field4)
  • job_id (Field92) — 외래 키 → 임플로이(EMPLOYEES).job_id

컨트리(COUNTRIES) (Untitled2)

  • country_id (Key) — 기본 키 — NOT NULL
  • country_name (Field)
  • region_id (Key2) — 외래 키 → 리전(REGIONS).region_id — NOT NULL