COMPUTER SCIENCE
(083)
INVESTIGATORY PROJECT
ON
Cable Shop Management
Session: - 2024-25
Project Guide: Project by:
Mr. Jitin Kohli Name :
PGT (Comp. Sc.) Roll No. :
Acknowledgement
I have great pleasure in acknowledging the help received from all those who
favored me in the preparation of this project. Their support has given an actual shape to
our project. I am especially thankful to Mr. Jitin Kohli my project guide who have given
me moral, educational and technical support as a friend, philosopher and guide, for his
great help and guidance.
Also I am especially thankful to my colleagues for their help and guidance. I
would also like to thanks to Mr. Navedu Parashar, Principal for providing me opportunity
to do this project .
Last but not least, I will like to remember my parents for giving me inspiration at
every stage. May I come to their expectations.
Certificate
It is certified that the project work entitled “ ” which is being
submitted by me in fulfillment of the requirement for CBSE AISSCE Board Practical Exam 2024-25 is
an authentic work carried out by me at K.V. No. AFS Tughlakabad under the supervision and guidance
of Mr. Jitin Kohli PGT(Comp Sc.)
(Jitin Kohli) Name:
PGT (Comp. SC.) Roll No. :
SOURCE CODE
def menu():
print('[Link]')
print('[Link]')
ch=int(input('DO YOU WANT TO CONTINUE OR NOT:'))
while ch==1:
print('WELECOME TO ROYAL CABLE CONNECTION CENTER')
print('[Link] IN')
print('[Link] UP')
print('[Link] ACCOUNT')
print('[Link]')
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 [Link] as sql
conn=[Link](host="localhost",user="root",passwd="manager",da
tabase="cable")
if conn.is_connected():
print("connected successfully")
c1=[Link]()
[Link]('use cable')
print("[Link] DETAILS")
print("[Link]")
print("[Link]")
print("[Link]")
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+"')"
[Link](v_SQL_insert)
print("DETAILS ADDED")
[Link]()
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)+")"
[Link](v_SQL2_insert)
print("DETAILS ADDED")
[Link]()
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+"')"
[Link](v_SQL3_insert)
print("DETAILS ADDED")
[Link]()
if choice==4:
quit()
def checking_2():
import [Link]
mycon=[Link](host='localhost',user='root',passwd
='manager',database='cable')
cursor=[Link]()
[Link]=True
a=input('USER NAME:')
b=input('PASS WORD:')
try:
s1="select user_name from user_accounts where
password='{}'".format(b)
[Link](s1)
data=[Link]()[0]
data=list(data)
if data[0]==a:
b1="delete from user_accounts where password =
'{}'".format(b)
[Link](b1)
return True
else:
return False
except:
print('ACCOUNT DOES NOT EXIST')
def checking_1():
import [Link]
mycon=[Link](host='localhost',user='root',passwd
='manager',database='cable')
cursor=[Link]()
[Link]=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)
[Link](c1)
print('WELCOME')
return True
except:
return False
else:
print('BOTH PASSWORDS ARE NOT MATCHING')
def checking():
import [Link]
mycon=[Link](host='localhost',user='root',passwd
='manager',database='cable')
cursor=[Link]()
[Link]=True
a=input('USER NAME:')
b=input('PASS WORD:')
try:
s1="select user_name from user_accounts where
password='{}'".format(b)
[Link](s1)
data=[Link]()[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
[Link] 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)
([Link] ,The user should create an account or login with his existing account,
[Link],The file courier service system IMPORTS another python file CABLE
MENU,
[Link], 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 : [Link]
• Website: [Link]
***************