Exercise 4(배미연)
테이블 (5)
Actors (Untitled5)
- ActorCode (Key) — char(5) — 기본 키 — NOT NULL
- DvdTitle (Key2) — char(100) — 외래 키 → DVD.DvdTitle — NOT NULL
- ActorName (Field) — char(30)
- ActorBiography (Field2) — char(100)
Customer (Untitled)
- CustomeruniqueNumber (Key) — char(5) — 기본 키 — NOT NULL
- CustomerName (Field) — char(10)
- CustomerAddress (Field2) — char(100)
- CustomerPhone (Field3) — char(11)
DVD (Untitled2)
- DvdTitle (Key) — char(100) — 기본 키 — NOT NULL
- DvdCode (Field) — char(5)
- DvdPurchasedate (Field2) — date
- DvdRentoftime (Field3) — int
- DvdYearofmade (Field4) — date
Director (Untitled6)
- DirectorCode (Key) — char(5) — 기본 키 — NOT NULL
- DvdTitle (Key2) — char(100) — 외래 키 → DVD.DvdTitle — NOT NULL
- DirectorName (Field) — char(30)
- DirectorBiograghy (Field2) — char(100)
Enroll (Untitled3)
- SerialNumber (Key) — char(5) — 기본 키 — NOT NULL
- RentDate (Field) — date
- RentTime (Field2) — time
- ReturnDate (Field3) — date
- ReturnTime (Field4) — time
- DvdTitle (Key3) — char(100) — 외래 키 → DVD.DvdTitle — NOT NULL
- CustomeruniqueNumber (Key2) — char(5) — 외래 키 → Customer.CustomeruniqueNumber — NOT NULL