ex_1

Tables (3)

COMPONENTS (Untitled3)

  • componentId (Key) — char(10) — Primary key — NOT NULL
  • componentName (Field) — char(8)
  • componentExp (Field2) — char(10)
  • producerId (Key2) — char(10) — Foreign key → PRODUCER.producerId — NOT NULL

PRODUCER (Untitled4)

  • producerId (Key) — char(10) — Primary key — NOT NULL
  • producerName (Field) — char(4)
  • producerAddress (Field2) — char(8)
  • ProducerPhoneNumber (Field3) — char(10)
  • producId (Key2) — char(10) — Foreign key → PRODUCT.producId — NOT NULL
  • componentId (Key3) — char(10) — Foreign key → COMPONENTS.componentId — NOT NULL

PRODUCT (Untitled)

  • producId (Key) — char(10) — Primary key — NOT NULL
  • productName (Field) — char(8)
  • productPrice (Field2) — char(10)
  • producerId (Key2) — char(10) — Foreign key → PRODUCER.producerId — NOT NULL
  • componentId (Key3) — char(10) — Foreign key → COMPONENTS.componentId — NOT NULL