Ex3
Tables (4)
Untitled (DVD)
- Key (dvdCode) — char(10) — Primary key — NOT NULL
- Field (dvdCopyCode) — char(10)
- Field (dvdTitle) — char(20)
- Field (dvdRentDate) — date
- Field (dvdRentTime) — int
- Field
Untitled (Customer)
- Key (CusID) — char(10) — Primary key — NOT NULL
- Field (CusName) — char(20)
- Field (cusAddress) — char(30)
- Field (cusPhone) — char(12)
Untitled (Rent)
- Key (dvdCode) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (CusID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (Movie)
- Key (MovCode) — char(20) — Primary key — NOT NULL
- Field (movTitle) — char(20)
- Field