1001-2/202320621

Tables (4)

department (Untitled2)

  • dno (Key) — Primary key — NOT NULL
  • dname (Field)

employee (Untitled)

  • ssn (Key) — Primary key — NOT NULL
  • fname (Field)
  • minit (Field2)
  • lname (Field3)
  • bdate (Field4)
  • address (Field5)
  • gen (Field6)
  • salary (Field7)

project (Untitled3)

  • pno (Key) — Primary key — NOT NULL
  • pname (Field)
  • plocation (Field2)

works on (Untitled4)

  • (ssn, pno) (Key) — Primary key — NOT NULL
  • hours (Field)