ERD Exercise 4
Tables (8)
Untitled (Customer)
- Key (customerID) — char(10) — Primary key — NOT NULL
- Field (customerName) — char(10)
- Field (adress) — char(30)
- Field (phone) — char(13)
Untitled (DVD)
- Key (dvdCode) — char(10) — Primary key — NOT NULL
- Field (subject) — char(30)
- Field (purchase) — Date
- Field (Year) — imt(4)
- Key (actCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (direcCode) — char(10) — Foreign key → Untitled2.Key — NOT NULL
- Key (ssn) — char(20) — Foreign key → VIDIO STORE.Key — NOT NULL
- Field (description) — text
- Field (award) — text
Untitled (ACTOR)
- Key (actCode) — char(10) — Primary key — NOT NULL
- Field (actName) — char(20)
Untitled (BIOGRAPHY)
- Key (actCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (direcCode) — char(10) — Foreign key → Untitled2.Key — NOT NULL
Untitled (RENT)
- Key (rentID) — char(10) — Primary key — NOT NULL
- Key (customerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (dvdCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (NOTE)
- Key (noteID) — char(10) — Primary key — NOT NULL
- Key (customerID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (dvdCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (rentID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (rentDay) — date
- Field (returnDay) — date
- Field (rentTime) — time
Untitled2 (DIRECTOR)
- Key (direcCode) — char(10) — Primary key — NOT NULL
- Field (direcName)
VIDIO STORE
- Key (ssn) — char(20) — Primary key — NOT NULL
- Field (Name) — char(20)
- Field (phone) — char(13)
- Field (adress) — char(30)