ex4
Tables (9)
Actor (Untitled5)
- aCode (Key) — char(14) — Primary key — NOT NULL
- aBiography (Field) — char(50)
Customer (Untitled)
- cId (Key) — char(14) — Primary key — NOT NULL
- cName (Field) — char(10)
- cAdress (Field2) — char(40)
Director (CopyOfUntitled5)
- DirectorCode (Key) — char(14) — Primary key — NOT NULL
- DirectorBiography (Field) — char(50)
Dvd (Untitled2)
- dCode (Key) — char(14) — Primary key — NOT NULL
- mCode (Key2) — char(14) — Foreign key → Movie.mCode — NOT NULL
- dPurchaseDate (Field2) — date
- dRentalquantity (Field3) — integer
DvdRental (Untitled3)
- rentalCode (Key3) — Primary key — NOT NULL
- dCode (Key2) — char(14) — Foreign key → Dvd.dCode — NOT NULL
- mCode (Key22) — char(14) — Foreign key → Dvd.mCode — NOT NULL
- rentalDate (Field) — date
- rentalTime (Field2) — AA
- cId (Key) — char(14) — Foreign key → Customer.cId — NOT NULL
GENRE (Untitled7)
- genreId (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
Movie (Untitled4)
- mCode (Key) — char(14) — Primary key — NOT NULL
- mTitle (Field) — char(30)
- mYear (Field2) — integer
MovieInformation (Untitled6)
- Infocode (Key4) — Primary key — NOT NULL
- DirectorCode (Key2) — char(14) — Foreign key → Director.DirectorCode — NOT NULL
- aCode (Key3) — char(14) — Foreign key → Actor.aCode — NOT NULL
- mCode (Key) — char(14) — Foreign key → Movie.mCode — NOT NULL
movie Genre (Untitled8)
- mCode (Key) — char(14) — Foreign key → Movie.mCode — NOT NULL
- genreId (Key2) — Foreign key → GENRE.genreId — NOT NULL