SOURCE CODE

def menu():

print('1.YES')

print('2.NO')

ch=int(input('DO YOU WANT TO CONTINUE OR NOT:'))

while ch==1:

print('WELECOME TO ROYAL CABLE CONNECTION CENTER')

print('1.SIGN IN')

print('2.SIGN UP')

print('3.DELETE ACCOUNT')

print('4.EXIT')

ch1=int(input('ENTER YOUR CHOICE:'))

if ch1==1:

a=checking()

if a==True:

print('WELCOME')

akhil()

else:

continue

elif ch1==2:

a=checking_1()
 if a==True:

print('WELCOME')

akhil()

else:

print('PASSWORD ALREADY EXISTS')

continue

elif ch1==3:

c=checking_2()

if c==True:

print('ACCOUNT DELETED')

continue

else:

print('YOUR PASSWAORD OR USER_NAME IS INCORRECT')

continue

elif ch==4:

print('THANK YOU')

break

else:

print('ERROR 404:PAGE NOT FOUND')

break

def akhil():

import mysql.connector as sql

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

tabase="cable")

if conn.is_connected():

print("connected successfully")

c1=conn.cursor()

c1.execute('use cable')

print("1.ADD DETAILS")

print("2.MAINTAINANCE")

print("3.SUGGESTION")

print("4.EXIT")

choice=int(input("ENTER UR CHOICE:"))

if choice==1:

v_code=int(input("ENTER UR CODE_NO:"))

v_name=input("ENTER UR NAME:")

v_phone_no=int(input("ENTER UR PHONE_NO:"))

v_year=int(input("ENTER THE YEAR U STARTED USING OUR

CENTER:"))

v_address=input("ENTER UR ADDRESS(CITY OR VILLAGE

NAME):")
 v_SQL_insert="insert into customer_profile

values("+str(v_code)+",'"+v_name+"',"+str(v_phone_no)

+","+str(v_year)+",'"+v_address+"')"

c1.execute(v_SQL_insert)

print("DETAILS ADDED")

conn.commit()

if choice==2:

v_code=int(input("ENTER UR CODE_NO:"))

v_name=input("ENTER UR NAME:")

v_fees=int(input("ENTER CHARGES:"))

v_rating=float(input("ENTER RATING(out of 10):"))

v_SQL2_insert="insert into maintenance

values("+str(v_code)+",'"+v_name+"',"+str(v_fees)

+","+str(v_rating)+")"

c1.execute(v_SQL2_insert)

print("DETAILS ADDED")

conn.commit()

if choice==3:

v_code=int(input("ENTER CODE_NO:"))

v_name=input("ENTER UR NAME:")

v_suggestion=input("ENTER UR SUGGESTION FOR US:")

v_SQL3_insert="insert into suggestion

values("+str(v_code)+",'"+v_name+"','"+v_suggestion+"')"
 c1.execute(v_SQL3_insert)

print("DETAILS ADDED")

conn.commit()

if choice==4:

quit()

def checking_2():

import mysql.connector

mycon=mysql.connector.connect(host='localhost',user='root',passwd

='manager',database='cable')

cursor=mycon.cursor()

mycon.autocommit=True

a=input('USER NAME:')

b=input('PASS WORD:')

try:

s1="select user_name from user_accounts where

password='{}'".format(b)

cursor.execute(s1)

data=cursor.fetchall()[0]

data=list(data)

if data[0]==a:

b1="delete from user_accounts where password =

'{}'".format(b)
 cursor.execute(b1)

return True

else:

return False

except:

print('ACCOUNT DOES NOT EXIST')

def checking_1():

import mysql.connector

mycon=mysql.connector.connect(host='localhost',user='root',passwd

='manager',database='cable')

cursor=mycon.cursor()

mycon.autocommit=True

a=input('USER NAME:')

b=input('PASS WORD:')

c=input('RE-ENTER YOUR PASS WORD:')

if b==c:

try:

c1="insert into user_accounts

values('{}','{}')".format(a,b)

cursor.execute(c1)

print('WELCOME')
 return True

except:

return False

else:

print('BOTH PASSWORDS ARE NOT MATCHING')

def checking():

import mysql.connector

mycon=mysql.connector.connect(host='localhost',user='root',passwd

='manager',database='cable')

cursor=mycon.cursor()

mycon.autocommit=True

a=input('USER NAME:')

b=input('PASS WORD:')

try:

s1="select user_name from user_accounts where

password='{}'".format(b)

cursor.execute(s1)

data=cursor.fetchall()[0]

data=list(data)

if data[0]==a:
 return True

else:

return False

except:

print('ACCOUNT DOES NOT EXIST')

menu()

OUTPUT

TESTING
 Software Testing is an empirical investigation conducted to provide stakeholders
with information about the quality of the product or service under test[1] , with respect to
the context in which it is intended to operate. Software Testing also provides an
objective, independent view of the software to allow the business to appreciate and
understand the risks at implementation of the software. Test techniques include, but are
not limited to, the process of executing a program or application with the intent of finding
software bugs.
It can also be stated as the process of validating and verifying that a software
program/application/product meets the business and technical requirements that guided
its design and development, so that it works as expected and can be implemented with
the same characteristics. Software Testing, depending on the testing method employed,
can be implemented at any time in the development process, however the most test
effort is employed after the requirements have been defined and coding process has
been completed.

TESTING METHODS
Software testing methods are traditionally divided into black box testing and white
box testing. These two approaches are used to describe the point of view that a test
engineer takes when designing test cases.

BLACK BOX TESTING

Black box testing treats the software as a "black box," without any knowledge of
internal implementation. Black box testing methods include: equivalence partitioning,
boundary value analysis, all-pairs testing, fuzz testing, model-based testing, traceability
matrix, exploratory testing and specification-based testing.

SPECIFICATION-BASED TESTING

Specification-based testing aims to test the functionality of software according to

the applicable requirements.[16] Thus, the tester inputs data into, and only sees the
output from, the test object. This level of testing usually requires thorough test cases to
be provided to the tester, who then can simply verify that for a given input, the output
value (or behaviour), either "is" or "is not" the same as the expected value specified in
the test case. Specification-based testing is necessary, but it is insufficient to guard
against certain risks

ADVANTAGES AND DISADVANTAGES

The black box tester has no "bonds" with the code, and a tester's perception is
very simple: a code must have bugs. Using the principle, "Ask and you shall receive,"
black box testers find bugs where programmers don't. But, on the other hand, black box
testing has been said to be "like a walk in a dark labyrinth without a flashlight," because
the tester doesn't know how the software being tested was actually constructed.
That's why there are situations when (1) a black box tester writes many test
cases to check something that can be tested by only one test case, and/or (2) some
parts of the back end are not tested at all. Therefore, black box testing has the
advantage of "an unaffiliated opinion," on the one hand, and the disadvantage of "blind
exploring," on the other.

WHITE BOX TESTING

White box testing, by contrast to black box testing, is when the tester has access
to the internal data structures and algorithms (and the code that implement these)

Types of white box testing:-

The following types of white box testing exist:
• api testing - Testing of the application using Public and Private APIs.
• Code coverage - creating tests to satisfy some criteria of code coverage.
For example, the test designer can create tests to cause all statements in the
program to be executed at least once.
• Fault injection methods.
 • Mutation testing methods.
• Static testing - White box testing includes all static testing.

CODE COMPLETENESS EVALUATION

White box testing methods can also be used to evaluate the completeness of a
test suite that was created with black box testing methods. This allows the software
team to examine parts of a system that are rarely tested and ensures that the most
important function points have been tested.

Two common forms of code coverage are:

• Function Coverage: Which reports on functions executed and
• Statement Coverage: Which reports on the number of lines executed to
complete the test?
They both return coverage metric, measured as a percentage

HARDWARE AND SOFTWARE REQUIREMENTS

I.OPERATING SYSTEM : WINDOWS 7 AND ABOVE

II. PROCESSOR : PENTIUM(ANY) OR AMD

ATHALON(3800+- 4200+ DUAL CORE)

III. MOTHERBOARD : 1.845 OR 915,995 FOR PENTIUM 0R MSI

K9MM-V VIA K8M800+8237R PLUS CHIPSET

FOR AMD ATHALON

IV. RAM : 512MB+

V. Hard disk : SATA 40 GB OR ABOVE

VI. CD/DVD r/w multi drive combo: (If back up required)

VII. FLOPPY DRIVE 1.44 MB : (If Backup required)

VIII. MONITOR 14.1 or 15 -17 inch

IX. Key board and mouseX. Printer : (if print is required –

[Hard copy])

SOFTWARE REQUIREMENTS:

• Windows OS
• Python
• MySql

.
 STEP 1: Open py file create table cable in the location : C:\Users\cadet\
Documents\CABLE CONNECTION SYSTEM

STEP 2: Run the file create table cable in python idle 3.7(64-bit)
('Table cable is created')
STEP 3:Open py file create table cable(use) in the location :C:\Users\cadet\
Documents\CABLE CONNECTION SYSTEM

STEP 4:Run the file create table cable (use) in python idle 3.7(64-bit)
('Table cable(use) is created')
STEP 5:Open py file create table cable(use)in the location :C:\Users\cadet\
Documents\ CABLE CONNECTION SYSTEM

STEP 6:Run the file create table cable(use) in python idle 3.7(64-bit)
('Table cable(use) is created')
STEP 7:Open py file billing procedure in the location :C:\Users\cadet\Documents\
CABLE CONNECTION SYSTEM

STEP 8:Run the file suggestion in python idle 3.7(64-bit)

('The suggestion values are inserted into the table cable(use)')
STEP 9:Open py file maintainance the location :C:\Users\cadet\Documents
CABLE CONNECTION SYSTEM

STEP 10:Run the file maintenance python idle 3.7(64-bit)

('The maintenanceare inserted into the table maintenance')
STEP 11:Open py file courier service system in the location :C:\Users\cadet\
Documents\ CABLE CONNECTION SYSTEM

STEP 12:Run the file in python IDLE 3.7(64-bit)

(1.first ,The user should create an account or login with his existing account,
2.second,The file courier service system IMPORTS another python file CABLE
MENU,
3.NOW, The user can access ROYAL CABLE CONNECTION CENTER)

BIBLIOGRAPHY
• Computer science With Python - Class XI By : Sumita Arora
• A Project Report On CABLE MANAGEMENT SYSTEM (CMS)
By : CDT.E.AKHIL
• Website: https://www.w3resource.com

***************