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