HW1(10_06)
Tables (4)
Part (Untitled2)
- SerialNo (Key) — integer — Primary key — NOT NULL
- Summary (Field) — char(50)
- serialNo (Key2) — integer — Foreign key → Producer.serialNo — NOT NULL
- SerialNo (Key3) — integer — Foreign key → Product.SerialNo — NOT NULL
Part Volume (Untitled4)
- PARTvoID (Key) — integer — Primary key — NOT NULL
- SerialNo (Key4) — integer — Foreign key → Part.SerialNo — NOT NULL
- SerialNo (Key3) — integer — Foreign key → Product.SerialNo — NOT NULL
- gty (Key5) — integer — NOT NULL
Producer (Untitled)
- serialNo (Key) — integer — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(50)
- phone (Field3) — integer
Product (Untitled3)
- SerialNo (Key) — integer — Primary key — NOT NULL
- Summary (Field) — char(50)
- Price (Field2) — integer