문제1
테이블 (6)
Actor (Untitled5)
- actorID (Key) — char(30) — 기본 키 — NOT NULL
- actorBiography (Field) — text
CUSTOMER (Untitled)
- custID (Key) — char(30) — 기본 키 — NOT NULL
- custName (Field) — char(30)
- custAddress (Field2) — char(30)
CUSTOMER_RENT_DVD (Untitled6)
- custID (Key) — char(30) — 외래 키 → CUSTOMER.custID — NOT NULL
- DVDID (Key2) — char(30) — 외래 키 → DVD.DVDID — NOT NULL
- rentalDate (Field) — date
DVD (Untitled2)
- DVDID (Key) — char(30) — 기본 키 — NOT NULL
- copyID (Field) — char(30)
- purchaseDate (Field2) — date
- numberOfRental (Field3) — Int(10)
Director (Untitled4)
- directorID (Key) — char(30) — 기본 키 — NOT NULL
- directorBiography (Field) — text
MOVIE (Untitled3)
- movieID (Key) — char(30) — 기본 키 — NOT NULL
- movieName (Field) — char(30)
- productionYear (Field2) — date
- DVDID (Key2) — char(30) — 외래 키 → DVD.DVDID — NOT NULL
- actorID (Key3) — char(30) — 외래 키 → Actor.actorID — NOT NULL
- directorID (Key4) — char(30) — 외래 키 → Director.directorID — NOT NULL