ERD Exercise 4
Tables (7)
ACTOR (Untitled5)
- actorCode (Key) — char(10) — Primary key — NOT NULL
- biography (Field) — char(100)
COPY (Untitled7)
- copyCodeNumber (Key) — char(10) — Primary key — NOT NULL
- CodeNunmer (Key2) — char(10) — Foreign key → VIDEOCASSETTE.CodeNunmer — NOT NULL
- movietitleNumber (Key22) — char(10) — Foreign key → VIDEOCASSETTE.movietitleNumber — NOT NULL
- actorCode (Key3) — char(10) — Foreign key → VIDEOCASSETTE.actorCode — NOT NULL
- directorCode (Key4) — char(10) — Foreign key → VIDEOCASSETTE.directorCode — NOT NULL
- copyName (Field) — char(10)
CUSTOMER (Untitled)
- CustomerNumber (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(10)
- address (Field2) — char(40)
- firstRentalDate (Field3) — date
DIRECTOR (Untitled6)
- directorCode (Key) — char(10) — Primary key — NOT NULL
- biography (Field) — char(100)
MOVIETITLE (Untitled4)
- movietitleNumber (Key) — char(10) — Primary key — NOT NULL
- actorCode (Key3) — char(10) — Foreign key → ACTOR.actorCode — NOT NULL
- directorCode (Key4) — char(10) — Foreign key → DIRECTOR.directorCode — NOT NULL
- titleName (Field) — char(20)
- yearMade (Field2) — date
- CodeNunmer (Key2) — char(10) — Foreign key → VIDEOCASSETTE.CodeNunmer — NOT NULL
RENT (Untitled3)
- rentCodeNunmer (Key2) — char(10) — Foreign key → VIDEOCASSETTE.CodeNunmer — NOT NULL
- movietitleNumber (Key23) — char(10) — Foreign key → VIDEOCASSETTE.movietitleNumber — NOT NULL
- actorCode (Key3) — char(10) — Foreign key → VIDEOCASSETTE.actorCode — NOT NULL
- directorCode (Key4) — char(10) — Foreign key → VIDEOCASSETTE.directorCode — NOT NULL
- rentDate (Field) — date
- CustomerNumber (Key) — char(10) — Foreign key → CUSTOMER.CustomerNumber — NOT NULL
- CodeNunmer (Key22) — char(10) — Foreign key — NOT NULL
VIDEOCASSETTE (Untitled2)
- CodeNunmer (Key) — char(10) — Primary key — NOT NULL
- movietitleNumber (Key2) — char(10) — Foreign key → MOVIETITLE.movietitleNumber — NOT NULL
- actorCode (Key3) — char(10) — Foreign key → MOVIETITLE.actorCode — NOT NULL
- directorCode (Key4) — char(10) — Foreign key → MOVIETITLE.directorCode — NOT NULL
- PurchaseNumber (Field2) — date
- RentTimeNumber (Field3) — char(10)