Thepurposeof
thisphaseis to:
enhance the system.
Öperate, maintain, and infomation.
system can process sensitive
Certify that the ensure the functional
assessments of the system to
Conduct periodic
satisfied.
requirements continue to be retired.
needs to be modemized, replaced, or
Determine when the system
FLOW CHART
start
Importmysql.connector as sql
conn sql.connect(host='localhost',user
root',passwd-'manager',database'a
uto mobile station)
Iifeonn,is connected):
print("'SuccessfullyConnected")
cl.cxccute('ercate table
customer details(snoint primary
key,
cnamevarchar(25),cdetailsvarcha ys
r(30),caddressvarchar(30),cpinco
deint,cpuramtint,cdise float))
print ('table created") ql
hoic hoic hoic
username=inpuEUSERN
AME:)
passward-input('PASSW
ORD:)
CLexecute('select
rom Ser
nomninpu"Enter the erial Number: M)
enameminput( Ener he customer Ame
caetailamnpu"Ener the eustomer deuls:
caddres npur"Enler the customer cre
pancodeininpu Enter he pincode:
purammint inpu"Ener he uramt "D
SOL nsertinscrt intoGusomexeIerM)
cname h c d c a i s N d
priny"CUSTOMER Created araL
nCommi)
ntmNCNor
Tetcha Lk)
print(data)
CltcRe"elect rom
ndpasswd
print("CUSTOMER ormat(usernanN
Created Congratsl|I")
conn.commit()
any (data print
PRINT("CREADTED"
mport main
NSQLInsent =insert into customerdetails
values strno)MCname
cdetails Me+
+str(vcpincode )tr(puramt )+
+str(v_cdisc)+)
cl.execute(V_SQLInsert)