Project Inc
Tables (5)
Department (DEPARTMENT)
- Key (Department Name) — Primary key — NOT NULL
- Field (Phone#)
- Field (Fax#)
Employee (EMPLOYEE)
- Key (Employee#) — Primary key — NOT NULL
- Key (Department Name) — Foreign key → Department.Key — NOT NULL
- Field (Name)
- Field (Adress)
- Field (Start Date)
- Field ({Skill})
- Key (Spouse) — Foreign key → Employee.Key — NOT NULL
Project (PROJECT)
- Key (Project-id) — Primary key — NOT NULL
- Field (Project title)
- Field (Start Date)
- Field (Duration)
- Field (Budget)
- Field (Project Roles)
- Field (Employee)
- Field (Skill)
Skill (SKILL)
- Key (Skill Code) — Primary key — NOT NULL
- Field (Description)