Computerized Reservation System for KTV Bar with Point of Sale

Topics: Entity-relationship model, SQL, Database Pages: 30 (5131 words) Published: October 9, 2013
TABLE OF CONTENTS
1

Introduction

1-1
1-2

1.1 Statement of the Problem

1-3

1.1.1 General Problem

1-3

1.1.2 Specific Problems

1-3
1-4

1.2 Current State of Technology

1-5

1.3 Objectives
1.3.1 General Objectives

1-6

1.3.2 Specific Objectives

1-6
1-7

1.3.3 Scope and Limitation

1-8
1-9

2

2-1

2.1 Introduction

2-1

2.2 Information System

2-1

2.3 Database Management System

2-1

2.4 Graphical User Interface

2-1

2.5 Normalization

2-2

2.6 Programming Language Theories

2-3

2.7 Database Theory

2-4

2.8 Picture Manipulation Theory
3

Theoretical Framework

2-4

Computerized Reservation System for KTV Bar with Point of Sale

3-1

3.1 Introduction

3-1

3.2 System Design Specification

3-1

3.2.1 Data Flow Diagram (DFD)

3-1

3.2.2 Entity Relationship Diagram (ERD)

3-2
3-3

3.3 Summary

3-3

Symbols for Flow Diagram

3-4
3-5

CFD (Context Flow Diagram)
DFD (Data Flow Diagram)

3-7

ERD (Entity Relationship Diagram)

3-8

Performance Analysis

4-1

4.1 Introduction

4-1

4.2 Experimental

4

3-6

4-1

4.2.1 Compatibility in Operating System (OS)

4-1

4.2.2 User friendliness

4-2

4.2.3 Record Maintenance

4-2

4.2.4 Data Security

4-2

4.2.5 Installing Process

4-2

4.2.5.1 Hardware

4-2

4.2.5.2 Software

4-3
4-4

4.3 Results and Analysis

4-5

4.4 Summary

4-6

5.0 Conclusion
5.1 Recommendations

5-0
5-1

1.0 Introduction
Computer is one of the technologies that most people use in their everyday lives. The use of computer is one of the fastest growing and most important developments in our time. People used computers to give easiest and fastest method of finding information. Computers are just known as a piece of equipment where awesome package of glass, plastic, metal and wires- use to make our work easier. It is one way to achieve changes, which we can create different things through using its features. Computers have actually transformed our lives- how we communicate, how we could work and learn things and even how we play. Computers are efficient tools in processing data into useful information. They are essential tools in almost every field of research and applied technologies because of their capabilities. Being computer literate it can give anyone great competitive advantages.

One example of technology is internet, widely used for everyone and popular. Everything can be known in the internet. It is an international network access which serves people by giving information through web access. Example of internet is website which is a collection of web pages, images, information and other digital asset that is hosted one or more web serves usually accessible via internet. KTV Bar is a term in Chinese being used to call a place for fun where you can sing your heart out, Karaoke w/ different variety of songs to choose from is the main attraction of the place, and mostly it was merely a room with different type like VIP, family room and rooms for large number of people.

A transaction processing system is a type of information system. TPSs collect, store, modify, and retrieve the transactions of an organization. A transaction is an event that generates or modifies data that is eventually stored in an information system. The essence of a transaction program is that it manages data that must be left in a consistent state if an electronic payment is made, the amount must be both withdrawn from one account and added to the other; it cannot complete only one of those steps. Either both must occur, or neither. In case of a failure preventing transaction completion, the partially executed transaction must be rolled back by the TPS.

Transactions generally involve an exchange of money, it is critical that the data be protected during transmission and stored carefully so that it cannot be altered. It is also critical that the data be...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Point Of Sale System Documentation Essay
  • Point of sale system Essay
  • point of sale system Research Paper
  • point of sale system ph Research Paper
  • point of sale system Essay
  • eBar: A Point-of-Sale System Essay
  • Point of Sales and Inventory System Essay
  • Leo's Cuisine Point of Sale System Essay

Become a StudyMode Member

Sign Up - It's Free