A PROJECT PRESENTATION ON ONLINE MOVIE TICKET BOOKING SYSTEM Internal Guide By PDF

Title	A PROJECT PRESENTATION ON ONLINE MOVIE TICKET BOOKING SYSTEM Internal Guide By
Author	Bill Eddy
Pages	81
File Size	4.2 MB
File Type	PDF
Total Downloads	198
Total Views	586

Preview

CLICK TO PREVIEW PDF

Summary

Description

A PROJECT PRESENTATION ON ONLINE MOVIE TICKET BOOKING SYSTEM

Submitted To : Department Of Computer Science

Developed By : Chirag Modi - 13084231061 Paresh Patel - 13084231165 M.Sc.(CA & IT) - III Sem. Group No. - 03

Internal Guide By : Mrs.Krupa Bhavsar

PROJECT PROFILE Project Title

Online Movie Ticket Booking System

Objective

Booking Tickets for movies in various Theaters by the Users.

Platform

Web base Application

Front End

ASP.NET with C# (.NET Framework 3.5)

Back End

Microsoft SQL Server 2005

Other Tools

Microsoft Office 2007, Adobe Photoshop 6.0

Developed By

Modi Chirag A. Patel Paresh N.

Time Duration

90 Days

Submitted To

Department Of Computer Science

13084231061 13084231165

EXISTING SYSTEM  Manual  Time consuming  Dependent on employee Insecurity

NEED FOR NEW SYSTEM  Computerized  Time saving  Independent of employee  Security

FUNCTION SPECIFICATION ADMIN : In this module The Administrator is maintain the user Details, Movie details, Theater details and Check the number of seats available.

BOOKING TICKETS : In this module The Users will search for the movie and then go for theater then booking the tickets online.

MEMBER : In this modules The user can first Registration in enter the Personal details and User login and If you also want to update personal details. The user collect all information like upcoming Movies details, in advance ticket booking and Theater details.

BOOKING : If you are book ticket by tell so you collect ticket before start show 30 minute otherwise cancel your booking

HARDWARE & SOFTWARE REQUIREMENT Minimum Server Side Requirements : Software Operating System :

Window7 or compatible

Web Server :

IE 6.0 +

Hardware Processor :

1.5 MHz or above

Ram :

1 GB

Hard disk :

5 GB of free space on hard disk

Minimum Client Side Requirements : Software Operating System :

Window XP or compatible

Web Server :

IE 6.0 +

Hardware Processor :

1.5MHz

Ram :

512 MB

Hard disk :

2 GB (only if downloading is needed)

A flow chart is a pictorial representation of any dataflow. It uses different types of Symbols.

BASIC SYMBOL OF FLOWCHART : Terminal

Input/Output

Processing

Flow lines

Decision

Connectors

SYSTEM FLOW CHART

TIME LINE CHART Task

Time Duration (In Days) 15

30

45

60

Total Days 75

90

Requirement Gathering & Analysis

15

Designing

15

Coding

35

Testing

15

Deployment & Implementation

10

Documentation

90

E-R Diagram

Username ADMIN

Password

1 Screen_No View info

M

USER M

Ticket_no Gold Platinum

Seat_no A/c_no

M Seat

User Film

BOOOKING

Silver Movie_name

M Book films

M M

MOVIE INFO 1 ADMIN

Screen_No

UML Diagram

 Use Case Diagram

 Activity Diagram

 Class Diagram

 SEQUENCE DIAGRAM  Admin

 SEQUENCE DIAGRAM  Member

 COLLABORATION DIAGRAM  Admin

 COLLABORATION DIAGRAM  Member

D ATA D I C T I O N A RY

Table Name :- login_info

Description :- To store login information. Primary Key :Foreign Key :Index

Column Name

Data Type

Size

Constraints

Description

1

UserName

Varchar

(50)

Not Null

Used to store Username

2

Password

Varchar

(50)

Not Null

Used to store Password

Table Name :- Movie Description: - To store movie information. Primary Key: - MovieId Foreign Key: Index

Column Name

Data Type

Size

Constraints

Description

1

MovieId

Int

---

Primary key

Used to store Movie Id.

2

MovieName

Varchar

(50)

Not Null

Used to store Movie Name.

3

ImagePath

Varchar

(100)

Not Null

Used to store Image Path.

4

Director

Varchar

(100)

Not Null

Used to store Director.

5

Producer

Varchar

(50)

Not Null

Used to store Producer

6

Cast

Varchar

(200)

Not Null

Used to store Cast

7

Duration

Int

---

Not Null

Used to store Duration

8

Story

Varchar

(8000)

Allow Null

Used to store Story

9

Type

Varchar

(50)

Not Null

Used to store Type (running or upcoming)

Table Name :- CustomerPoints

Description :- To store customer points Primary Key :Foreign Key :- CustomerId

Index

Column Name

Data Type

Size

Constraints

Description

1

CustomerId

Int

---

Foreign Key

Used to store (Forign Key of Customer's column CustomerId)

2

UserName

Varchar

(50)

Not Null

Used to store Username

3

CPoints

Bigint

---

Not Null

Used to store Customer Points

Table Name :- temp Description :- To store the temp data of seats Index

Column Name

Data Type

Size

Constraints

Description

1

Name

Varchar

(50)

Not Null

Used to store name.

2

c1

Int

---

Not Null

Used to store c1.

3

i1

Varchar

(50)

Not Null

Used to store i1.

4

c2

Int

---

Not Null

Used to store c2.

5

i2

Varchar

(50)

Not Null

Used to store i2.

6

c3

Int

---

Not Null

Used to store c3.

7

i3

Varchar

(50)

Not Null

Used to store i3.

8

c4

Int

---

Not Null

Used to store c4.

9

i4

Varchar

(50)

Not Null

Used to store i4.

10

c5

Int

---

Not Null

Used to store c5.

11

i5

Varchar

(50)

Not Null

Used to store i5.

12

c6

Int

---

Not Null

Used to store c6.

13

i6

Varchar

(50)

Not Null

Used to store i6.

14

c7

Int

---

Not Null

Used to store c7.

15

i7

Varchar

(50)

Not Null

Used to store i7.

16

c8

Int

---

Not Null

Used to store c8.

17

i8

Varchar

(50)

Not Null

Used to store i8.

18

c9

Int

---

Not Null

Used to store c9.

19

i9

Varchar

(50)

Not Null

Used to store i9.

20

c10

Int

---

Not Null

Used to store c10.

(Continue…)

21

i10

Varchar

(50)

Not Null

Used to store i10.

22

c11

Int

---

Not Null

Used to store c11.

23

i11

Varchar

(50)

Not Null

Used to store i11.

24

c12

Int

---

Not Null

Used to store c12.

25

i12

Varchar

(50)

Not Null

Used to store i12.

26

c13

Int

---

Not Null

Used to store c13.

27

i13

Varchar

(50)

Not Null

Used to store i13.

28

c14

Int

---

Not Null

Used to store c14.

29

i14

Varchar

(50)

Not Null

Used to store i14.

30

c15

Int

---

Not Null

Used to store c15.

31

i15

Varchar

(50)

Not Null

Used to store i15.

32

c16

Int

---

Not Null

Used to store c16.

33

i16

Varchar

(50)

Not Null

Used to store i16.

34

c17

Int

---

Not Null

Used to store c17.

35

i17

Varchar

(50)

Not Null

Used to store i17.

36

c18

Int

---

Not Null

Used to store c18.

37

i18

Varchar

(50)

Not Null

Used to store i18.

38

c19

Int

---

Not Null

Used to store c19.

39

i19

Varchar

(50)

Not Null

Used to store i19.

40

c20

Int

---

Not Null

Used to store c20.

41

i20

Varchar

(50)

Not Null

Used to store i20.

Table Name :- Book Description :- To store booking information Primary Key :- StatusId Foreign Key :- SeatId , ShowId Index

Column Name

Data Type

Size

Constraints

Description

1

StatusId

Int

---

Primary key

Used to store StatusId

2

SeatId

Int

---

Foreign Key

Used to store (Forign key of Seats's column SeatId)

3

SeatName

Int

---

Allow Null

Used to store Seat Name

4

ShowId

Int

---

Foreign Key

Used to store (Forign key of Show's column ShowId)

5

Status

Bit

---

Not Null

Used to store the status

Table Name :- City

Description :- To store city information Primary Key :- CityId Foreign Key :-

Index

Column Name

Data Type

Size

Constraints

Description

1

CityId

Int

---

Primary key

Used to store city id

2

CityName

Varchar

(50)

Not Null

Used to store city name

3

State

Varchar

(50)

Not Null

Used to store state

Table Name :- Customer Description :- To store customer information Primary Key:- CstomerId Foreign Key:Index

Column Name

Data Type

Size

Constraints

Description

1

CustomerId

Int

---

Primary key

Used to store customer id

2

UserName

Varchar

(50)

Not Null

Used to store Username

3

Pass

Varchar

(50)

Not Null

Used to store Password

4

Fname

Varchar

(50)

Not Null

Used to store First Name

5

Mname

Varchar

(50)

Allow Null

Used to store Last Name

6

Lname

Varchar

(50)

Not Null

Used to store Last Name

7

Gender

Varchar

(50)

Not Null

Used to store Gender (Male or Female)

8

Address

Varchar

(500)

Not Null

Used to store Address

9

City

Varchar

(50)

Not Null

Used to store City

10

Pincode

Int

---

Not Null

Used to store Pincode of city

11

State

Varchar

(50)

Not Null

Used to store State

12

Email

Varchar

(50)

Not Null

Used to store Email of customer

13

Mobile

Bigint

---

Not Null

Used to store Mobile number of customer

Table Name :- Screen

Description :- To store screen information Primary Key : - ScreenId Foreign Key :-TheatreId

Index

Column Name

Data Type

Size

Constraints

Description

1

ScreenId

Int

---

Primary key

Used to store Screen Id

2

ScreenNo

Int

---

Not Null

Used to store Screen number

3

TheatreId

Int

---

Not Null

Used to store (Forign key of Theatre's column TheatreId)

Table Name :- Seats Description :- To store Seat information Primary Key :- SeatId Foreign Key :-

Index

Column Name

Data Type Size

Constraints

Description

1

SeatId

Int

---

Primary key

Used to store Seat Id

2

ScreenId

Int

---

Not Null

Used to store Screen Id

3

RowName

Varchar

(10)

Allow Null

Used to store row number

4

SeatName

Int

---

Not Null

Used to store Seat name

5

ImageUrl

Varchar

(50)

Not Null

Used to store Image path

Table Name :- Show Description :- To store show timing of the movie Primary Key :- ShowId Foreign Key :- MovieId , TheatreId

Index

Column Name

Data Type

Size

Constraints

Description

1

ShowId

Int

---

Primary key

Used to store Show Id

2

MovieId

Int

---

Foreign Key

Used to store (Forign key of Movie's column MovieId)

3

TheatreId

Int

---

Foreign Key

Used to store (Forign key of Theatre's column TheatreId)

4

ScreenId

Int

---

Foreign Key

Used to store (Forign Key of Screen’s column ScreenID)

5

StartTime

Varchar

(50)

Not Null

Used to store Start time of movie

6

EndTime

Varchar

(50)

Not Null

Used to store End time of movie

7

Date

Varchar

(50)

Not Null

Used to store Date of movie

8

PRate

Int

---

Allow Null

Used to store Platinum seat rate

9

GRate

Int

---

Allow Null

Used to store Gold seat rate

10

SRate

Int

---

Allow Null

Used to store Silver seat rate

Table Name :- Theatre Description :- To store Theater information Primary Key :- TheatreId Foreign Key :- CityId

Index

Column Name

Data Type

Size

Constraints

Description

1

TheatreId

Int

---

Primary key

Used to store Theatre Id

2

TheatreName

Varchar

(50)

Not Null

Used to store Theatre name

3

CityId

Int

---

Not Null

Used to store (Forign key of City's column CityId)

4

Address

Varchar

(500)

Not Null

Used to store address of theatre

5

Pincode

Int

---

Not Null

Used to store pincode

6

Nos

Int

---

Not Null

Used to store no of screen

Table Name :- Prints Description :- To store prints details of the movie ticket to customer Primary Key :Foreign Key :-

Index

Column Name

Data Type

Size

Constraints

Description

1

PrintId

Int

---

Not Null

Used to store print id

2

TicketId