Exercise1

Tables (5)

COMPANY (Untitled2)

  • companyId (Key) — char(5) — Primary key — NOT NULL
  • companyName (Field) — char(30)

COMPONENT (Untitled3)

  • componentId (Key) — char(10) — Primary key — NOT NULL
  • componentName (Field) — char(30)
  • description (Field2) — text
  • producterId (Key2) — char(5) — Foreign key → PRODUCTER.producterId — NOT NULL

PRODUCT (Untitled5)

  • productId (Key) — char(10) — Primary key — NOT NULL
  • productName (Field) — char(30)
  • productPrice (Field2) — char(10)
  • description (Field3) — text
  • companyId (Key2) — char(5) — Foreign key → COMPANY.companyId — NOT NULL

PRODUCTER (Untitled)

  • producterId (Key) — char(5) — Primary key — NOT NULL
  • producterName (Field) — char(30)
  • producterPhone (Field2) — char(11)
  • producterAddress (Field3) — text
  • companyId (Key2) — char(5) — Foreign key → COMPANY.companyId — NOT NULL

PRODUCT_COMPONENT (Untitled4)

  • productComponentId (Key) — char(10) — Primary key — NOT NULL
  • componentAmount (Field) — char(20)
  • componentId (Key2) — char(10) — Foreign key → COMPONENT.componentId — NOT NULL
  • productId (Key3) — char(10) — Foreign key → PRODUCT.productId — NOT NULL