Create a model using the entities movie

Assignment Help Programming Languages

Reference no: EM1353232

A. Create a model to represent this report using the entities MOVIE, THEATER, and SHOW_TIME. Assume that theaters may show multiple movies. Although this report is for a particular day, your data model should allow for movie times on different days as well. Specify the identifier of the entities and their attributes. Name the relationships and the type and cardinality of all relationships. Explain which cardinalities you can logically deduce and which need to be checked out with users. Assume that distance is an attribute of THEATER.

B. This report was prepared for a user who is located near downtown Seattle. Suppose that it is necessary to produce this same report for these theaters, but for a user located in a Seattle suburb such as Bellevue, Renton, Redmond, or Tacoma. In this case, distance cannot be an attribute of THEATER. Change your answer in A for this situation. Specify the entity identifiers and attributes. Name the relationships and identify the type and cardinality of all relationships.

C. Suppose that you want to make this data model national. Change your answer to B so that it can be used for other metropolitan areas. Change your answer in A for this situation. Specify the entity identifiers and attributes. Name the relationships and identify the type and cardinality of all relationships.

D. Modify your answer to C to include the leading cast members. Assume that the role of a cast member is not to be modeled. Specify the identifier of new entities and their attributes. Name the relationships and identify the type and cardinality of all relationships.

E. Modify your answer to C to include the leading cast members. Assume that the role of a cast member is specified. Specify the identifier of new entities and their attributes. Name the relationships and identify the type and cardinality of all relationships.

Reference no: EM1353232

Questions Cloud

Determine the projects irr : Project with the following cash flow. Determine the project's IRR? The project projected IRR can be less that the WACC in which case it will be rejected.

Explain what are the key success factors : Explain What are the key success factors for the organisation you work for (or another you know well) to achieve competitive advantage in the markets for its products/services?

Theories or concepts about personality : What are Adler's primary theories/concepts about personality that would apply to Bella?

Explain what venezuelan cultural impacts : Adjusting to Venezuelan Business Culture - Explain what Venezuelan cultural impacts will be the most difficult for you to stomach and how will you cope and adapt?

Create a model using the entities movie : Create a model to represent this report using the entities MOVIE, THEATER, and SHOW_TIME. Assume that theaters may show multiple movies.

Sketch a well labeled graph showing the impact of the tax : Sketch a well labeled graph showing the impact of the tax. On whom does the tax burden fall-the team's, owners, the fans, or both.

Market so critical to product or service innovation : Explain why is speed to market so critical to product or service innovation and what other factors are critical to successful product performance

Assess a corporations financial performance : Determine why are financial ratios used to assess a corporation's financial performance? Why are sales reports, profits, debts, or current liability reports insufficient?

Scored personality tests and projective tests : Explain the main differences between objectively scored personality tests and projective tests. Describe a situation in which you would use each kind of test and why.

User Account

All Pages