Exercise4
Tables (6)
Copy of Videocassette (Untitled3)
- ID (Key) — char(10) — Primary key — NOT NULL
- number of time of rent (Field) — char(10)
- purchase date (Field2) — char(10)
Customer (Untitled)
- NmberID (Key) — char(10 — Primary key — NOT NULL
- Name (Field) — char(10)
- Adress (Field2) — char(10)
- Date (Field3) — date
- Time (Field4) — char(10)
- ID (Key2) — char(10) — Foreign key → Videocassette.ID — NOT NULL
Director (Untitled6)
- ID (Key) — char(30) — Primary key — NOT NULL
- biograpy (Field) — text
Movie Title (Untitled4)
- ID (Key) — char(30) — Primary key — NOT NULL
- title (Field) — char(30)
- made year (Field2) — char(4)
- actor (Field3) — char(30)
- ID (Key2) — char(30) — Foreign key → actor.ID — NOT NULL
- ID (Key3) — char(30) — Foreign key → Director.ID — NOT NULL
Videocassette (Untitled2)
- ID (Key) — char(10) — Primary key — NOT NULL
- purchase date (Field) — date
- number of time of rent (Field2) — char(10)
- Field3
- ID (Key2) — char(10) — Foreign key → Copy of Videocassette.ID — NOT NULL
- ID (Key3) — char(30) — Foreign key → Movie Title.ID — NOT NULL
actor (Untitled5)
- ID (Key) — char(30) — Primary key — NOT NULL
- biograpy (Field) — text