2024 db ex1
Tables (4)
Untitled (employee)
- Key (employeeid) — char(10) — Primary key — NOT NULL
- Field (name) — char(15)
- Field (gender) — char(1)
- Field (adress) — char(15)
- Field (phone) — char(11)
- Field
- Key (departmentid) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (projectnumber) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (department)
- Key (departmentid) — char(10) — Primary key — NOT NULL
- Field (depname) — char(10(
- Field (managerid) — char(10_
- Field (managestartdate) — date(8)
- Field
- Key (employeeid) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (locationadress) — char(10_ — Foreign key → Untitled.Key — NOT NULL
Untitled (project)
- Key (projectnumber) — char(10) — Primary key — NOT NULL
- Field (projectname) — char(10)
- Field (manager department) — char(10)
- Key (departmentid) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (location)
- Key (locationadress) — char(10_ — Primary key — NOT NULL
- Field (buildingname) — char(10)
- Field (chiefmanager) — char(10)