2024_P20_21

Tables (8)

Untitled (Department)

  • Key (depId) — char(4) — Primary key — NOT NULL
  • Field (depName) — char(20)
  • Field (depMangeName) — char(10)
  • Field (manageStartDate) — date
  • Key (empId) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Project)

  • Key (proId) — cahr(10) — Primary key — NOT NULL
  • Field (proName) — char(20)
  • Field (proManageName) — char(10)
  • Key (depId) — char(4) — Foreign key → Untitled.Key — NOT NULL

Untitled (Location)

  • Key (locId) — char(4) — Primary key — NOT NULL
  • Field (locName) — char(20)
  • Field (phone) — char(10)

Untitled (Dep_Loc)

  • Key (locId) — char(4) — Foreign key → Untitled.Key — NOT NULL
  • Key (depId) — char(4) — Foreign key → Untitled.Key — NOT NULL

Untitled (Employee)

  • Key (empId) — char(10) — Primary key — NOT NULL
  • Field (empName) — char(20)
  • Field (empAdress) — char(20)
  • Field (empGender) — char(1)
  • Field (empPay) — char(20)
  • Field (empDepartment) — char(4)
  • Key (depId) — char(4) — Foreign key → Untitled.Key — NOT NULL
  • Field (empSupervisor) — char(20)

Untitled (Emp_Pro)

  • Key (proId) — cahr(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (empId) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Family)

  • Key (famId) — char(10) — Primary key — NOT NULL
  • Field (famName) — char(20)
  • Field (famBirthDate) — date
  • Field (famGender) — char(1)
  • Field (famRelation) — char(10)
  • Key (empId) — char(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (works_on)

  • Key (proId) — cahr(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (empId) — char(10) — Foreign key → Untitled.Key — NOT NULL