ERD Ex1
Tables (5)
Company
- Key (mName) — char(20) — Foreign key → Manufacturer.Key — NOT NULL
- Key (Name) — char(20) — Foreign key → Product.Key — NOT NULL
Manufacturer
- Key (mName) — char(20) — Primary key — NOT NULL
- Field (mNumber) — char(10)
- Field (mAddress) — char(30)
- Field (mPhonenumber) — char(10)
- Key (PartName) — char(20) — Foreign key → Parts.Key — NOT NULL
Parts
- Key (PartName) — char(20) — Primary key — NOT NULL
- Field (PartNumber) — char(10)
- Field (PartExplain) — char(50)
- Key (Name) — char(20) — Foreign key → Product.Key — NOT NULL
- Key (mName) — char(20) — Foreign key → Manufacturer.Key — NOT NULL
Product
- Key (ProductName) — char(20) — Primary key — NOT NULL
- Field (ProductNumber) — char(10)
- Field (ProductExplain) — char(50)
- Key (PartName) — char(20) — Foreign key → Parts.Key — NOT NULL
trace (Untitled)
- Key (PartName) — char(20) — Foreign key → Parts.Key — NOT NULL
- Key (ProductName) — char(20) — Foreign key → Product.Key — NOT NULL