exercise1

Tables (4)

Manufacturer

  • ManufacturerId — INT
  • Name — VARCHAR(255)
  • Address — VARCHAR(255)
  • PhoneNumber — VARCHAR(20)

Part

  • PartId — INT
  • Description — VARCHAR(255)
  • ManufacturerId — INT

Product

  • ProductId — INT
  • Description — VARCHAR(255)
  • Price — DECIMAL(10, 2)

ProductPart

  • ProductId — INT
  • PartId — INT
  • UsageAmount — INT