exercise4
Tables (6)
ACTOR (Untitled5)
- aid (Key) — Primary key — NOT NULL
CUSTOMERS (Untitled)
- cno (Key) — Primary key — NOT NULL
- cname (Field)
- caddress (Field2)
DIRECTOR (Untitled6)
- did (Key) — Primary key — NOT NULL
DVD (Untitled2)
- vid (Key) — Primary key — NOT NULL
- mid (Key3) — Foreign key → MOVIE.mid — NOT NULL
MOVIE (Untitled4)
- mid (Key) — Primary key — NOT NULL
- mqty (Field)
- mtitle (Field2)
- myearmade (Field3)
- acode (Key2) — Foreign key → ACTOR.aid — NOT NULL
- dcode (Key3) — Foreign key → DIRECTOR.did — NOT NULL
RENTAL (Untitled3)
- cno (Key) — Foreign key → CUSTOMERS.cno — NOT NULL
- vid (Key2) — Foreign key → DVD.vid — NOT NULL
- rtimes (Field2)
- rdate (Field)