Cyber Café Management System for Nyxx Internet Café

Pasig Catholic College

Cyber Café Management System for Nyxx Internet Café

A Project presented to the

PCC College Department

In Partial Fulfillment

of the requirements for the Course

of Database Management

System 1

By:

Eleazar, Joshua

Padua, Christmell Concepcion

Trinidad, Christian Joy

April 2018

Chapter I

INTRODUCTION

The modern technology gave us the idea to create business. A computer shop seems to be perfect. It monitors time, less work for the owner of the computer shop. But as they used it, they realized that there are things that need to be solved immediately so that it won’t affect the business.

Nowadays, most of the people especially in the business is using computer. The use of the computer set changes to human being. It lessen the task of a man and some other things without spending too much time on a job their working on, because of the rapid advancement of the technology, more business have relied on the use of the computers.

Computer is applied to all operational and informational processing function of every business. It is widely recognized that the scope of the computer application must extend beyond design and production to include the business of the firm.

1.1 Background of the study

The internet café uses manual system in recording the usage of their computers. They use a log book that contains the following list: computer number, time in and time out, time to be consumed and amount to be paid aside from this test, the server also obliged to ask or mind if the costumer is going to extend their time. After that, they encircle the computer number, calculate it by computing the time the costumer has consumed.

1.2 Objectives of the study

   1.2.1 General Objectives

• To create, design and develop a Cyber café Management System using online sales         analysis and reports for Nyxx Internet café

   1.2.2 Specific Objective

• To create and design a network virtualization on every client using client computers using the server computer
• To design Nyxx internet café earn more profit
• To create a Cyber Café Management System that has bandwidth limitations and download restrictions
• To create a Cyber Café Management System that has a detailed list of transactions or sale reports for the owner of the internet café

Chapter II

Documentation of the current system

2.1 Process Flow (Flow Chart)

        [pic 1][pic 2][pic 3][pic 4][pic 5][pic 6][pic 7][pic 8][pic 9][pic 10][pic 11][pic 12][pic 13][pic 14][pic 15][pic 16][pic 17][pic 18][pic 19][pic 20]

Chapter III

Requirements Analysis Specification

3.1 Data Dictionary (Data Map)

        CustomerTBL

[pic 21]

        EmployeeTBL

[pic 22]

        SessionTBL

[pic 23]

        SessionHistoryTBL

[pic 24]

3.2 Wireframe

This is the workplace of the system where the employee can Select any unrented terminal and add session. The employee can also and any session anytime.

...