Movie Theatre (75 points) A local movie theatre wants to des…
Movie Theatre (75 points) A local movie theatre wants to design a database for their movie showings. They want to keep track of the following: Movies – movieID, name of movie, movie duration, movie description. Genre of the movie such as comedy, action, sci-fi, etc. Classification of movies is also needed such as G-General, PG-Parent Guidance, MA-Mature Audiences, R-Restricted. You can add additional entities, attributes, constraints or other details as necessary. A. Brainstorm the above scenario and type in the space provided the ENTITIES this local flower shop will need to keep track of. (10 points) B. Brainstorm the above scenario and type in the space provided the ATTRIBUTES the flower shop will need to keep track of per ENTITY, explain any CONSTRAINTS the attributes may have, also identify PK and FK attributes. (10 points) C. Brainstorm the above scenario and type in the spaced provided what form of relationship each ENTITY will have with one another. (10 points) D. Brainstorm the above scenario and type in the space provided or on the Word document the CARDINALITY between the ENTITIES. (10 points) E. Finally, create the Logical (15 points) and Physical (20 points) ERD for this scenario. (35 points total – Insert the diagram or copy and paste from the diagramming software into the provided space.
Read Details