database

Tables (7)

DEPARTMENT (Untitled6)

  • Deptno (Key) — Primary key — NOT NULL
  • Empno (Key2) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key3) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key23) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key2222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key22222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key4) — Foreign key → Empno.Depname — NOT NULL
  • Empno (Key24) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key223) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2223) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key32) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key232) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key222222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2222222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key42) — Foreign key → Empno.Depname — NOT NULL
  • Deptno (Key5) — Foreign key → Empno.Deptno — NOT NULL
  • Empno (Key25) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key224) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2224) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key33) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key233) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22223) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222223) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key43) — Foreign key → Empno.Depname — NOT NULL
  • Empno (Key242) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key2232) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key22232) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key322) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2322) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22222222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222222222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key422) — Foreign key → Empno.Depname — NOT NULL
  • Depname (Field)
  • Floor (Field2)

DEPENDENT (Untitled5)

  • Depname (Key) — Primary key — NOT NULL
  • Empno (Key2) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key3) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key23) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key2222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key22222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key4) — Foreign key → Empno.Depname — NOT NULL
  • Deptno (Key5) — Foreign key → Empno.Deptno — NOT NULL
  • Empno (Key25) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key224) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2224) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key33) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key233) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22223) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222223) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key43) — Foreign key → Empno.Depname — NOT NULL
  • Empno (Key242) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key2232) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key22232) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key322) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2322) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key2222222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key22222222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key422) — Foreign key → Empno.Depname — NOT NULL
  • Field

Empno (Untitled)

  • Empno (Key) — Primary key — NOT NULL
  • projectno (Key2) — Foreign key → Project.projectno — NOT NULL
  • Empno (Key22) — Foreign key → Project.Empno — NOT NULL
  • projectno (Key3) — Foreign key → Project(1).projectno — NOT NULL
  • Empno (Key23) — Foreign key → Project(1).Empno — NOT NULL
  • projectno (Key222) — Foreign key → Project(1).projectno — NOT NULL
  • Empno (Key2222) — Foreign key → Project(1).Empno — NOT NULL
  • Depname (Key4) — Foreign key → DEPENDENT.Depname — NOT NULL
  • Empno (Key24) — Foreign key → DEPENDENT.Empno — NOT NULL
  • projectno (Key223) — Foreign key → DEPENDENT.projectno — NOT NULL
  • Empno (Key2223) — Foreign key → DEPENDENT.Empno — NOT NULL
  • projectno (Key32) — Foreign key → DEPENDENT.projectno — NOT NULL
  • Empno (Key232) — Foreign key → DEPENDENT.Empno — NOT NULL
  • projectno (Key22222) — Foreign key → DEPENDENT.projectno — NOT NULL
  • Empno (Key222222) — Foreign key → DEPENDENT.Empno — NOT NULL
  • Depname (Key42) — Foreign key → DEPENDENT.Depname — NOT NULL
  • Deptno (Key5) — Foreign key → DEPARTMENT.Deptno — NOT NULL
  • Empno (Key25) — Foreign key → DEPARTMENT.Empno — NOT NULL
  • projectno (Key224) — Foreign key → DEPARTMENT.projectno — NOT NULL
  • Empno (Key2224) — Foreign key → DEPARTMENT.Empno — NOT NULL
  • projectno (Key33) — Foreign key → DEPARTMENT.projectno — NOT NULL
  • Empno (Key233) — Foreign key → DEPARTMENT.Empno — NOT NULL
  • projectno (Key22223) — Foreign key → DEPARTMENT.projectno — NOT NULL
  • Empno (Key222223) — Foreign key → DEPARTMENT.Empno — NOT NULL
  • Depname (Key43) — Foreign key → DEPARTMENT.Depname — NOT NULL
  • Empno (Key242) — Foreign key → DEPARTMENT.Empno — NOT NULL
  • projectno (Key2232) — Foreign key → DEPARTMENT.projectno — NOT NULL
  • Empno (Key22232) — Foreign key → DEPARTMENT.Empno — NOT NULL
  • projectno (Key322) — Foreign key → DEPARTMENT.projectno — NOT NULL
  • Empno (Key2322) — Foreign key → DEPARTMENT.Empno — NOT NULL
  • projectno (Key2222222) — Foreign key → DEPARTMENT.projectno — NOT NULL
  • Empno (Key22222222) — Foreign key → DEPARTMENT.Empno — NOT NULL
  • Depname (Key422) — Foreign key → DEPARTMENT.Depname — NOT NULL
  • Empname (Field)
  • Title (Field2)
  • Salary (Field3)
  • Address (City) — Dong

Part (Untitled4)

  • Partno (Key) — Primary key — NOT NULL
  • Partname (Field)
  • Price (Field2)

Project (Untitled2)

  • projectno (Key) — Primary key — NOT NULL
  • Empno (Key2) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key3) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key23) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key2222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key22222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key4) — Foreign key → Empno.Depname — NOT NULL
  • Empno (Key24) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key223) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2223) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key32) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key232) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key222222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2222222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key42) — Foreign key → Empno.Depname — NOT NULL
  • Deptno (Key5) — Foreign key → Empno.Deptno — NOT NULL
  • Empno (Key25) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key224) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2224) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key33) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key233) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22223) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222223) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key43) — Foreign key → Empno.Depname — NOT NULL
  • Empno (Key242) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key2232) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key22232) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key322) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2322) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22222222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222222222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key422) — Foreign key → Empno.Depname — NOT NULL
  • projname (Field)
  • Budget (Field2)
  • Location (Field3)

Project(1) (Untitled7)

  • projectno (Key) — Primary key — NOT NULL
  • Empno (Key2) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key3) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key23) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key2222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key22222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key4) — Foreign key → Empno.Depname — NOT NULL
  • Empno (Key24) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key223) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2223) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key32) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key232) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key222222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2222222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key42) — Foreign key → Empno.Depname — NOT NULL
  • Deptno (Key5) — Foreign key → Empno.Deptno — NOT NULL
  • Empno (Key25) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key224) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2224) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key33) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key233) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22223) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222223) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key43) — Foreign key → Empno.Depname — NOT NULL
  • Empno (Key242) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key2232) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key22232) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key322) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key2322) — Foreign key → Empno.Empno — NOT NULL
  • projectno (Key22222222) — Foreign key → Empno.projectno — NOT NULL
  • Empno (Key222222222) — Foreign key → Empno.Empno — NOT NULL
  • Depname (Key422) — Foreign key → Empno.Depname — NOT NULL
  • Empno (Field)
  • projectno (Field2)
  • Empno (Field3)
  • projectname (Field4)
  • Budget (Field5)
  • Location (Field6)

SUPPLIER (Untitled3)

  • Suppno (Key) — Primary key — NOT NULL
  • Suppname (Field)
  • Credit (Field2)