excersie 4
Tables (7)
Actor (Untitled5)
- Actor Name. (Key) — Primary key — NOT NULL
- Movie Name (Key2) — Foreign key → Movie.Movie Name — NOT NULL
- Actor Birth (Field)
- Actor Age (Field2)
- Actor Gender (Field3)
- Actor Biography (Field4)
Customer (Untitled)
- Customer No. ((PK)) — Primary key — NOT NULL
- Customer Name. (Field)
- Customer Address. (Field2)
- Customer Phone no. (Field3)
- Customer Gender (Field4)
DVD (Untitled3)
- DVD Code (Key) — Primary key — NOT NULL
- Customer No. ((PK)) — Foreign key → Customer.Customer No. — NOT NULL
- DVD No (Field)
- DVD IN Date (Field2)
- DVD Rental (Field3)
- DVD Movie ID (Field4)
DVD_Copy (Untitled4)
- DVD_Copy ID (PK) — Primary key — NOT NULL
- DVD Code (Key) — Foreign key → DVD.DVD Code — NOT NULL
- Customer No. ((PK)) — Foreign key → DVD.Customer No. — NOT NULL
- Rental Id (Key2) — Foreign key → Rental.Rental Id — NOT NULL
- Customer No. ((PK)2) — Foreign key → Rental.Customer No. — NOT NULL
- Customer no. (FK)
- Rental State (Field2)
Director (Untitled7)
- Director Name (Key) — Primary key — NOT NULL
- Movie Name (Key2) — Foreign key → Movie.Movie Name — NOT NULL
- Actor Name. (Key3) — Foreign key → Actor.Actor Name. — NOT NULL
- Movie Name (Key22) — Foreign key → Actor.Movie Name — NOT NULL
- Director Birth (Field)
- Director Age (Field2)
- Director Gender (Field3)
- Director Biography (Field4)
Movie (Untitled2)
- Movie Name (Key) — Primary key — NOT NULL
- Movie Serial No. (Field)
- Movie Actor (Field2)
- Movie Director (Field3)
- Movie BGM (Field4)
- Movie Open date (Field5)
Rental (Untitled6)
- Rental Id (Key) — Primary key — NOT NULL
- Customer No. ((PK)) — Foreign key → Customer.Customer No. — NOT NULL
- Rental Customer Name (Field)
- Rental DVD copy (Field2)
- Rental DVD (Field3)
- Rental Date (Field4)
- Return Date (Field5)