ERD Exercise1
Tables (6)
Untitled (Product)
- Key (UniProNo) — Int(20) — Primary key — NOT NULL
- Field (ProDescrip) — Char(30)
- Field (Price) — Char(15)
Untitled (Part1)
- Key (UniPartNo) — Int(20) — Primary key — NOT NULL
- Field (PartDescrip) — Char(50)
- Field (UniSupNo) — Int(20)
- Key (UniProNo) — Int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (UniSupNo2) — Int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (UniProNo2) — Int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (Part2)
- Key (UniPartNo) — Int(20) — Primary key — NOT NULL
- Field (PartDescrip) — Char(50)
- Field (UniSupNo) — Int(20)
- Key (UniProNo) — Int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (UniSupNo2) — Int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (UniProNo2) — Int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (Part3)
- Key (UniPartNo) — Int(20) — Primary key — NOT NULL
- Field (PartDescrip) — Char(50)
- Field (UniSupNo) — Int(20)
- Key (UniProNo) — Int(20) — Foreign key → Untitled.Key — NOT NULL
- Key (UniProNo2) — Int(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (Found)
- Key (UniProNo) — Int(20) — Primary key — NOT NULL
- Field (UniPartNo) — Int(20)
- Field (Quantity) — Int(10)
Untitled (Supplier)
- Key (UniSupNo) — Int(20) — Primary key — NOT NULL
- Field (Name) — Char(20)
- Field (Address) — Char(50)
- Field (PhoneNo) — Int(20)