ERmodel

Tables (8)

Depar_Local (Untitled2)

  • Key (LocalNo) — integer — Foreign key → Local.Key — NOT NULL
  • Key (PartNo) — integer — Foreign key → Department.Key — NOT NULL

Department (Part)

  • Key (PartNo) — integer — Primary key — NOT NULL
  • Field (Name) — char(30)
  • Field (Leader) — char(10)
  • Key (EmployeeNo) — integer — Foreign key → Employee.Key — NOT NULL
  • Field (startdate) — date

Employee (Empoloyee)

  • Key (EmployeeNo) — integer — Primary key — NOT NULL
  • Field (Name) — char(20)
  • Field (Salary) — integer
  • Field (adress) — char(20)
  • Field (PhoneNo) — char(11)
  • Field (Gender) — char(5)
  • Field (Birth) — integer
  • Field (IDNumber) — char(14)
  • Key (PartNo) — integer — Foreign key → Department.Key — NOT NULL
  • Key (supervisorNo) — integer — Foreign key → Employee.Key — NOT NULL

Local (Untitled)

  • Key (LocalNo) — integer — Primary key — NOT NULL
  • Field (LocalName) — char(1000)
  • Field (phone) — char(15)
  • Field (adress) — char(100)

Untitled (Project)

  • Key (ProjectNo) — integer — Primary key — NOT NULL
  • Key (PartNo) — integer — Foreign key → Department.Key — NOT NULL
  • Field (projectname) — char(100)

Untitled (Leader)

  • Field (StartDate) — integer

Works_On (Untitled3)

  • Key (WoNo) — integer — Primary key — NOT NULL
  • Key (ProjectNo) — integer — Foreign key → Untitled.Key — NOT NULL
  • Key (EmployeeNo) — integer — Foreign key → Employee.Key — NOT NULL
  • Field (hours) — float
  • Field2 (YearMonth) — date

dependent (Untitled4)

  • Key (DepNo) — integer — Primary key — NOT NULL
  • Field (age) — integer
  • Field (gender) — char(10)
  • Field (birth) — integer
  • Field (Name) — char(50)
  • Field (relation) — char(50)
  • Field
  • Key (EmployeeNo) — integer — Foreign key → Employee.Key — NOT NULL