연습문제

테이블 (4)

assignments

  • assignment_id — int
  • emp_id — int
  • project_id — int

departments

  • dept_id — int
  • dept_name — varchar(255)
  • location — varchar(255)

employees

  • emp_id — int
  • emp_name — varchar(10) — NOT NULL
  • hire_date — date — NOT NULL
  • salary — int — NOT NULL
  • dept_id — int
  • check — (salary > 0)

projects

  • project_id — int
  • project_name — varchar(10) — NOT NULL
  • start_date — DATE
  • end_date — DATE