p21,p2

Tables (7)

Department (Departmant)

  • deptNo — char — Primary key — NOT NULL
  • name — char
  • managerStartDate (manegerStartDate) — Date
  • locations — char
  • manager — char — Foreign key → Employee.ssn — NOT NULL

Employee

  • ssn — char — Primary key — NOT NULL
  • name — char
  • gender — char
  • salary — int
  • brithDate (birthDate) — Date
  • deptNo — char — Foreign key → Department.deptNo — NOT NULL
  • ssn (supervisorID) — char — Foreign key → Employee.ssn — NOT NULL

Project

  • projNo — int — Primary key — NOT NULL
  • name — char
  • deptNo — char — Foreign key → Department.deptNo — NOT NULL

Untitled (dept_Locations)

  • deptNo — char — Foreign key → Department.deptNo — NOT NULL
  • locNo — char — Foreign key → locations.locNo — NOT NULL
  • Field (startDate) — Date

Untitled (works_on)

  • ssn — char — Foreign key → Employee.ssn — NOT NULL
  • projNo — int — Foreign key → Project.projNo — NOT NULL
  • Field (hoursperWeek) — float

Untitled (depentant)

  • Key (dependID) — char — Primary key — NOT NULL
  • Field (name) — char
  • Field (brithDateeld) — date
  • Field (relation) — char
  • ssn — char — Foreign key → Employee.ssn — NOT NULL
  • Field (parent) — char

locations (Locations)

  • locNo — char — Primary key — NOT NULL
  • locName — char
  • Field (address) — char
  • Field2 (AdminArea) — char