Mall Billing System, Summaries of Physical education

Download Mall Billing System and more Summaries Physical education in PDF only on Docsity!

Introduction

Name ; darshil

khimsuriya

Class ; 12 A

Roll no ; 12111(11)

Subjest ; computer science

title ; mall billing

system...

Kendriya vidhyalaya

kalawad road Rajkot

CERTIFICATE

THE PROJECT REPORT ENTITLED

‘’MALL BILLING SYSTEM ‘’

Submitted by darshil khimsuriya of class 12 A

for the CBSE

Senior secondary education examination of

class 12 of computer

science at kendriya vidhyalaya Rajkot

(GUJARAT)

signature

TABLE OF CONTENTS [ T O C ]

• 01 ACKNOWLEDGEMENT SER DESCRIPTION PAGE NO
• 02 INTRODUCTION
• 03 OBJECTIVES OF THE PROJECT
• 04 PROPOSED SYSTEM
• 05 SYSTEM DEVELOPMENT LIFE CYCLE (SDLC)
• 06 PHASES OF SYSTEM DEVELOPMENT LIFE CYCLE
• 07 FLOW CHART
• 08 SOURCE CODE
• 09 OUTPUT
• 10 TESTING
• 11 HARDWARE AND SOFTWARE REQUIREMENTS
• 12 BIBLIOGRAPHY

Apart from the efforts of me, the success of any project depends

largely on the encouragement and guidelines of many others. I take this

opportunity to express my gratitude to the people who have been

instrumental in the successful completion of this project.

I express deep sense of gratitude to almighty God for giving me

strength for the successful completion of the project.

I express my heartfelt gratitude to my parents for constant

encouragement while carrying out this project.

I gratefully acknowledge the contribution of theindividuals who

contributed in bringing this project up tothis level, who continues to look

after me despite my flaws,

I express my deep sense of gratitude to the luminary The Principal,

Sainik School Amaravathinagar who has been continuously motivating

andextending their helping hand to us.

I express my sincere thanks to the academician The Vice Principal,

Sainik School Amaravathinagar, for constant encouragement and the

guidance provided during this project

I am overwhelmed to express my thanks to The Administrative

Officer for providing me an infrastructure and moral support while carrying

out this project in the school.

My sincere thanks to Mr.Praveen M Jigajinni , Master In-charge, A

guide, Mentor all the above a friend,who critically reviewed my project and

helpedin solving each and every problem, occurred during implementation

of the project

The guidance and support received from all the members who

contributed and who are contributing to this project, was vital for the

success of the project. I am grateful for their constant support and help.

efficiency so to replace the unending heaps of flies with a

muchsophisticated hard

disk of the computer.

One has to use the data management software. Software has been

an ascent in atomizationvarious organisations. Many software products

working are now in markets, which have helped in making the

organizations work easier and efficiently. Data management initially hadto

maintain a lot of ledgers and a lot of paperwork has to be done but now

software producton this organization has made their work fasterand

easier. Now only this software has to beloaded on the computer and work

can be done.

This prevents a lot of time and money. Thework becomes fully

automated and

any information regarding the organization can beobtained by clicking the

button. Moreover, nowit’s an age of computers of and automatingsuch an

organization gives the better look.

SYSTEM DEVELOPMENT LIFE CYCLE (SDLC)

The systems development life cycle is a projectmanagement

technique that divides complexprojects into smaller, more easily

managedsegments or phases. Segmenting projectsallows managers to

verify the successfulcompletion of project phases before

allocatingresources to subsequent phases.

Software developmentprojects typically include initiation,

planning,design, development, testing, implementation,and maintenance

phases. However, the phasesmay be divided differently depending on

theorganization involved.

For example, initialproject activities might be designated asrequest,

requirements-definition, and planningphases, or initiation, concept-

development,and planning phases. End users of the systemunder

development should be involved inreviewing the output of each phase to

ensurethe system is being built to deliver the neededfunctionality.

PHASES OF SYSTEM DEVELOPMENT LIFE CYCLE

The System Concept Development Phase begins after a business need or

opportunity is validated by the Agency/Organization Program Leadership

and the Agency/Organization CIO.

The purpose of the System Concept Development Phase is to:

Determine the feasibility and appropriateness of the

alternatives. Identify system interfaces.

Identify basic functional and data requirements to satisfy the

business need. Establish system boundaries; identify goals,

objectives, critical success factors, and performance measures.

Evaluate costs and benefits of alternative approaches to satisfy the

basic functional requirements

Assess project risks

Identify and initiate risk mitigation actions, andDevelop high-level

technical architecture, process models, data models, and a concept

of operations. This phase explores potential technical solutions

within the context of the business need.

It may include several trade-off decisions such as the decision to

use COTS software products as opposed to developing custom

software or reusing software components, or the decision to use an

incremental delivery versus a complete, onetime deployment.

Construction of executable prototypes is encouraged to evaluate

technology to support the business process. The System Boundary

Document serves as an important reference document to support

the Information Technology Project Request (ITPR) process.

The ITPR must be approved by the State CIO before the project can

move forward.

PICTORIAL REPRESENTATION OF SDLC:

PLANNING PHASE

The planning phase is the most critical step in completing

development, acquisition, and maintenance projects. Careful planning,

particularly in the early stages of a project, isnecessary to coordinate

activities and manage project risks effectively. The depth and formality

of project plans should be commensurate with the characteristics and

risks of a given project. Project plans refine the information gathered

during the initiation phase by further identifying the specificactivities and

resources required to complete a project.

A critical part of a project manager’sjob is to coordinate discussions

between user, audit, security, design, development, and network

personnel to identify and document as many functional, security, and

networkrequirements as possible. During this phase, a plan is developed

that documents the approach to be used and includes a discussion of

methods, tools, tasks, resources, project schedules, and user input.

Personnel assignments, costs, project schedule, and target dates are

established.

A Project Management Plan is created with components related to

acquisition planning, configuration management planning, quality

assurance planning, concept of operations, system security, verification

and validation, and systems engineering management planning.

and link larger systems and connections. Contemporary design techniques

often use prototyping tools that build mock-up designs of items such as

application screens, database layouts, and system architectures. End

users, designers, developers, database managers, and network

administrators should review and refine the prototyped designs in an

iterative process until they agree on an acceptable design. Audit, security,

and quality assurance personnel should be involved in the review and

approval process. During this phase, the system is designed to satisfy the

functional requirements identified in the previous phase. Since problems

in the design phase could be very expensive to solve in the later stage of

the software development, a variety of elements are considered in the

design to mitigate risk. These include:

Identifying potential risks and defining mitigating design

features. Performing a security risk assessment.

Developing a conversion plan to migrate current data to the

new system. Determining the operating environment.

Defining major subsystems and their inputs and

outputs. Allocating processes to resources.

Preparing detailed logic specifications for each software module.

The result is a draft System Design Document which captures the

preliminary design for the system.

Everything requiring user input or approval is documented and

reviewed by the user. Once these documents have been approved

by the Agency CIO and Business Sponsor, the final System Design

Document is created to serve as the Critical/Detailed Design for the

system.

This document receives a rigorous review byAgency technical and

functional representatives to ensure that it satisfies the business

requirements. Concurrent with the development of the system

design, the Agency Project Manager begins development of the

Implementation Plan, Operations and Maintenance Manual, and the

Training Plan. DEVELOPMENT PHASE

The development phase involves converting design specifications

into executable programs. Effective development standards include

requirements that programmers and other project participants discuss

design specifications before programming begins. The procedures help

ensure programmers clearly understand program designs and

functional requirements. Programmers use various techniques to

develop computer programs. The large transaction oriented programs

associated with financial institutions have traditionally been developed

using procedural programming techniques. Procedural programming

involves the line-by-line scripting of logical instructions that are

combined to form a program.Effective completion of the previous

stages is a key factor in the success of the Development phase. The

Development phase consists of:

Translating the detailed requirements and design into

system components. Testing individual elements (units) for

usability.

Preparing for integration and testing of the IT system.

INTEGRATION AND TEST PHASE

Subsystem integration, system, security, and user acceptance

testing is conducted during the integration and test phase. The user,

with those responsible for quality assurance, validates that the

functional requirements, as defined in the functional requirements

document, are satisfied by the developed or modified system. OIT

Security staff assess the system security and issue a security

certification and accreditation prior to installation/implementation.

Multiple levels of testing are performed, including :

Testing at the development facility by the contractor and

possibly supported by end users

Testing as a deployed system with end users working

together with contract personnel

conn=sql.connect(host='localhost',user='root',passwd='manager',database='shoe_

billing')

conn.autocommit=True

c1=conn.cursor()

user=input("enter user")

passwd=input("enter password")

if user=='raghavan' and passwd=='leo':

print(" shoe billing")

print(" ")

print("1:ENTER CUSTOMER DETAILS")

print(" ")

print("2:SHOW CUSTOMERS DETAILS")

print(" ")

v_choice=int(input("enter the choice"))

TRUE

STOP

FALSE

ifv_choice==1 :

code=input("enter code=")

brand =input("enter brand=")

name=input("enter customer name=")

number=input("enter phone number=")

details=input ("adress=")

amount=input("amount=")

c1.execute("insert into shoe_details values

("+code+",'"+brand+"'"+",'"+name+"',"+number+",'"

+details+"',"+amount+")")

conn.commit()

elifv_choice==2:

v_code=input("enter the

code number")

c1.execute("select * from

shoe_details where shoe_code

="+v_code)

importmysql.connector as sql

conn=sql.connect(host='localhost',user='root',passwd='manager'

,database='shoe_billing')

#if conn.is_connected():

#print('connected sucessfully')

conn.autocommit=True

c1=conn.cursor()

#c1.execute("create table shoe_details(shoe_codeint

primary

key,brand_namevarchar(25),customer_namevarchar(25),customer_nu

mber,,customer_address,amount )")

c1=conn.cursor()

user=input("enter user")

passwd=input("enter password")

if user=='raghavan' and

passwd=='leo':

print(" shoe billing")

print("1:shoe billing")

print("2:show result")

v_choice=int(input("enter the choice"))

ifv_choice==1 :

code=input("enter code=")

brand =input("enter brand=")

name=input("enter customer name=")

number=input("enter phone number=")

details=input ("adress=")

amount=input("amount=")

c1.execute("insert into shoe_details values

("+code+",'"+brand+"'"+",'"+name+"',"+number+",'"+details+"',"

+amount+")")

conn.commit()

c1. elifv_choice==2:

v_code=input("enter the code number")

execute("select * from shoe_details where shoe_code

="+v_code) data=c1.fetchall()

print("Shoe code:",data[0][0])

print("brand name:",data[0][1])

print("customer name:",data[0][2])

print("customer number:",data[0][3])

print("customer detail:",data[0]

[4]) print("amoumt:",data[0][5])

OUTPUT

MAIN PAGE ASKING THE CHOICE OF THE PROGRAMER

PAGE SHOWING THE ENTRY OF CUSTOMERS DETAILS