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