Exercise1

Tables (3)

Idem (Untitled3)

  • idemID (Key) — int — Primary key — NOT NULL
  • idemACC (Field) — char(1000)
  • partID (Key2) — int — Foreign key → Part.partID — NOT NULL

Maker (Untitled2)

  • maketID (Key) — int — Primary key — NOT NULL
  • makerName (Field) — char(30)
  • makerADD (Field2) — char(50)
  • makerPhone (Field3) — int

Part (Untitled)

  • partID (Key) — int — Primary key — NOT NULL
  • partACC (Field) — chat(100)
  • idemID (Key2) — int — Foreign key → Idem.idemID — NOT NULL
  • maketID (Key3) — int — Foreign key → Maker.maketID — NOT NULL