exercise4
Tables (5)
CUSTOMER (Untitled)
- customerNo (Key) — char(5) — Primary key — NOT NULL
- customerName (Field) — char(30)
- customerAddress (Field2) — text
DVDRentalList (Untitled3)
- rentallistNo (Key) — char(5) — Primary key — NOT NULL
- rentalStartDate (Field) — date
- rentalStartTime (Field2) — date
- rentalReturnDate (Field3) — date
- rentalReturnTime (Field4) — date
- customerNo (Key2) — char(5) — Foreign key → CUSTOMER.customerNo — NOT NULL
- dvdCode (Key3) — char(5) — Foreign key → DVDSTOCK.dvdCode — NOT NULL
DVDSTOCK (Untitled2)
- dvdCode (Key) — char(5) — Primary key — NOT NULL
- dvdPurchaseDate (Field) — date
- dvdNumberofRentals (Field2) — char(5)
- movieId (Key2) — char(6) — Foreign key → MOVIES.movieId — NOT NULL
MOVIES (Untitled4)
- movieId (Key) — char(6) — Primary key — NOT NULL
- movieTitle (Field) — char(30)
- movieYearMade (Field2) — date
MovieAssociate (Untitled5)
- associateId (Key) — char(5) — Primary key — NOT NULL
- associateName (Field) — char(30)
- biograph (Field2) — text
- movieId (Key2) — char(6) — Foreign key → MOVIES.movieId — NOT NULL