hw
Tables (9)
ACTOR (Untitled5)
- actID (Key) — int — Primary key — NOT NULL
- actname (Field)
ACTOR-DIRECTOR LINK (Untitled7)
- actID (Key) — int — Foreign key → ACTOR.actID — NOT NULL
- directorID (Key2) — int — Foreign key → DIRECTOR.directorID — NOT NULL
CUSTOMER (Untitled)
- cusID (Key) — int — Primary key — NOT NULL
- cusName (Field) — char(30)
- cusAdress (Field2) — char(50)
DIRECTOR (Untitled6)
- directorID (Key) — int — Primary key — NOT NULL
- directorName (Field) — char(30)
MOVIE (Untitled4)
- moID (Key) — int — Primary key — NOT NULL
- moTitle (Field) — char(30)
- date (Field2)
MOVIE-ACTOR LINK
- moID (Key) — int — Foreign key → MOVIE.moID — NOT NULL
- actID (Key2) — int — Foreign key → ACTOR.actID — NOT NULL
MOVIE-DIRECTOR LINK (Untitled8)
- moID (Key) — int — Foreign key → MOVIE.moID — NOT NULL
- directorID (Key2) — int — Foreign key → DIRECTOR.directorID — NOT NULL
RENTAL TRANSATION (Untitled3)
- Transaction ID (Key) — int — Primary key — NOT NULL
- date (Field) — int
- moID (Key2) — int — Foreign key → MOVIE.moID — NOT NULL
- cusID (Key3) — int — Foreign key → CUSTOMER.cusID — NOT NULL
VEDIOCASSETTE (Untitled2)
- veID (Key) — int — Primary key — NOT NULL
- Purchase Date (Field) — int
- Rental Count (Field2) — int
- cusID (Key2) — int — Foreign key → CUSTOMER.cusID — NOT NULL
- Field3