Consider the following ER diagram for part of a Movie database. Each user may ra

Question

Consider the following ER diagram for part of a Movie database. Each user may rate several movies. Each movie may be rated by several users. Each user may be a member of several stores. Each store may have several users as its members. Each movie may be purchased by several stores. A director may direct more than one movie. Each movie must be directed by a director.

Specify the cardinality ratio (1:1, 1:N or M:N) of each relationship in this ER diagram.

Derive the relational database schema from this ER diagram using ER-to-Relational Mapping.

Q9. Consider the following ER diagram for part of a Movie database. Each user may rate several movies. Each movie may be rated by several users. Each user may be a member of several stores Each store may have several users as its members. Each movie may be purchased by several stores A director may direct more than one movie. Each movie must be directed by a director.* (1) (6%) Sbecify the cardinality ratio (1 : 1. 1 N or M:N) of each relationship in this ER diagram. (2) (9%) Derive the relational database schema from this ER diagram using ER-to-Relational Mapping. Uld Name Dld+ DName* Userw Director Rate+ Direct MembeOf MNamej Storew Purchase Movie SID SName Mld

Explanation / Answer

Q9:

1.

Cardinality :

User M:N Movie

User M:N Store

Movie 1: M Store

Director 1:M Movie

2. ER to Relational Mapping

User(UId,Name,MId,SId)

Store(SId,SName)

Director(DId,DName)

Movie(MId,MName,SId,DId)

underlined are primary key attributes and Italicized are foreign key attributes.

Do ask if any doubt. Please upvote.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---