exercise 6
Tables (4)
ClubMember (클럽멤버)
- memberShipNo (Key) — Primary key — NOT NULL
- firstName (Field)
- lastName (Field2)
- phone (Field3)
- address (Field4)
- currentRentDate (Field5)
- currentCredit (Field6)
Movie (영화)
- movieID (Key) — Primary key — NOT NULL
- starName (Key2) — varchar(10) — Foreign key → StarActor.starName — NOT NULL
- title (Field)
- category (Field2)
StarActor (배우)
- starName (Key) — varchar(10) — Primary key — NOT NULL
- birthName (Field) — varchar(10)
- DOB (Field2)
Tape (테이프)
- tapeNo (Key) — Primary key — NOT NULL
- movieID (Key2) — Foreign key → Movie.movieID — NOT NULL
- starName (Key22) — varchar(10) — Foreign key → Movie.starName — NOT NULL
- tapeFormat (Field)
- memberShipNo (Key3) — Foreign key → ClubMember.memberShipNo — NOT NULL