CYBER CAFE MANAGEMENT SYSTEM PROJECT REPORT

CYBER CAFE MANAGEMENT SYSTEM PROJECT REPORT

PROJECT REPORT

CYBER CAFE MANAGEMENT SYSTEM PROJECT REPORT

PROJECT SOURCE CODE

CYBER CAFE MANAGEMENT SYSTEM PROJECT REPORT  WITH JAVA SOURCE CODE

FREE DOWNLOAD ALL THE PROJECT REPORTS WITH SOURCE CODE FROM HERE

INDEX

1. Introduction

2. Problem Definition

3. Requirement analysis

4. Existing system

5. Proposed system

6. System analysis

Definition of Feasibility study

Types of Feasibility study

7. Scope of the system

8. Structured analysis

Entity Relationship Diagram

Use Case Diagram

Class Diagram

Sequence Diagram

Activity Diagram

Collaboration Diagram

9. Database Design

10. Implementation and Testing

Test Cases

11. Sample Screen

12. Limitations & Future Enhancement of the system

13. Bibliography

INTRODUCTION - CYBER CAFE MANAGEMENT SYSTEM PROJECT

The software is the solution for an Internet cafe. The software provides you with a means to control the workstations, manage customer database, sell products and generate detailed reports and statistics.

This is a powerful Cyber Cafe management software that helps with managing customers and employees, controlling computers and printers, securing systems, accounting and billing. It simplifies and automates running your Internet Cafe business. Unlike many other competitive programs, Cyber cafe management system is robust, quick, secure and very intuitive and easy to use. It doesn't matter how big your Internet cafe is - Cyber cafe management system is capable of controlling any number of workstations. Cyber cafe management system is designed to be a complete solution for Internet cafes and to make life easier for Internet cafe owners, operators and customers.

The basic task of our software is to provide operators and customers with an accurate timing and billing information at any time. Cyber cafe management system keeps customer accounts, so that customers can log in on their own using username and password, printed account ticket with a time code or even a magnetic card. It is possible to set any pricing you might imagine including periodic discounts on specific days or times, traffic and group discounts, time bonuses or points system. The software keeps inventory of products and services and supports POS devices such as receipt printers. Other important features include reservations, print control, remote screen and instant recovery of disk partitions. The software generates various statistics, which give detailed information about business performance. All transactions and actions are recorded into a database and can be viewed through multiple reports.

PROBLEM DEFINITION - CYBER CAFE MANAGEMENT SYSTEM PROJECT

In existing system a lot of manual work has to be carried out. Large amount of paper work is involved which may cause high degree of error.

Registration of user names, keeping records of user are done manually, which is time-consuming process and there is possibility of making errors. Administrator has to keep the track of time, which is tedious job. Once the user logs out, while preparing bill, he has referred to user details including name, login time and time allocated leading to possibility of causing errors in bill calculation. This may be unbeneficial to administrator. Hence also there is not accuracy in bill calculation.

Also a lot of files, records are required to store these documents thus making it difficult to maintain.
Since all these reports are prepared manually, we require computer software for all these purposes.

REQUIREMENT ANALYSIS - CYBER CAFE MANAGEMENT SYSTEM PROJECT

Every user interacts with system with some needs and requirements such as:

1. Get data or information immediately.

2. Comprehensive information accessing and retrieving data to provide valuable reports.

3. Better utilization of time and manpower.

4. User should have basic knowledge of computer.

5. Every user must know the function of each master entry, transaction entry and reports.

6. User should know the format of database.

User must know the contents of main menu tool

SYSTEM REQUIREMENTS - CYBER CAFE MANAGEMENT SYSTEM PROJECT

CAFE STATION  (SERVER)

          

Software Configuration:

Operating System     : Windows XP

Designing Tool             :      Microsoft Visual Studio 2005

Programming Language   :Visual C sharp

Backend                         :              SQL server 2005

Network

:IP based Network

                       

Hardware Configuration:

 Processor    :           P 4 700 GHz.

 RAM           :  256MB RAM

 Hard Disk Drive     :           40 GB HDD

 Keyboard     :           104 keys

 Mouse          :           Logitech Mouse

 Monitor       :           15” digital color monitor

 Display Type           :           VGA

CAFÉ AGENT(CLIENT SOFTWARE)

Software Configuration:

Operating System : Windows XP

Designing Tool             :      Microsoft Visual Studio 2005

Programming language  :Visual C sharp

Backend                  :         SQL server 2005

Hardware Configuration:

 Processor    :           P 4 700 GHz.

 RAM           :  256MB RAM

 Hard Disk Drive     :           40 GB HDD

 Keyboard     :           104 keys

 Mouse          :           Logitech Mouse

 Monitor       :           15” digital color monitor

 Display Type           :           VGA

EXISTING SYSTEM - CYBER CAFE MANAGEMENT SYSTEM PROJECT

In the form Cyber Café Managements System is manual system. In manual system administrator has to keep the track of many tasks such as keeping track of time, which is the tedious job. Once the user logs out, while preparing bill he has to refer user details including name, login time and logout time and time allocated leads to the possibility of causing errors in bill calculations. This may be beneficial to administrator. Hence also there is not accuracy in bill calculations.
CLINK- It is a software widely used in our neighborhood, developed by private programmers for Cyber Cell of our police department. The software connects each user of any cafe with an online database which is controlled by the server of cyber cell. It records the browsing history and the account details of every user who login and surf. Once a user login he is provided with an ID and password which can be used again. The security features are well maintained but it cannot satisfy every customer needs. The billing is based on the net time usage by the local server of the cafe. The existing versions of clink cannot prepare the bill based on the data usage. The billing system is not concerned with the data usage of each user.
One of the major drawback is the desktop background is recently replaced by the online advertisements. Other disadvantages are, it cannot be used to control gaming cafes and gaming workstations. It gives no print details and CD burning details.

No Reservation can be made by users but it gives debits for recent users.
Unused workstations cannot be securely locked so that no one can use them without proper authorization from the operator

PROPOSED SOFTWARE -CYBER CAFE MANAGEMENT SYSTEM PROJECT

The package consists of two applications:

CafeStation

A main program installed at the operator desk. It is used by operators to control all connected client workstations.

CafeAgent

Installed on all client workstations - it secures and locks the system, offers possibility to log in and out and shows session information.

FEATURES

Security

Cyber cafe management system provides many levels of security, ensuring that your business is always under control.

Workstation lock

Unused workstations can be securely locked so that no one can use them without proper authorization from the operator.

Operator profiles

You can create many profiles for your employees with different access rights. Not every one should be able to change crucial options or pricing schemes — Cyber cafe management system makes it possible.

Encrypted data files

All databases used by Cyber cafe management system are encrypted which ensures they can't be tampered with by unauthorized individuals.

Backups

It's possible to create backups of data files automatically every given period of time. Your data will be secure even when your system crashes.

Ease of use

Although our software has many advanced features it's still very easy to use, both for operators and customers. The user interface is clean and feels very natural even to beginners. The integrated help system will guide you in case of any problems.

Customer accounts

Cyber cafe management system makes it really easy to manage large database of customer accounts. You can create different types of accounts for your customers — time accounts, cash accounts, debt accounts and unlimited accounts. You can assign beneficial charging rates to customer accounts to reward devoted customers. Customers will be able to log on by themselves using their account ID and password.

Reservations

Cyber cafe management system provides unique graphical workstation reservation system. Simply select a time period on the workstation chart to create the reservation.
In case of a very big traffic, you'll appreciate the Waiting queue function, allowing you to manage the waiting list.

Reports and statistics

Our software provides you with a range of reports and statistics summarizing your business performance. Starting with very general reports, you can even get a list of all operations performed by your employees minute by minute.

Flexible charging rates

Real strength of Cyber cafe management system lies in the flexible charging rates system. You can configure many schemes of pricing, including periodical discounts.

Support for external devices

We can use scanner to logon users with accounts and sell products. Cyber cafe management system also supports receipt printers for printing receipts and account tickets.

Print control

Cyber cafe management system monitors printers on the main PC and on client workstations. Printouts can be confirmed by customers as well as by operators before they are sent to printer. It is possible to specify different prices based on printer, page count and format. All charges are saved in print reports.

Easy on resources

Even though Cyber cafe management system is feature packed as no other software package, it's very easy on your system resources. Thanks to efficient programming schemes and great design it runs without problems even on older hardware..

FEASIBILITY STUDY - CYBER CAFE MANAGEMENT SYSTEM PROJECT

The preliminary investigation is carried out before the analysis in which the Feasibility study is carried out. An important outcome of preliminary investigation is the determination that the system requested is feasible or not. Feasibility study is undertaken to determine either possibility of improving the existing system or developing a new system.

Preliminary investigation is an important part of the system analysis. Before starting any system we have to determine whether the system is feasible or not. This study is known as the Feasibility study.

Types of feasibility study:

                        1. Technical Feasibility Study.

                        2. Economical Feasibility Study.

                        3. Operational Feasibility Study.

1. Technical  Feasibility  Study :

      

It includes the study like can work for project be done with current equipment , existing software technology and with available manpower?

For proposed system technical hardware requirements are --

Processor : Pentium
Memory : Minimum 32 MB RAM

Software Requirements:

1) Front end – Core Java and advance Java

2) Back end - Microsoft Access

3) Platform - Windows XP or 98

2.  Economical  Feasibility :

The cyber cafe can easily afford software and hardware , since they are not expensive . Manual errors are minimized due to user friendliness of proposed system . Cyber cafe will not have to spend money on recruitment of highly skilled personnel in order to operate it.
Few days or hours of training to existing personnel is sufficient , since processing system was designed keeping in mind the common person with limited technical knowledge.

Hence, the proposed system is technically feasible.

3. Operational Feasibility:   

Will the system be used if it developed and implemented?
Will there be resistance from the user to the new system.
The system will provide timely information and status of the various activities to manage, to facilitate the user of the system.
Smooth and user friendly operation of the system was main aim for spending up work in progress.

Following are some good qualities of system:

1. Master information is entered only once.

2. data processing is facilitated.

3. Faster processing of data to give structured reports. Hence, the proposed system is operationally feasible to cafe.

SCOPE OF THE SYSTEM - CYBER CAFE MANAGEMENT SYSTEM PROJECT 

As this is automated cyber management system it makes it very easy for administrator to search details. Also it time allotment is done very efficiently and it provides fast service in term of the bill calculation and time management.

Which is very advantageous to both administrator and user.

             

Data Directory - CYBER CAFE MANAGEMENT SYSTEM PROJECT

Balance

FIELD  NAME	TYPE	CONSTRAINT
Bid	Number
B date	Text
Aval balance	Text
Tottime	Text
Login time	Text
Logout time	Text

Administretor

FIELD  NAME	TYPE	CONSTRAINT
A_lname	Text
A_Pwd	Text

Member

FIELD  NAME	TYPE	CONSTRAINT
M id	Number
M name	Text
Day	Text
Month	Text
Year	Text
Gender	Text
Addr	Text
Type	Text
Mobile	Text
Email	Text
Day1	Number
Month 1	Number
Year1	Number
Amount	Number
Day 2	Number
Month 2	Number
Year2	Number

Amount

FIELD  NAME	TYPE	CONSTRAINT
Aid	Text
No of print	Text
Pamnt	Text
No of scan	Text
Samnt	Text
Extra  pay	Text
Rembalance	Text

           

Test Plan for CYBER CAFE MANAGEMENT SYSTEM PROJECT

1. General Information

     

1. Summary :

We are testing the application of Sales management System which maintains and helps in day-to-day transaction of Sales Department.

2. Environment and Pre-Test Background :

This application is being tested in SIBAR (MCA Dept) Computer Lab. No prior testing has been done on this application.

3. Test Objective :

                              

·         Authentication and Authorization.

·         Member Details

·         Time Details

·         Balance Details.

·         Bill Details.

·         Report Details.

4. Expected Defects :

     

·         Open Defects

·         Close Defects

·         Known Defects

2. Plan

1. Software Description

Sr. No	Process	Input	Output
1.	Login Details	Customer Information.	Stores in Database Prompt message to user for completion
2.	Member Details	Member Information	Stores in Database Prompt message to user for completion
3.	Time Details	Time Information	Stores in Database Prompt message to user for completion
4.	Balance Details	Balance Time Information	Stores in Database Prompt message to user for completion
5.	Bill Details	Generates Bills	Stores in Database and provide Bill details after completion

Test Team:



Test team will have following members:



1. Tester: Tester will perform the actual testing.

2. Business Expert: Business Experts are those people who have knowledge about the business domain.

3. Test-Team Manager: Test-Team Manager will be monitoring the whole testing process.

4. User: User is the End user who will be actually dealing with the software.

c. Testing:

1. Schedule:

2. Requirement:

1. Computer with Java 1.6.0 and MYSQL Software installed on it.

2. We will require Software requirement Specification document & Vision Document.

3. Specifications & Evaluations:

           a. Specifications:

1. Business Functions:

• · Give Specification: This will help user to give the requirements of his related to project online.
• · Member Details: This will help the Organization to keep information of his member and will provide facilities to access it.
• · Time Generation: This will provide functions for generating Timing of customer who has given allotted.
• · Report Generation: This will generate various reports demanded by the member usage and growth of company.

2. Structural Functions:

Give Specifications:

User will have to register for that Application form will be provided.
After Registration, User will have Member ID and Password.
System will be Allot time for the member for the usage.
· Usage Details:
If user is a staff member of organization then he will be able to view details.
If user is Admin then we will provide him facilities to Add, Edit as well as Delete Details.

3. Customer Information:

If user is a member of organization then he will be able to add Customer details as well as can view details.
If user is a manager of Organization then we will provide him facilities to Add, Edit as well as Delete Customer Details.
For viewing information of particular Customer, we are providing search option.

4. Bill Generation:

User will be provided with two tabs by clicking which he can generate Invoices.
User will be provided with interface where either he can give customer name or customer id for generating bill.

5. Report Generation:

User will be provided with list of Reports using which he can generate report by clicking on those options
User will be provided interface where he need to give dates of which report has to be enervated.


According to the Report, user will need to give details on basis of that detail report will be generated.

 4. Functional Requirement:

Sr. No	Functions	Test
1.	Give Specification	Usability Correctness Reliability Security Performance Maintainability Visibility
2.	Member Details	Maintainability Correctness Security Usability Visibility
3.	Timing Details	Maintainability Correctness Usability Visibility
4.	Balance Details	Maintainability Correctness Security Usability Visibility
5.	Report Generation	Security Reliability Correctness Understandability Visibility
6.	Bill Generation	Security Reliability Correctness Understandability Visibility

     

                                         

                                   

                       

5. Evaluation:

Sr. No	Objectives	Priorities	Completeness Criteria
1.	Adding Data	High	System should Add data into the database. It should also prompt acknowledgement to the user.
2.	Updating data	High	System should update the old data with new updated data. System should check the authentication of user and then make changes to the database. It should prompt message to the user about updating.
3.	Deleting data	High	System should Remove the data demanded by the user from the database. It should check the authentication of the user before deleting the record. It should also confirm that a message is prompted to user about deletion confirmation.
4.	Searching data	High	System should retrieve data from database when search option has been clicked. If data is not found relevant to user demand, a message should be displayed to the user about data not present.
5.	Report Generation	High	After selecting particular report, Data related to that report should be properly retrieved from the database in proper format.
6.	Invoice Generation	High	System should retrieve data of only that customer whose id or name is mentioned by the user.

 3. Test Cases: - CYBER CAFE MANAGEMENT SYSTEM PROJECT

3.1 Test Case for Customer Registration

ABSTRACT

Library of test cases is the document having Common test cases for major objects in an application. New objects test cases can be added to it to maintain the library in efficient manner. Since these are the common test cases for objects, Quality Assurance Engineers who involved in writing test cases for your project edit these based on the project requirements.

CONTENTS

1. User ID

2. Password

3. User Name

4. Customer Address

5. Mobile Number

6. Date

7. Email Address

Sr.No	Test case Id	Object	Test Description	Execution Steps	Expected Behavior
01	User Name	Text box	Checking the functionality “User Name” text box.	Entering the value as "12345" and clicking on the "Save" Push button Entering the value as "/*--+-" and clicking on the "Register" Push button Entering the value as "12354/*--+-" and clicking on the "Login" button Entering the value as Null Characters and clicking on the "Login" button Entering the value as    "   " blank space and clicking on the "Login" button	Should show the popup error message "Invalid entry.  Name accepts only characters". After clicking the Login button in the message the cursor should focus on the textbox. Should show the popup error message "Invalid entry.  Name accepts only characters". After clicking the Login button in the message the cursor should focus on the textbox. Should show the popup error message "Invalid Login. Name accepts only characters". After clicking the ok button in the message the cursor should focus on the textbox. Should show the popup error message "Please enter User Name". After clicking the Login button in the message the cursor should focus on the textbox.       5.  Should show the popup error message "Invalid Login. Name accepts only characters". After clicking the Login button in the message the cursor should focus on the textbox.
02	Customer Address	Textbox	Checking the functionality of the Customer Address text box.	Entering the value as "12345" and clicking on the "Save" Push button. Entering the value as "/*--+-" and clicking on the "Save" Push button Entering the value as "12354/*--+-" and clicking on the "Save" Push button Entering the value   as Null Characters and clicking on the "Save" Push button Entering the value as    "   " blank space and clicking on the "Save" Push button Entering the value as "a to z" and clicking on the "Save" Save button	Should show the popup error message "Invalid entry. Address accepts only characters". After clicking the ok button in the message the cursor should focus on the textbox. Should show the popup error message "Invalid entry. Address accepts only characters". After clicking the ok button in the message the cursor should focus on the       textbox. Should show the popup error message "Invalid entry. Address accepts only characters". After clicking the ok button in the message the cursor should focus on the textbox. Should show the popup error message "Please enter Address". After clicking the ok button in the message the cursor should focus on the textbox. Should show the popup error message "Invalid entry. Address accepts only characters". After clicking the ok button in the message the cursor should focus on the textbox. Should accept the value and show the pop up message as “Enter City of Customer”.
03	Gender	Combo box	Checking the functionality of the "Gender" Combo box.	Entering the value as "Male/Female" and clicking on the "Save" Push button. Entering the value as    "   " blank space and clicking on the "Save" Push button Entering the value as    Null Characters and clicking on the "Save" Push button	Should accept the value and show the pop up message as "Please enter Pin-Code". After clicking the Save button in the message the cursor should focus on the "Male/Female" textbox. Should accept the value and show the pop up message as "Please enter Value". After clicking the save button in the message the cursor should focus on the "Pin-Code" textbox. Should not accept the value and show the popup error message that "Enter Value should not be blank". After clicking the ok button in the message the cursor should focus on the textbox. Should accept the value and show the pop up message as "Please enter Pin-Code". After clicking the ok button in the message the cursor should focus on the "Pin-Code" textbox.
04.	Date Of Birth	Combo box	Checking the functionality of the "DOB" Combo Box Which accepts Characters and Numbers.	Entering the value as "abcd" and clicking on the "Save" Push button. 2. Entering the value as "/*--+-" and clicking on the "Save" Push button 3. Entering the value as    "   " blank space and clicking on the "Save" Push button 4. Entering the value as    Null Characters and clicking on the "Save" Push button 5. Entering the value as "0 to 9" and clicking on the "Save"  Push button	1. Should accept the value and show the pop up message as "Please enter Date.". After clicking the ok button in the message the cursor should focus on the "Dateof birth" Combo Box. 2. Should Not accept the value and show the pop up message as "Please enter Pin-Code". After clicking the ok button in the message the cursor should focus on the "Pin-Code Combo Box. 3. Should not accept the value and show the popup error message that "Enter Specific date should not be blank". After clicking the ok button in the message the cursor should focus on the Combo Box 4. Should show the popup error message "Please enter the Contact". After clicking the ok button in the message the cursor should focus on the Combo Box 5. Should accept the value and show the pop up message as "Please enter Date of birth.". After clicking the ok button in the message the cursor should focus on the "Date Of Birth." Combo Box
05	Email	Textbox	Checking the functionality of the "Email" Textbox	Entering the valid email address with " @ and ." and clicking on  the "Save" Push button Entering the invalid email address without " @ and ." and clicking on the "Save" Push button Entering the value as Null and clicking on the "Save" Push button	Should accept the Email address and should show a message as "Personal profile Updated successfully" Should show a pop up error message that "Invalid entry. Enter a valid Email address". After clicking the ok button in the message the cursor should focus on the textbox. Should show the popup error message "Please enter the Email address". After clicking the ok button in the message the cursor should focus on the textbox.
06	Mobile No	Text box	Chcking the functionality of the Mobile No Txtboxes should accept only numeric "0 to 9"	Entering the value as "abcd" and clicking on the ""Save" Push button Entering the value as "/*--+-" and clicking on the "Save" Push button Entering the value as "abcd/*--+-" and clicking on the "Save" Push button Entering the value as    "   " blank space and clicking on the "Save" Push button Entering the value as "0 to 9" and clicking on the "Save" Push button	Should show the popup error message "Invalid entry. Phone no accepts only numeric value". After clicking the ok button in the message the cursor should focus on the textbox. Should show the popup error  message "Invalid entry. Phone no accepts only numeric value". After clicking the ok button in the message the cursor should focus on the textbox. Should show the popup error message "Invalid entry. Phone no accepts only numeric value". After clicking the ok button in the message the cursor should focus on the textbox. Should show the popup error message "Invalid entry. Phone no accepts only numeric value". After clicking the ok button in the message the cursor should focus on the textbox. Should accept the value and should show a message as "Personal profile Updated successfully"

LIMITATIONS AND FUTURE  ENHANCEMENTS OF CYBER CAFE MANAGEMENT SYSTEM PROJECT

LIMITATIONS :

   The  most  important  limitation  of  the  existing  system  is ,  it  is  Manual  system.

Drawbacks of Manual System:

·        Time required for validation and updating is more.

·        Accuracy is less and incomplete.

·        Searching is difficult.

·        Repetition of work is going on.

·        Keeping track of cabin status is tedious job.

FUTURE ENHANCEMENTS:

    The computerized  “Cyber Café Management “ is made with intention to make easy to maintain the records and minimize the drawbacks of the system.

Advantages  of  computerized  system over  manual  system  are:

·        Computerized system is completely automated thus user can operate easily.

·        Time required is very less to makes and search the records.

·        Computerized system generates online reports.

·        It reduces the data consistency and redundancy.

·        Computerized system is very helpful to display all records.