Question

In: Computer Science

Database: Our AD is Movie Theater. Create an ER diagram with the following entities: Staff, Ticket,...

Database:

Our AD is Movie Theater.
Create an ER diagram with the following entities: Staff, Ticket, Movie, Session, Hall, Seat, Director, Actor, Distributor, and Roles. AND also identify the type of relations between the entities with notations and explain why you used it.

**Read the question carefully before you answer**

Solutions

Expert Solution

The entity staff is related to ticket by issuing a ticket for a session. Here ticket is weak entity as it has no existence without a staff or session so, ticket is mentioned as double rectangle.

One staff can isssue many tickets denoted as one to many relationship. One ticket is essential for a particular session so they both has one to one relationship.

Session is entity with two derived entities movie playing in each session and related Hall. So it is denoted as has a relationship.

Hall has seats as weak entity. Entity movie is related to actor distributor and director.

Movie is directed by a director and both has one to one relationship as one director directs one movie.

Movie is distributed byba distributor both of them also have one to one relationship.

Movie is performed by an actor and it has one to one relationship. And the entity has a weak entity as roles as roles can't exist without an actor.


Related Solutions

1- [4 Marks] Create an ER diagram for a movie theater company. The company had its...
1- [4 Marks] Create an ER diagram for a movie theater company. The company had its registered number and name of the company. The company may own many theaters, and each theater has unique Id, name, and address. Every theater must be owned by one or more companies. In each theater, multiple movies can be played. However, each movie may be played in one theater only. A movie can be played on one or multiple screens; every screen has id...
Draw the ER diagram for the following: Emerging Electric wishes to create a database with the...
Draw the ER diagram for the following: Emerging Electric wishes to create a database with the following entities and attributes: (10) • Customer, with attributes Customer ID, Name, Address (Street, City, State, Zip Code), and Telephone • Location, with attributes Location ID, Address (Street, City, State, Zip Code), and Type (values of Business or Residential) • Rate, with attributes Rate Class and RatePerKWH After interviews with the owners, you have come up with the following business rules: • Customers can...
XYZ operates a movie theater. A movie ticket is $16.00 per ticket, and costs nothing
  XYZ operates a movie theater. A movie ticket is $16.00 per ticket, and costs nothing. On average 40% of the customers will buy a soda ($6 each, cost $1); 60% will buy food ($6 average price with a cost of $2). The fixed costs are $387,600. Calculate the break-even quantity and $sales for tickets, soda and food(10 points)   The theater wishes to make $96,900 profit. Calculate the target profit quantity and sales for tickets, soda and popcorn (10 points)...
Create ER diagram for the following: A database has been designed for a Human Resources for...
Create ER diagram for the following: A database has been designed for a Human Resources for a school in the UK. The database includes records of the teachers and their holidays. The Dean of this school has the power to approve those holidays for all teachers in the school.    For each teacher, Human Resources keeps track of the Teacher's ID, name, Cell phone number(s), total number of holidays for each year, number of unemployed holiday days remaining in the...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) DRAW ER DIAGRAM AS ONE FULL LIBRARY SYSTEM, NOT DIFFERENT FOR EACH ATTRIBUTE. Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID:...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID: Key identifier, required, simple single valued Book_Name: Key identifier, required, simple, single-valued Genre:...
Company X database Create an ER Diagram using UML notation for the following tables, then write...
Company X database Create an ER Diagram using UML notation for the following tables, then write out in the Relational model. Company X is a manufacturing company that binds and sells books. They have hired you to create database to track their Employees, Products, customers and their orders. All employees work with book Binding, Only some are designated as Reps for customers. Reps may have many customers. But each customer can only have 1 rep. They count to record each...
Create a database and design an ER diagram for the given question. Must link the related...
Create a database and design an ER diagram for the given question. Must link the related tables then implement the design using MySQL. Insert at least 5 records. Ensure that the data to be added are related to other tables. Follow this format in creating the database and table: Database format: databasename_yourname Table format: tablename_yourname QUESTION: Company ABC has the following business rules. A department employs many employees, but each employee is employed by only one department. A division operates...
To conduct an experiment, a movie theater increased movie ticket prices from $9 to $10 and...
To conduct an experiment, a movie theater increased movie ticket prices from $9 to $10 and measured the change in ticket sales. The theater then gathered data over the following month to determine whether the price increase was profitable. Assume total costs to the theater are the same, whether the price of a ticket is $9 or $10. In order for the ticket price to have been profitable over the month, the elasticity of demand for movie tickets must be...
Problem #4 – Logical Operators: Movie Ticket Price The local movie theater in town has a...
Problem #4 – Logical Operators: Movie Ticket Price The local movie theater in town has a ticket price of $12.00. But, if you are a senior (55 and older), or are under 10, or are seeing a matinee which screens from 3 pm to 5 pm, you get the discounted price of $7.00, nice! Hint 1: "55 and older" is INCLUSIVE Hint 2: under 10 is EXCLUSIVE Hint 3: the range 3 to 5 is INCLUSIVE Hint 4: limit 1...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT