WatchNow Theatres
Development of a Database
Submitted to:
Dr. Surya B Yadav
Rawls College of Business Administration
Lubbock, TX - 79409
Submitted by:
Group 10
Akshita Surakanti (R#: 11326738)
Bharathi Tokala (R#: 11335740)
Satya Prakash Enugula (R#: 11333931)
Table of Contents
Project Description 3
Application and Database Analysis 5
User Information Needs: 5
Business Rules: 6
Volume Needs: 7
Response Time 7
Security needs 7
Conceptual Data Model 7
Identification of Object Types: 7
Identification of Relationships: 8
Object Oriented Data Model in UML Notation: 9
Project Description
Any transaction in terms of purchasing and selling of goods or services that is done online across the Internet is called
…show more content…
The Business rules are identified and other non-functional requirements such as Volume, Response Time, Security and others are also identified.
User Information Needs:
Below is the information that user is requires from the database:
• List of all the cities that WatchNow theatres operate in.
• List of customers who have made bookings in the last 1-month.
• Retrieve all the theatres in a City, which are playing the movie “Godfather”.
• List all the movies under a specific genre, example: Comedy.
• For a specific customer, list all the bookings he has made in the past 5 years.
• For a given movie, display all the information related to the Cast & Crew, Release Date.
• Names of all the distributors who are distributing movies to a specific theatre location in ‘New York’ City.
• Number of Seats available for the movie “X-Men” in Dallas – Theatre Centre for the 9:00PM show tonight.
• List all the “Hindi” movies currently playing across all city locations in WatchNow theatres.
• Price of each ticket for
…show more content…
• Science Fiction
• Adventure
• Action
• Comedy Identification of Relationships:
We have identified the following relationships between the object types based upon the business rules and project problem:
Object Type Relationship Object Type
Company 1 0..* Employees
Company 1 0..* Cities
Cities 1 0..* Theatre
Theatre * * Movie
Theatre * * Distributor
Theatre * * Screens
Movie 1 0..* Ratings and Reviews
Movie 1 1 Movie Information
Movie Information 1..* * Cast & Crew
Movie 1 0..* Language
Movie 1 1 Genres
Customer 1 0..* Ticket
Ticket 1 1..* Ticket Item
Ticket Item * 1 Theatre Movie
Customer 1 0..* Card Details
Object Oriented Data Model in UML
In the early 1900’s, as films stated centering their focus on profit, large scale studios came onto the film scene. The studios that were discussed in the chapter were: Universal, United Artists, Paramount, Warner Bros, MGM, Fox, Columbia, and RKO. These studios employed some of the biggest names in the film world at the time. Many of these studios are still in business today, and have given prominent actors and directors their shot at fame. Universal was the first studio to move to the west coast. They produced popular films such as The
EdgeMark Cinemas are a chain of movie theaters located in 37 states with 475 theaters in those states covering the west coast, east coast, and Midwest. EdgeMark’s profits, like other cinemas, have been in a small but constant decline over the last 12 years. Industry Wide Average of 2.05% ticket sales decline per year for the last 12 years also, when adjusted for inflation, revenue has dropped an average of 1% a year for the past 12 years (Domestic Movie Theatrical Market Summary, 2015). The chain is currently looking to increase ticket sales, loyal customers, and profits by adding additional products and services.
In the brick and mortar movie rental industry, Blockbuster is clearly the leader. With the merger of Hollywood Video and
Modern technology isn't disappearing and the need for movie theaters will continuously decline. If movie theater owners take the time to examine several of these options they will certainly find one that functions for them and begin to earn a revenue that is truly theirs.
b. The transaction is an exchange of a product or property held for sale in the ordinary course of business for a product or property to be sold in the same line of business to facilitate sales to customers other than the parties to the exchange.
The method is renowned as being the oldest among all other techniques of segmenting markets. Harkins Theatres company has also segmented its market using the geographical location basis. They have identified locations that are promising a set up a total of thirty theatres in those locations. These locations include not only Arizona but also California, Colorado, Oklahoma and Texas where there are a total of 434 screens. Harkins Theatres targets individuals and families that enjoy wathcing movies and having fun along with their children. Many families have made this a summer tradition to get their kids in to the movies and have fun during
Motion pictures are a key driver of the market for entertainment products, one of the largest export markets in US. Motion picture industry consists of three stages: studio production, distribution, and exhibition. The studios produce the lifeblood of the industry, the films that are its content. The biggest players at this level are the majors, big studios which integrate production and distribution, as do the slightly smaller mini-majors. The next stage is distribution. Distributors are the intermediaries between the studios and exhibitors. Distribution entails all steps following a film’s artistic completion including marketing, logistics, and administration. Distributors coordinate the manufacture and distribution of
The non-functional requirements are the attributes of the system; these include: reliability, performance, cost, system quality attributes, and the challenges encountered during installation.
To provide an analysis and make recommendations to increase revenue in the movie exhibition industry.
The modern film industry was born around the beginning of the twentieth century. On April 23rd 1896 Thomas Edition showed the first publicly-projected motion picture at Koster and Bial's Music Hall in New York City. From there the film industry had an explosive growth rate. In fact,
What kind of systems are described in this case? Identify and describe the business processes each supports. Describe the inputs, processes, and outputs of these systems.
When one goes to watch a movie at the theater, they have to plan which theater to
• Blockbuster is a generally perceived name in the feature rental business sector, being the first move into the
The costs, methods of distribution, and themes of Hollywood and Nollywood films reflect strongly their target audiences; how the target audience affects the production of a film and how the production of a movie is designed to capture a specific
E-commerce Explain what is meant by the term ‘E-commerce’. It is the conducting of business communication and transactions over networks and through computers. As most restrictively defined, electronic commerce is the buying and selling of goods and services, and the transfer of funds, through digital communications. However EC also includes all inter-company and intra-company functions (such as marketing, finance, manufacturing, selling, and negotiation) that enable commerce and use electronic mail, EDI, file transfer, fax, video conferencing, workflow, or interaction with a remote computer. Electronic commerce also includes buying and selling over the Web, electronic funds transfer, smart cards, digital cash (e.g.