b

Tables (9)

Department (Untitled2)

  • departmentID (Key) — char(30) — Primary key — NOT NULL
  • departmentName (Field) — char(30)

Family (Untitled5)

  • FID (Key) — int(20) — Primary key — NOT NULL
  • fName (Field) — char(30)
  • fBirthDate (Field2) — date
  • fRelationship (Field3) — char(10)
  • EID (Key2) — int(20) — Foreign key → employee.EID — NOT NULL

Maker (Untitled8)

  • mkNumber (Key) — int(20) — Primary key — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(30)
  • phone (Field3) — int(10)

Part (Untitled7)

  • paNumber (Key) — int(20) — Primary key — NOT NULL
  • pexplain (Field) — text
  • mkNumber (Key2) — int(20) — Foreign key → Maker.mkNumber — NOT NULL

Product (Untitled6)

  • pNumber (Key) — int(20) — Primary key — NOT NULL
  • explain (Field) — text
  • price (Field2) — int(20)

Project (Untitled3)

  • projectNumber (Key) — Primary key — NOT NULL
  • projectName (Field)
  • departmentID (Key2) — char(30) — Foreign key → Department.departmentID — NOT NULL

Work_On (Untitled4)

  • PID (Key) — int(20) — Foreign key → employee.EID — NOT NULL
  • projectNumber (Key2) — char(10) — Foreign key → Project.projectNumber — NOT NULL
  • hours (Field) — int(10)

Works_On (Untitled9)

  • paNumber (Key) — int(20) — Foreign key → Part.paNumber — NOT NULL
  • pNumber (Key2) — int(20) — Foreign key → Product.pNumber — NOT NULL
  • partAmount (Field) — int(10)

employee (Untitled)

  • EID (Key) — int(20) — Primary key — NOT NULL
  • name (Field) — char(30)
  • address (Field2) — char(50)
  • wage (Field3) — float
  • gender (Field4) — char(10)
  • birthDate (Field5) — date
  • departmentID (Key2) — char(30) — Foreign key → Department.departmentID — NOT NULL
  • senior (Key3) — int(20) — Foreign key → employee.EID — NOT NULL