You have been asked to analyze the following business for a new database system:

Question

You have been asked to analyze the following business for a new database system:

Kansas Movie Theatre is a small movie theater in downtown Kansas. It only has three movie screens and seats 100 in each theater. The theater has a concession stand that sells popcorn, drinks, nachos, candy and hotdogs. The theater employs 8 employees – 3 that run the movies during the week, 3 that run the concession stand during the week, and 2 that work in the office accounting area. It orders movies for viewing from several different distributors. Movies play for three weeks. Employees get paid every week. It also has movie posters of current and upcoming movies displayed around the main lobby area. It lists the movies playing on their website and in the newspaper.

1. List the various business functions for Kansas Movie Theater and the entities under each business function

2. Draw your E/R diagram based upon the entities you chose for the movie theater. Be sure to include on your diagram the entities, relationships, attributes (you only need to list 3-4 attributes for each entitity), and cardinalities.

Explanation / Answer

first u have to create data from database

Syntax:

create database databasename;

using my sql language

first u have to create business logic functions in database language.

suppose Kanasas movietheater

eantites are called object first u have select proper chairs and places and things some of eantites is used in theater after u have to provide some facilities

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.