asd

Tables (3)

DEPARTMENT (Untitled)

  • DEPT_ID — Primary key — NOT NULL
  • DEPT_TITLE
  • LOCATION_ID (Key) — Foreign key → Untitled2.LOCAL_CODE — NOT NULL

EMPLOYEE (Untitled3)

  • EMP_ID (Key) — Primary key — NOT NULL
  • EMP_NAME (Field)
  • EMP_NO (Field2)
  • EMAIL (Field3)
  • PHONE (Field4)
  • DEPT_CODE (Field5)

Untitled2

  • LOCAL_CODE (Key) — Primary key — NOT NULL
  • NATIONAL_CODE (Field)
  • LOCAL_NAME (Field2)