Based on Figure $4$ and the business rules given, apply EERD concepts. You may add a

relationship and its multiplicity if it is required.

$(5$ Marks$)$

ClubMember

StarActor

starName$\{$PK$\}$

birthName

DOB

$0..*$

star$\_$in

$1..*$

memberShipNo$\{$PK$\}$

firstName

lastName

phone

address

currentRentDate

currentCredit

$1..*$

rent

Movie

$1..*$

Tape

movieID$\{$PK$\}$

title

category

Business Rules:

$1.\mathrm{.}1$

have$\_$copies

$1..*$

tapeNo$\{$PK$\}$

tapeFormat

Figure $4$: Conceptual ERD

$$ The majority of the movies are box office and each of the box office movies can be

rented for special rate by the club member.

$$ A club member can rent a maximum of $3$ box office movies, and the start rent date

and return date must be recorded.