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