Harish Project
Harish Project
Harish Project
Introduction 1
System Design 16
4.1 Input Design 17
4.2 Output Design 18
4.
4.3 Table Design 19
4.4 Data base design 22
4.5 Data flow diagram 23
5. System Testing 26
6. System Implementation 28
7. Conclusion 30
Appendix
Screens
Biblography
Reports
1
INTRODUCTION
1.1COMPANY PROFILE
2
CNS Software Solutions is one of the upcoming Software Developing Company in India. CNS mainly
indulges in Software Development which includes mainly 3 major application heads. They are
Windows applications, Itb applications, and Biometric applications. These include various itll known
and commonly used application software's like .net, J2EE, Java, PHP, Dreamitaver, Adobe, Coral
Designer, 3D Max, and Flash which helps in making the Software development process more efficient.
CNS constitutes various departments. These departments handle the various functions of the centre.
The various departments are: Programming department, Designing department, Marketing department,
Projects department and Training department. CNS also deals with handling Customized Projects.
These projects consider the opinions from the customers and are designed according to their views.
This includes 2 categories. They are: Itb and Windows designed projects.
CNS software solutions, established in the year 2007, are one of the leading software development
companies in Coimbatore in IT industry. It is an exclusive offshore software development centre
addressed to meet the I.T needs in India, the Middle East and the Asia Pacific region..
The Software Division specializes in System Level, Network Communication and Internet
programming applications especially itb applications with extensive usage of multimedia tools for
better user interactions and effectiveness of conveying concepts and ideas.
As it look ahead to what the fast approaching future will bring to us and demand from us, it look to
strengthen the foundations of the organization today. It have attracted additional expert talent to support
it core competencies, and focused it marketing strategy.
1.2PROJECT PROFILE
3
This is Visual-Basic Projects on Cyber Cafe Management System, which provided a lot of facility
to their user.
The objective and scope of my Project Cyber Cafe Management System is to record the details various
activities of user. It will simplifies the task and reduce the paper work. During implementation every
user will be given appropriate training to suit their specific needs. Specific support will also be
provided at key points within the academic calendar. Training will be provided on a timely basis, and
you will be trained as the new is Cyber Cafe Management System rolled out to the area of
responsibility.
The moment we are in the very early stages, so it is difficult to put a specific time on the training, but
we will keep people informed as plans are developed.The system is very user friendly and it is
anticipated that functions of the system will be easily accessed by administrators, academics, students
and applicants.
MODULES
CABIN DETAILS
This form will help admin to update new Cabin details to list. When new system is updated to caf
this module is used. These details will also update to Cabin records table.
USER DETAILS
This module is used to add new member to the list by entering member id , name, personal details,
like address, phone number, date of joining and validity related information.
BROWSE RATE DETAILS
Using this module admin can look after hours consumed by users from last date to current date.
This will help admin to analyze amount of consumption for each user.
ITEM DETAILS
Each computer used in cyber caf is given number which will be updated to this table with machine
number, machine name, current status. When cabin is fixed to user current status is selected and
under machine name ( com1 , com 2, ..etc ) is given. This details are updated using a machine
records form.
4
SYSTEM ENVIRONMENT
5
Processor : Intel I3 1.9 GHZ
Clock speed : 500 MHZ
System bus : 32 bits
RAM : 4GB of RAM
HDD : 500 GB
Monitor : ACER
Keyboard : 108 keys
Mouse : 2 button mouse
6
SOFTWARE USED
To develop any system along with the back-end tools which provide access to
the database and also solves the database queries like oracle, to make a system interactive with the user
the use of front-end tools comes into the picture. The front-end tools make the user interface with the
system easier and also provide a user-friendly environment to the system.
This rich language enables you to develop many different types of applications.
You can create you can create programs that intersect with the hardware.
It is a programming language used to create window base application. Visual
Basic is an old BASIC (Beginners All-purpose Symbolic instruction code) language. It makes it very
easy to get the user interface portion of yit application up and running.
Microsoft Visual Basic 6.0 is one of the front-end tool provided by Microsoft
Inc. Microsoft Visual Basic 6.0 provides a fast way to develop applications for Microsoft Windows. As
a front-end tool Microsoft Visual Basic 6.0 provides the G.U.I interface to the user and it is supposed to
be one of the beast front-end tools used today.
7
Some of the main features of Visual Basic 6.0 are listed below :
Data Access features allows you to create database and front-end applications for most
popular database formats, including Microsoft SQL Server, Oracle, Microsoft Access and
other enterprise level database.
Active X technology allows you to use the functionality provided by other application such
as MS Word, MS Excel and other Windows applications. You can even automate
applications and professional or enterprise editions of Visual Basic.
Internet capabilities make it easy to provide access to documents and applications across
the internet from within yit application.
It provides a vital link to graphical environment and allows you to develop applications
based on standard Windows features : Dialog Boxes, Command buttons, Pull down menus,
Scroll bars, Selection lists etc. It also allows creating robust applications that fully make
use of the graphical user interface.
A multitude of wizards and other graphical tools aid developers new to Visual Basic.
Visual Basic allows you to adopt more of parallel approach, with independent sections of
code for each option that the user may select. This is known as Event driven programming
language.
8
By connecting it with Oracle, SQL statements can be run and terminated through Visual
Basic 6.0.
The language is very easy and it provides a very user friendly environment while
programming in Visual Basic 6.0.
Allows for the creation of p-code and native code EXE files. p-code is a tokenized from of
yit sit ce code that will be broken down at runtime into machine code, which is why Visual
Basic will create this intermediately forms.
Can be extended easily through the use of windows API calls, hundreds of third party
controls and DLLs, and integration with other windows applications through COM and
DCOM.
Has a shorter learning curve and development time than C/C++, Delphi, and even Power
Builder.
Used by most of the office suite tool as macro language. With the rest to follow. Other
companies as well are starting to support VBA in their products, such as AutoCAD, Vision,
CorelDraw, SAP, and many others.
Allows for rapid application development and is excellent for business applications.
Has an excellent integrated help facility and book online as well as it includes good
debugging facilities and have many wizards that help automated repetitive tasks.
Allows for the creation of COM components such as Active X controls, DLLs, and Execs.
Can integrate with the Internet on both the server side and the client side.
9
Can run server either on the same machine or remotely on another computer. This allow for
true distributed processing.
Visual Basic is very useful in designing and developing, effective and efficient windows based
programs
VB helps in making yit program look quite effective and beautiful.
You can add menus, tool bars, status bars, text boxes, etc. to blank window.
It is less time consuming and more user friendly. Also user friendly programs can be developed
very easily.
MS ACCESS
Microsoft Access is an information management tool that helps you store information for reference,
reporting, and analysis. Microsoft Access helps you analyze large amounts of information, and manage
related data more efficiently than Microsoft Excel or other spreadsheet applications. This article shows
you when to use Access, and how it can help make you more effective.
Database is needed in each office. So, you've to maintain database also as you possibly can. However,
controlling database isn't easy. That is why occasionally there occur errors or other issues. Obviously,
the issues will probably be a disadvantage for the office. So, you'll need software program that may
help you to resolve the common problems in relation to database. In this case, Microsoft Access may be
the answer. It comes with various versions while the latest version is 2016 version
The back end is used to store the datas on the database table.in the back end databases can be created
and its links to the front end using several types of database connectivity options such as DAO,ADO
etc.
The tables are required to store data. During the intial development phase data can be stored in the
access database and during the implementation phase depending on the volume data can use a higher-
end database.
10
ADVATAGES OF MS ACCESS
Microsoft access is a powerful database software application for a small business and
individuals.access allows for prototyping database and easily allows for creation of tables,the storage of
data and ability to run quries and reports.
PROTOTYPE
Prototyping a database application works well with access.access allows the ability to create modles
based on the variety of business scenarious.creating tables and a product tracking database for a
company can be easily created
NEW USER
Users who are new to creating database can get a jump start with access templates and the access to
more templates on microsofts website.new users will find the wizard helpful in creating tables,queries
and reports
QUERIES
Access has a ability for the users to write queries and handles SQL syntax well.Access is powered by
VB a programming language allowing for marcos and scripts.queries can be reused to create reports
11
12
SYSTEM STUDY
13
3.SYSTEM STUDY
3.1EXISTING SYSTEM
Existing system is keeping records in manual books and also keeping all the records in Microsoft
office package such as Lotus,Word and Excel. The existing system requires more computational time,
more manual calculations, and the complexity involved in Selection of features is high.System which is
followed at present is using MS EXCEL .The system consist of database that has to be maintained with
version information. The report generation and printing work are difficult.In the existing system each
and every time a reference should be made.There are high possibilities to commit errors and
mistakes,which leads to produce a wrong statement to the management.Report keeping is also not an
easy work. Here in the Cafe managment system, a detailed study of existing system is carried along
with all the steps in system analysis.
Here in the Cafe managment system, a detailed study of existing system is carried along with all
the steps in system analysis. An idea for creating a better project was carried and the next steps itre
folloitd.
To avoid all these limitations and make the working more accurately the system needs to be
computerized.
14
3.2 PROPOSED SYSTEM
The aim of proposed system is to develop a system of improved facilities. The
proposed system can overcome all the limitations of the existing system. The system provides proper
security and reduces the manual work. The existing system has several disadvantages and many more
difficulties to work till. The VISUAL BASIC tries to eliminate or reduce these difficulties up to some
extent. The proposed system will help the user to reduce the workload and mental conflict. The
proposed system helps the user to work user friendly and he can easily do his jobs without time
lagging.
The system is very simple in design and to implement. The system requires very
low system resit ces and the system will work in almost all configurations. It has got following features
15
SYSTEM DESIGN
4. SYSTEM DESIGN
4.1 INPUT DESIGN
16
Input Design deals with what data should be given as input, how the data should be
arranged or code, the dialog to guide the operating personnel in providing input,
methods for preparing input validations and steps to follow when error occur. Input
Design is the process of converting a user-oriented description of the input into a
computer-based system. This design is important to avoid errors in the data input
process and show the correct direction to the management for getting correct
information from the computerized system. It is achieved by creating user-friendly
screens for the data entry to handle large volume of data. The goal of designing input is
to make data entry easier and to be free from errors. The data entry screen is designed in
such a way that all the data manipulates can be performed. It also provides record
viewing facilities.
When the data is entered it will check for its validity. Data can be entered with the help
of screens. Appropriate messages are provided as when needed so that the user will not
be in maize of instant. Thus the objective of input design is to create an input layout that
is easy to follow.
In this project, the input design consists of a log in screen, tab for compression/
decompression, sit ce and destination browsing button, a menu list for selecting the
algorithm, Compress/Decompress option, compress/decompress button.
17
A quality output is one, which meets the requirements of the end user and presents the
information clearly. The objective of output design is to convey information about past
activities, current status or projections of the future, signal important events,
opportunities, problems, or warnings, trigger an action, confirm an action etc. Efficient,
intelligible output design should improve the systems relationship with the user and
helps in decisions making. In output design the emphasis is on displaying the output on
a CRT screen in a predefined format. The primary consideration in design of output is
the information requirement and objectives of the end users. The major formation of the
output is to convey the information and so its layout and design need a careful
consideration.
There is an output display screen for showing the compressed/ decompressed file or
folder details (Original file size, Compressed/Decompressed file size, distinct
characters)
4.3TABLEDESIGN
18
Machine details
MachineDetails
Machi Process Mother Cas Mon Sound Agp KeyB Mo Cdrom Floppy Spe Amo
Ram
neNo or board ing itor Card Card oard use Drive Drive aker unt
Machine records
MachineRecords
MachineNo MachineName CurrentStatus
1 PC-1 No
2 PC-2 No
3 PC-3 No
4 PC-4 No
5 PC-5 No
6 PC-6 No
7 PC-7 No
8 PC-8 No
9 pc-9 No
RATE SETTING
RateSetting
19
RateSetting
USERS
Users
UserName UserId Password CreationDate
administrator admin a 4/17/2017
20
Users
UserName UserId Password CreationDate
Jaiju cms 1234 3/1/2017
Mona babu babu 12/31/2016
nahid nahid nahid 1/4/2015
4.4DATABASE DESIGN
A database is an organized mechanism that has the capability of storing information
through which a user can retrieve stored information in an effective and efficient
manner. The data is the purpose of any database and must be protected.
21
The database design is a two level process. In the first step, user requirements are
gathered together and a database is designed which will meet these requirements as
clearly as possible. This step is called Information Level Design and it is taken
independent of any individual Database Management System (DBMS).
In the second step, this Information level design is transferred into a design for the
specific DBMS that will be used to implement the system in question. This step is called
Physical Level Design, concerned with the characteristics of the specific DBMS that
will be used. A database design runs parallel with the system design. The organization of
the data in the database is aimed to achieve the following two major objectives.
Data Integrity
Data independence
22
input data to the system, various processing carried out on these data, and the output
generated by the system. It was introduced by De Macro (1978), Gane and Sarson
(1979).The primitive symbols used for constructing DFDs are:
Symbols used in DFD
A circle represents a process.
Context Diagram
23
A database is an organized mechanism that has the capability of storing information
through which a user can retrieve stored information in an effective and efficient
manner. The data is the purpose of any database and must be protected.
The database design is a two level process. In the first step, user requirements are
gathered together and a database is designed which will meet these requirements as
clearly as possible. This step is called Information Level Design and it is taken
independent of any individual Database Management System (DBMS).
In the second step, this Information level design is transferred into a design for the
specific DBMS that will be used to implement the system in question. This step is called
Physical Level Design, concerned with the characteristics of the specific DBMS that
will be used. A database design runs parallel with the system design. The organization of
the data in the database is aimed to achieve the following two major objectives.
Data Integrity
Data independence
5.SYSTEM TESTING
Testing is a process of executing a program with the interest of finding an error. A good test is
one that has high probability of finding the yet undiscovered error. Testing should
24
SYSTEM TESTING
5.SYSTEM TESTING
25
1. A software configuration that includes a software requirement specification,
a design specification and sit ce code.
2. A software configuration that includes a test plan and procedure, any testing
tool and test cases and their expected results.
Testing is divided into several distinct operations:
1. Unit Testing
Unit test comprises of a set tests performed by an individual program prior to the
integration of the unit into large system. A program unit is usually the smallest free
functioning part of the whole system. Module unit testing should be as exhaustive as
possible to ensure that each representation handled by each module has been tested. All
the units that makeup the system must be tested independently to ensure that they work
as required.
During unit testing some errors itre raised and all of them itre rectified and
handled itll. The result was quiet satisfactory and it worked itll.
2. Integration Testing
Integration testing is a system technique for constructing the program structure
while at the same time conducting tests to uncover errors associated with interfacing.
The objective is to take unit tested modules and build a program structure that has been
dictated by design. Bottom-up integration is the traditional strategy used to integrate the
components of a software system into functioning whole. Bottom-up integration consists
of unit test folloitd by testing of the entire system. A sub-system consists of several
modules that communicated with other defined interface.
The system was done the integration testing. All the modules itre tested for their
compatibility with other modules .They test was almost successful. All the modules
coexisted very itll, with almost no bugs. All the modules itre encapsulated very itll so as
to not hamper the execution of other modules.
3. Validation Testing
After validation testing, software is completely assembled as a package,
interfacing errors that have been uncovered and corrected and the final series of
software test; the validation test begins. Steps taken during software design and testing
26
can greatly improve the probability of successful integration in the larger system.
System testing is actually a series of different tests whose primary purpose is to fully
exercise the compute based system.
4. Recovery Testing
It is a system that forces the software to fail in a variety of ways and verifies that
the recovery is properly performed.
5. Security Testing
It attempts to verify that protection mechanisms built into a system will in fact
protect it from improper penetration. The systems security must of cit se be tested from
in vulnerability form frontal attack.
6. Stress Testing
Stress tools are designed to confront programs with abnormal situations. Stress
testing executes a system in a manner that demands resit ces in abnormal quantity and
volume.
7. Black Box Testing
Black box testing is done to find out the following information as shown in
below:
1. Incorrect or missing functions.
2. Interface errors.
3. Errors or database access.
4. Performance error.
5. Termination error.
The mentioned testing is carried out successfully for this application according
to the users requirement specification.
8. Test Data Output
After preparing test data, the system under study is tested using the test data.
While testing the system using test data, errors are again uncovered and corrected by
using above testing and corrections are also noted for future use.
27
SYSTEM
IMPLEMENTATION
6.SYSTEM IMPLEMENTATION
28
This project which aims at automating the insurance records needs to be implemented in
a way that is error free and totally efficient. Implementation is the stage ,which is very
important in the lifecycle of the new system designed. Implementation means converting
a new or revised system design into an operational one. This is the final stage of the
project where the theoretical design is turned into the working design.
The system implementation, the requirements of the user may change in the
future. Hence the software is designed and developed flexibly .So that it can designed in
future
29
CONCLUSION
7. CONCLUSION
The project Cafe Managements completed, satisfying the required design specifications. The system
provides a user-friendly interface. The software is developed with modular approach. All modules in
30
the system have been tested with valid data and invalid data and everything work successfully. Thus the
system has fulfilled all the objectives identified and is able to replace the existing system. The
constraints are met and overcome successfully. It may help collecting perfect management in details. In
a very short time, the collection will be obvious, simple and sensible. It will help a person to know the
management of passed year perfectly and vividly. It also helps in current all works relative to College.
It will be also reduced the cost of collecting the management & collection procedure will go on
smoothly.
BIBLIOGRAPHY
BOOKS:
31
1. Charles Hampfed (2000) Visual Basic University of
Toronto
2. Herbert Schildt (2000) Visual Basic 6.0 Tata McGraw Hill
3. John Zukowski (2000) Visual Basic 6.0 BPB Publications
4. Jamie Jaworsky Visual Basic 6.0Techmedia
5. StefenDenninger Visual Basic 6.0Authors Press
6. Ian Somerville Software engineering
7. Rajeev mall Software engineering
8. ElmasriNavathe Fundamentals of database systems
APPENDIX
32
LOGIN
33
USER ID CREATING
34
TRASACTION
35
BILLING
36
TOTAL USERS
37
38