ERD Ex04
Tables (6)
Actors (CopyOfUntitled5)
- UniqueCode (Key) — char(5) — Primary key — NOT NULL
- MovieTitle (Field) — char(50)
- Biography (Field2) — char(100)
- UniqueIdentifierOfMovie (Field3) — char(6)
- TitleOfMovie (Key2) — char(50) — Foreign key → Movie Informaton.TitleOfMovie — NOT NULL
Copy of Videocassette (Untitled2)
- UniqueIdentifier (Key4) — char(6) — Primary key — NOT NULL
- UniqueCode (Key) — char(4) — Foreign key → Videocassette.UniqueCode — NOT NULL
- TitleOfMovie (Key2) — char(50) — Foreign key → Videocassette.TitleOfMovie — NOT NULL
- RentedDate (Field2) — char(8) — Foreign key → Videocassette.RentedDate
- DateOfPurchase (Field) — char(8) — Foreign key → Videocassette.DateOfPurchase
Customers (Untitled)
- UniqueCode (Key) — char(5) — Primary key — NOT NULL
- CustomerNumber (Key2) — char(5) — Primary key — NOT NULL
- CustomerName (Field) — char(10)
- CustomerAdress (Field2) — char(100)
- Name of Rented DVD (Field3) — char(50)
- TitleOfMovie (Key22) — char(50) — Foreign key → Videocassette.TitleOfMovie — NOT NULL
- RentedDate (Field22) — char(8) — Foreign key → Videocassette.RentedDate
- DateOfPurchase (Field5) — char(8) — Foreign key → Videocassette.DateOfPurchase
Directors (Untitled5)
- UniqueCode (Key) — char(5) — Primary key — NOT NULL
- MovieTitle (Field) — char(50)
- TitleOfMovie (Key2) — char(50) — Foreign key → Movie Informaton.TitleOfMovie — NOT NULL
- Biography (Field2) — char(100)
- TitleOfMovie (Key3) — char(50) — Foreign key → Movie Informaton.TitleOfMovie — NOT NULL
- RentedDate (Field22) — char(8) — Foreign key → Movie Informaton.RentedDate
- DateOfPurchase (Field3) — char(8) — Foreign key → Movie Informaton.DateOfPurchase
Movie Informaton (Untitled4)
- TitleOfMovie (Key) — char(50) — Primary key — NOT NULL
- UniqueIdentifier (Field) — char(6)
- ProductionYear (Field2) — char(8)
- UniqueCode (Key2) — char(4) — Foreign key → Videocassette.UniqueCode — NOT NULL
- NumbersOfCopy (Key4) — char(2) — Foreign key → Videocassette.NumbersOfCopy — NOT NULL
- RentedDate (Field22) — char(8) — Foreign key → Videocassette.RentedDate
- DateOfPurchase (Field3) — char(8) — Foreign key → Videocassette.DateOfPurchase
- UniqueCode (Key3) — char(5) — Foreign key → Actors.UniqueCode — NOT NULL
Videocassette (Untitled3)
- UniqueCode (Key) — char(4) — Primary key — NOT NULL
- TitleOfMovie (Key2) — char(50) — Primary key — NOT NULL
- NumbersOfCopy (Key4) — char(2) — Primary key — NOT NULL
- RentedDate (Field2) — char(8) — Primary key
- DateOfPurchase (Field) — char(8) — Primary key
- RentedNumbers (Field3) — char(4)
- CumstomerNumber (Field4) — char(5)
- UniqueCode (Key5) — char(5) — Foreign key → Customers.UniqueCode — NOT NULL
- CustomerNumber (Key22) — char(5) — Foreign key → Customers.CustomerNumber — NOT NULL