preview

Watchnow Theatres: Database And Database Analysis

Better Essays

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

Get Access