mis-60244147-LYU XUDONG

Tables (10)

Department (Untitled8)

  • dept_id (pk) — Primary key — NOT NULL
  • emp_id (pk2) — Foreign key → employee.emp_id — NOT NULL
  • dept_id (fk) — Foreign key → employee.dept_id — NOT NULL
  • name (Field)
  • floor (Field2)

Dependent (Untitled2)

  • dep_id (pk) — Primary key — NOT NULL
  • emp_id (pk2) — Foreign key → employee.emp_id — NOT NULL
  • dept_id (fk) — Foreign key → employee.dept_id — NOT NULL
  • name (Field)
  • gender (Field2)
  • emp_id (Field3)

Project_Location (Untitled6)

  • proj_id (pk) — Primary key — NOT NULL
  • proj_id (fk) — Primary key — NOT NULL
  • location (pk2) — Primary key — NOT NULL
  • location (Field2)

Supplier (Untitled9)

  • supplier_id (pk) — Primary key — NOT NULL
  • name (Field)
  • credit_rating (Field2)

Supplies (Untitled10)

  • supplier_id (pk) — Primary key — NOT NULL
  • part_id (pk2) — Primary key — NOT NULL
  • proj_id (pk3) — Primary key — NOT NULL
  • supplier_id (fk) — Primary key — NOT NULL
  • part_id (fk2) — Primary key — NOT NULL
  • proj_id (Key6) — Primary key — NOT NULL
  • part_id (Key) — Foreign key → part.part_id — NOT NULL
  • proj_id (pk4) — Foreign key → part.proj_id — NOT NULL
  • emp_id (pk22) — Foreign key → part.emp_id — NOT NULL
  • dept_id (fk3) — Foreign key → part.dept_id — NOT NULL
  • proj_id (pk32) — Foreign key → part.proj_id — NOT NULL
  • proj_id (fk22) — Foreign key → part.proj_id — NOT NULL
  • location (pk222) — Foreign key → part.location — NOT NULL
  • supplier_id (pk5) — Foreign key → Supplier.supplier_id — NOT NULL
  • supplier_id (pk52) — Foreign key → part.supplier_id — NOT NULL
  • supplier_id (pk42) — Foreign key → part.supplier_id — NOT NULL
  • quantity (Field4)

Works_on (Untitled4)

  • emp_id (pk) — Primary key — NOT NULL
  • emp_id (fk) — Primary key — NOT NULL
  • proj_id (fk2) — Primary key — NOT NULL
  • proj_id (pk2) — Primary key — NOT NULL
  • role (Field3)
  • duration (Field4)

employee (Untitled)

  • emp_id (pk) — Primary key — NOT NULL
  • dept_id (fk) — Primary key — NOT NULL
  • name (Field)
  • position (Field2)
  • salary (Field3)
  • city (Field4)
  • district (Field5)
  • neighborhood (Field6)

manages (Untitled7)

  • proj_id (pk) — Primary key — NOT NULL
  • emp_id (fk) — Primary key — NOT NULL
  • dept_id (pk2) — Foreign key → Department.dept_id — NOT NULL
  • emp_id (pk22) — Foreign key → Department.emp_id — NOT NULL
  • dept_id (fk2) — Foreign key → Department.dept_id — NOT NULL
  • start_date (Field2)

part (Untitled5)

  • part_id (Key) — Primary key — NOT NULL
  • proj_id (pk) — Foreign key → project.proj_id — NOT NULL
  • emp_id (pk2) — Foreign key → project.emp_id — NOT NULL
  • dept_id (fk) — Foreign key → project.dept_id — NOT NULL
  • proj_id (pk3) — Foreign key → project.proj_id — NOT NULL
  • proj_id (fk2) — Foreign key → project.proj_id — NOT NULL
  • location (pk22) — Foreign key → project.location — NOT NULL
  • supplier_id (pk5) — Foreign key → Supplier.supplier_id — NOT NULL
  • supplier_id (pk42) — Foreign key → project.supplier_id — NOT NULL
  • name (Field)
  • price (Field2)
  • part_id (Field3)
  • sub_part_id (Field4)
  • part_id (Key2) — Foreign key → part.part_id — NOT NULL
  • proj_id (pk4) — Foreign key → part.proj_id — NOT NULL
  • emp_id (pk23) — Foreign key → part.emp_id — NOT NULL
  • dept_id (fk3) — Foreign key → part.dept_id — NOT NULL
  • proj_id (pk32) — Foreign key → part.proj_id — NOT NULL
  • proj_id (fk22) — Foreign key → part.proj_id — NOT NULL
  • location (pk222) — Foreign key → part.location — NOT NULL
  • supplier_id (pk52) — Foreign key → part.supplier_id — NOT NULL

project (Untitled3)

  • proj_id (pk) — Primary key — NOT NULL
  • emp_id (pk2) — Foreign key → employee.emp_id — NOT NULL
  • dept_id (fk) — Foreign key → employee.dept_id — NOT NULL
  • proj_id (pk3) — Foreign key → Project_Location.proj_id — NOT NULL
  • proj_id (fk2) — Foreign key → Project_Location.proj_id — NOT NULL
  • location (pk22) — Foreign key → Project_Location.location — NOT NULL
  • supplier_id (pk4) — Foreign key → Supplier.supplier_id — NOT NULL
  • name (Field)
  • budget (Field2)