EMPLOYEE

Tables (6)

Untitled (JOB)

  • EMP_ID (JOB_ID) — Primary key — NOT NULL
  • Field (JOB_TITLE)
  • Field2 (MIN_SAL)
  • Field3 (MAX_SAL)

Untitled (EMPLOYEE)

  • EMP_ID — Primary key — NOT NULL
  • Field (EMP_NAME)
  • Field2 (EMP_NO)
  • Field3 (EMAIL)
  • Field4 (PHONE)
  • EMP_ID (JOB_ID) — Foreign key → Untitled.EMP_ID — NOT NULL
  • Field5 (HIRE_DATE)
  • Field2 (SALARY)
  • Field3 (BONUS_PCT)
  • Field4 (MGR_ID)
  • Key (DEPT_ID) — Foreign key → Untitled.Key — NOT NULL

Untitled (DEPARTMENT)

  • Key (DEPT_ID) — Primary key — NOT NULL
  • Key (LOC_ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (DEPT_NAME)

Untitled (LOCATION)

  • Key (LOCATION_ID) — Primary key — NOT NULL
  • Key (COUNTRY_ID) — Foreign key → Untitled.Key — NOT NULL
  • Field (LOC_DESCRIBE)

Untitled (COUNTRY)

  • Key (COUNTRIY_ID) — Primary key — NOT NULL
  • Field (COUNTRY_NAME)

Untitled2 (SAL_GRADE)

  • Key (SLEVEL) — Primary key — NOT NULL
  • Field (LOWEST)
  • Field2 (HIGHEST)