ERD Exercise1
Tables (7)
Producer (producer)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — char(10)
- Field (PhoneNo) — int
- Field (Company) — char(20)
Untitled (Product)
- Key (id) — int — Primary key — NOT NULL
- Field (description) — char(50)
- Field (price) — int
- Field (status) — char(10)
- Field (ManufacturingDate) — date
- Field (ValidityDate) — date
- Key (CompanyNo) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Part)
- Key (id) — int — Primary key — NOT NULL
- Field (description) — char(50)
- Field (ProducerID) — int
- Key (CompanyNo) — int — Foreign key → Untitled.Key — NOT NULL
- Key (id2) — int — Foreign key → Producer.Key — NOT NULL
- Key (Partid) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Company)
- Key (CompanyNo) — int — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(50)
- Field (PhoneNumber) — int
Untitled (Part_Inventory)
- Key (InventoryNo) — int — Primary key — NOT NULL
- Field (quantity) — int
- Field (location) — char(20)
- Field (status) — char(8)
- Key (id) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Making)
- Key (Partid) — int — Primary key — NOT NULL
- Field (NumberOfPart) — int
- Field
- Key (id3) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (Producer_Company)
- Key (id) — int — Foreign key → Producer.Key — NOT NULL
- Key (CompanyNo) — int — Foreign key → Untitled.Key — NOT NULL