OP -AMP DESIGN USING PYXIS
MINI PROJECT 2017-18
PROJECT REPORT
Submitted in partial fulfilment of the requirements for the award of the degree
of
BACHELOR OF TECHNOLOGY
in
ELECTRONICS & COMMUNICATION ENGINEERING
by
kashish chawla Simraan Ahmed Shivam tyagi Navneet kumar
02251202815 03751202815 03351202815 0251202815
Guided by
Dr. Manoj Sharma
DEPARTMENT OF ELECTRICAL & ELECTRONICS ENGINEERING
BHARATI VIDYAPEETH’S COLLEGE OF ENGINEERING
(AFFILIATED TO GURU GOBIND SINGH INDRAPRASTHA UNIVERSITY, DELHI)
NEW DELHI – 110063
APRIL 2018
1
“BUS MANAGEMENT SYSTEM”
WINTER TRAINING 2017-18
PROJECT REPORT
Submitted in partial fulfilment of the requirements for the award of the degree
of
BACHELOR OF TECHNOLOGY
in
ELECTRONICS & COMMUNICATION ENGINEERING
by
Raghav Puri
02951202815
Guided by
Mr. Dheeraj Mittal
DEPARTMENT OF ELECTRONICS & COMMUNICATION ENGINEERING
BHARATI VIDYAPEETH’S COLLEGE OF ENGINEERING
(AFFILIATED TO GURU GOBIND SINGH INDRAPRASTHA UNIVERSITY, DELHI)
NEW DELHI – 110063
APRIL 2018
CANDIDATE’S DECLARATION
It is hereby certified that the work which is being presented in the Mini-Project Report entitled
"BUS MANAGEMENT SYSTEM" in partial fulfilment of the requirements for the award of
the degree of Bachelor of Technology and submitted in the Department of Electronics &
Communication Engineering of Bharati Vidyapeeth’s College Of Engineering, New Delhi
(Affiliated to Guru Gobind Singh Indraprastha University, Delhi) is an authentic record of
our own work carried out during a period from December 2017 to January 2018 under the
guidance of Mr. Dheeraj Mittal, Director, HCL Infosystems Ltd.
The matter presented in the B. Tech Winter Training Report has not been submitted by me for
the award of any other degree of this or any other Institute.
The B. Tech Winter Training: Bus Management System Project of Raghav Puri (Enrollment
No: 02951202815), has been held on December 2017 to January 2018.
Mr. D Sreenivasulu
(Assistant Professor, Department ECE)
ABSTRACT
Objective of this software is to computerize any traveling company to manage
data, so that all the transactions become fast and there should not be any error in
transactions like calculation mistake, bill generation and other things. It replaces
all the paperwork. It keeps records of all the bills also, given to the customers, so
that user could update his daily accounts. almost care and back-up procedures
must be established to ensure 100% successful implementation of the
computerized Bus reservation system.
Traveling is a large growing business in India and other countries also. It
becomes very difficult to keep records for large no. of items, customers and
calculating bills. This project is very useful in the Bus reservation system. I
observed the working of the Bus reservation system and after going through it, I
get to know that there are many operations, which they must do manually. It
takes a lot of time and cause many errors. Due to this, sometimes a lot of
problems occur, and they were facing many disputes with customers. To solve
the above problem, and further maintaining records of items, seat availability for
customers, price of per/seat, bill generation and other things, I am offering this
proposal of Bus Reservation System.
ACKNOWLEDGEMENT
I express my deep gratitude to Mr. Dheeraj Mittal, Director, HCL Infosystems
Ltd. for his valuable guidance and suggestion throughout our project work.
Finally, I would like to express my deep appreciation to my family and friends
who have been a constant source of inspiration. I am eternally grateful to them
for always encouraging me wherever and whenever I needed them.
Sign
(Raghav Puri)
(02951202815)
CERTIFICATE
TABLE OF CONTENTS
CANDIDATE DECLARATION ii
ABSTRACT iii
ACKNOWLEDGEMENT iv
CERTIFICATE v
TABLE OF CONTENTS vi
LIST OF FIGURES vii
Chapter 1: Introduction 1-5
Introduction 1
Motivation 2
Objective 2
Summary 3
6 -9
Chapter 2: Description
System Analysis 6
Study Methodology 6
Software Engineering Paradigm 7
Feasibility Study 8
Functioning Tour 9
Chapter 3: Results and Discussion 10-11
References 12
Appendix A Source code 13
LIST OF FIGURES
Figure 3.1 Screenshot 1:Bus Table
Figure 3.2 Screenshot 2: Passenger Table
Figure 3.3 Screenshot 3: Agent Table
CHAPTER 1: INTRODUCTION
1.1 INTRODUCTION
Traveling is a large growing business in India and other countries also. It
becomes very difficult to keep records for large no. of items, customers and
calculating bills. This project is very useful in the Bus reservation system.
I observed the working of the Bus reservation system and after going through it, I
get to know that there are many operations, which they must do manually. It
takes a lot of time and cause many errors. Due to this, sometimes a lot of
problems occur, and they were facing many disputes with customers. To solve
the above problem, and further maintaining records of items, seat availability for
customers, price of per/seat, bill generation and other things, I am offering this
proposal of Bus Reservation System.
1.2 ABOUT HCL INFOSYSTEMS LTD.:
HCL Infosystems is India’s pioneer IT Services, Solutions & Distribution
Company providing the choice of multi-brand global technology products and the
capability of best-in-class, business-aligned IT services and solutions. Our
offerings portfolio spans IT and System Integration services, value-added
distribution of enterprise technology and consumer mobility products by helping
our clients across industries to attain and sustain competitive business edge we
aim to be Your Technology Lifecycle Partner.
HCL Infosystems is a part of HCL Enterprise. HCL Infosystems started with
producing micro-computing calculators back in 1976. Envisioning IT in Every
Home.
It developed the first indigenous at the same time as and three years before in
1978. This micro–computer virtually gave birth to the Indian computer industry.
HCL's in–depth knowledge of led to the development of a fine grained
multiprocessor Unix in 1988, three years ahead of and Infosystems: Reports,
Company History, Directors Report, Chairman's Speech, Auditors Report of HCL
Infosystems.
The company announced in November 2013 that it will phase-off its
manufacturing business in the next few years to improve margins and increase
organizational efficiency. The company transferred its solutions, services and
learning business to wholly owned subsidiaries - HCL Infotech, HCL Services,
and HCL Learning HCL Infosystems to phase-off manufacturing business.
1.3 MOTIVATION
1. India has population of approximately 135 crores.
2. This makes India second most populated country in the world.
3. More than 60% population of India travels by bus.
4. Thus, it is very important to manage Bus ticketing System.
5. Moreover, our app is also beneficial for all Commercial as well as Public
Buses.
1.4 OBJECTIVE
Objective of this software is to computerize any traveling company to manage
data, so that all the transactions become fast and there should not be any error in
transactions like calculation mistake, bill generation and other things. It replaces
all the paperwork. It keeps records of all the bills also, given to the customers, so
that user could update his daily accounts. almost care and back-up procedures
must be established to ensure 100% successful implementation of the
computerized Bus reservation system.
1.5 SUMMARY
● The backend i.e. Bus Management System was successfully implemented
by PL/SQL.
● Now there is no more need for cropping the document to be precise. It
itself crops the required part like this:
● It reduced much time and human effort for point-to-point photograph.
● Winter Internship from HCL infosystems Ltd. was completed, and I was
asked again to be an Intern with more Backend knowledge.
1.6 AWARDS & ACCOLADES:
1.6.1 SERVICES:
● · IT Service Provider of the Year- Frost & Sullivan
● ·Multi-Vendor Services- Ranked in Champions Quadrant (DQ Customer
Confidence Survey)
● ·Infra Managed Services- Ranked in Champions Quadrant (DQ Customer
Confidence Survey)
1.6.2 FINANCIAL INCLUSION:
● Solution, Development and Access to Banking & Financial Services-
Skoch Award.
● Best Access to Banking & Financial Services- BFSI Leadership Summit
& Award.
1.6.3 LEARNING:
● Quality Excellence Award in Learning Outcomes- World Education
Congress.
● Excellence in Product & Solutions in K-12 segment-India Didactics
Association.
1.6.4 CONSUMER DISTRIBUTION:
● Business Technology Usage and Implementation – DQ LIVE Business
Technology Award.
1.6.5 CONSUMER SERVICES:
● ·Mobility Retailer of the Year- Asian Retail Congress
● ·Mobile & Telecom Services- CMO Asia Retail Excellence Award
1.6.6 HCL QUALITY FUNCTION:
● ·Excellence Awards from World Quality Congress
● ·Quality Excellence Award for Best Customer Service Result- CMO Asia
1.6.7 ACQUISITIONS:
● On 26 July 2012, HCL Infosystems acquired Edurix, an Online Education
Content Provider, with the intent to strengthen its education and learning
business.
1.6.8 INVESTORS:
The Company firmly believes that good corporate governance practices ensure
efficient conduct of the affairs of the Company while upholding the core values
of transparency, integrity, honesty and accountability and help the Company in its
goal to maximize value for all its stakeholders. The Company adopts and adheres
to the best recognized corporate governance practices and continuously strives to
better them. The Company is following the requirements of the guidelines on
corporate governance stipulated in Clause 49 of the Listing Agreement and The
Securities and Exchange Board of India (Listing Obligations and Disclosure
Requirements) Regulations, 2015 with the Stock Exchanges.
CHAPTER 2: DESCRIPTION
2.1 SYSTEM ANALYSIS:
● System analysis and design refers to the process of examining a business
situation with the intent of improving it through better procedures and
methods. System development can generally be thought of as having two
major components: System Analysis and System Design.
2.1.1. IDENTIFICATION OF NEEDS:
● Existing system is totally on book and thus a great amount of manual work
must be done. With the increase of manual work in Bus services and
information needs, automation was necessary.
● Needs a lot of working staff and extra attention on all the records.
● In existing system, there are various problems like keeping records of
items, seat available, prices of per/seat and fixing bill generation on each
bill.
● Finding out the details regarding any information was very difficult, as the
user must go through all the books thoroughly.
● Major problem was the lack of security check that was must to be applied.
2.2.2. STUDY METHODOLOGY:
● System design is the process of planning a new system or replace or
complement an existing system. But before this planning can be done, we
must thoroughly understand the existing system and determine how
computers can best be used to make its operation more effective. To obtain
information about the current system and determine the requirements of the
new system, study of the current system has been carried out.
● System analysis, then, is the process of gathering and interpreting facts,
diagnosing problems and using the information to recommend
improvement to the system. In brief, we can say that analysis specifies
what the system should do. Design specifies how the system should do.
2.2.3. SOFTWARE ENGINEERING PARADIGM:
● To develop a software, software engineer must incorporate a development
strategy that encompasses the processes, methods, tools and generic phases
etc. This strategy is often referred to as a Process Model or Software
Engineering Paradigm.
● A paradigm specifies some activities that should be performed and the
order in which they should be performed. A Software Development
Paradigm is chosen based on the nature of the project and application,
methods and tools to be used and the controls and deliverables that are
required.
2.2.3.i.) Business modeling:
In this phase, all the information about the business functioning of the Restaurant
is collected, how the data and information is flow from one end to another end
using the following questions:
● ·What information drives the department process?
● ·What information is generated?
● ·Who generates it?
● ·Where does the information go? Who process it?
● The goal of business process reengineering is to define architectures that
will enable a business to use information effectively.
In this project, I have determined three different architecture of business
objectives and goals:
● a. Data architecture.
● b. Application architecture.
● c. Technology architecture.
[Link].) Data modeling:
● In this phase, the information collected in business modeling phase is
refined into a set of data objects that are needed to support the project. The
attributes of each object are identified and the relationships between these
objects defined.
[Link].) Process modeling:
● In this phase, processing descriptions and functions like adding, modifying,
deleting customer records, opening of new account, closing account,
withdraw amount, deposit amount, printing reports, providing information,
file handling etc. are created.
[Link].) Application generation:
● The fourth-generation techniques are used to generate application, like
reusing the predefined functions or creating reusable components.
2.2.3.v.) Testing:
● Most of the functions are already tested, as they are predefined functions.
However, new components or functions are also tested after application
generation.
● In the project process emphasizes reuse, many of the program components
must be tested and all interfaces must be fully exercised.
2.2.4. FEASIBILITY STUDY:
● Feasibility is the determination of whether a project is worth doing the
process followed and making this determination is called feasibility study.
This determines whether a project can and should be taken. Once it has
been determined that a project is feasible, the analyst can go ahead and
prepare the project specification which finalizes project requirements.
Generally, feasibility studies are undertaken within right time constraints
and normally culminate in a written and oral feasibility report. The
contents and recommendations of such a study will be used as a sound
basis for deciding whether to proceed, postpone or cancel the project.
Thus, since the feasibility study may lead to the commitment of large
resources, it becomes necessary that it should be conducted competently
and that no fundamental errors of judgment are made.
2.2.5 FUNCTIONING OF TOPIC:
● This software is working with its employee very [Link] has facility to save
data in its software. Only write the command the data will save
automatically. We can save record in the daily basic work that a daily basis
employee and monthly basic employee, purchase of goods and parts.
● This software is work on query that is perform by the user and perform by
the [Link] is easy to query for database
CHAPTER 3: RESULTS & DISCUSSION
Figure 3.1 Screenshot 1: Bus Table
Figure 3.2 Screenshot 2: Passenger Table
Figure 3.3 Screenshot 3 : Agent Table
REFERENCES
[ 1 ] Oracle PL/SQL Programming, 5th Edition
[ 2 ] Oracle PL/SQL for Dummies
[ 3 ] Learning SQL by Alan Beaulie
[ 4 ] PL/SQL and Bind Variable: the two ways to increase the efficiency of
Network Databases by Hitesh KUMAR SHARMA, Ranjit BISWAS,
Aditya SHASTRI.
APPENDIX A
SOURCE CODE:
create table Bus (Bus no. varchar2(10),body no. varchar2(8),route
namevarchar2(20));
create table Passenger (pno. varchar2(15),pname varchar2(30),paddes
svarchar2(30), routename varchar2(23));
ceate table Agent(Aname varchar2(15),Aaddess varchar2(30),Anovarchar2(40));
create table Government(deptname varchar2(15),ownernovarchar2(30),taxno
varchar2(40));
create table Owner(ownerno varchar2(11),name
varchar2(30),addressvarchar2(40),mobileno number(20),busno varchar2(10));
Insert into Bus Values (‘rp29 1234’, ‘pp6732’,’bhop to ndls’);
Insert into Passenger Values (‘hh7899’, ‘raghav’,’delhi’, 'ndls to bhp');
Insert into Owner Values ( '2951202', 'Raghav Puri', '11/9 delhi', '99999999', '
rp2222222');