ERD Exercise 4
Tables (6)
ACTOR (Untitled5)
- actorId (Key) — char(10) — Primary key — NOT NULL
- actorBiography (Key2) — char(100) — NOT NULL
CUSTOMER (Untitled)
- customerId (Key) — char(10) — Primary key — NOT NULL
- customerName (Field) — char(20)
- address (Field2) — char(50)
CUSTOMERDVD (Untitled6)
- customerId (Key) — char(10) — Foreign key → CUSTOMER.customerId — NOT NULL
- dvdName (Key2) — char(30) — Foreign key → DVDTitle.dvdName — NOT NULL
- dvdId (Key22) — char(10) — Foreign key → DVDTitle.dvdId — NOT NULL
- RentalDateTime (Field) — datetime
DIRECTOR (Untitled4)
- directorId (Key) — char(10) — Primary key — NOT NULL
- directorBiography (Field) — char(100)
DVDLIST (Untitled2)
- dvdId (Key) — char(10) — Primary key — NOT NULL
- purchase (Field)
DVDTitle (Untitled3)
- dvdName (Key) — char(30) — Primary key — NOT NULL
- dvdId (Key2) — char(10) — Foreign key → DVDLIST.dvdId — NOT NULL
- YearOfManufacture (Field) — date
- Field2
- directorId (Key3) — char(10) — Foreign key → DIRECTOR.directorId — NOT NULL
- actorId (Key4) — char(10) — Foreign key → ACTOR.actorId — NOT NULL