City Cinema is required to store information for Movie Hire Business. Each Movie can be hired by one or more Member. A Member can hired only in one Movie. For each MOVIE, the MovieId (identifier), Category (contains more than one category), Title and Year-released are stored. For each MEMBER, its MemberId (Identifier) & Mem-Name (compose of FullName & FamilyName) are stored. Each Movie can be directed by exactly one Director, but a Director may direct one or more Movie. The data needed for each DIRECTOR is DirectorId (identifier), DirName and Address. When a Director is directing a
City Cinema is required to store information for Movie Hire Business. Each Movie can be hired by one or more Member. A Member can hired only in one Movie. For each MOVIE, the MovieId (identifier), Category (contains more than one category), Title and Year-released are stored. For each MEMBER, its MemberId (Identifier) & Mem-Name (compose of FullName & FamilyName) are stored. Each Movie can be directed by exactly one Director, but a Director may direct one or more Movie. The data needed for each DIRECTOR is DirectorId (identifier), DirName and Address. When a Director is directing a Movie the Direction-date is also recorded.
Construct an E-R diagram for the above scenario. Identify entities, attributes of each entity, relationships, relationship attribute (if any), keys, and the minimum and maximum relationship cardinalities.
Step by step
Solved in 2 steps with 1 images