COMPUTER

SCIENCE
INVESTIGATORY
PROJECT:
SESSION: 2024-2025

Submitted By: DEEPESH SHARMA , ANANT ,

MANAV DHOUNDIYAL
CLASS: XII-
ROLL NO:
SUBMITTED TO: MR
CERTIFICATE
This is to certify that DEEPESH SHARMA of
class XII-B has successfully completed her
project under the guidance of subject teacher
MR from Vidya Bal Bhawan Sr. Sec. School in
partial fulfilment of Computer Science practi-
cal examination conducted by CBSE for ses-
sion.

Principal’s signature:
Teacher’s signature:

Examiner’s signature:

2 | Page
 ACKNOWLEDGEME
NT
I extend my appreciation and thanks
to MR SANJEEV KUMAR. It was his
unfailing pushing and constant inspi-
ration that this work could take the
present shape.
Turning aspirations into realities is
easier when people are supportive of
your efforts. Among such persons are
my parents to whom I am deeply in-
debted for the positive feedback re-
garding contribution to my work and
for their unfailing steps and ungrudg-
ing help at every step in this project.

3 | Page
 -Deepesh
Sharma
Class: XII-B

INDEX
Sno. Topic

1 System requirements
2 Feasibility study
3 Errors and its types
4 Testing
5 Maintenance
6 Flow chart of program
7 Code
8 Output
9 Appendix

4 | Page
10 Bibliography

SYSTEM REQUIRE-
MENTS
1. HARDWARE:
✓ Processor
✓ Keyboard
✓ Minimum memory - 2GB
2. SOFTWARE:
5 | Page
 ✓ Operating System –OS10,
OS11
✓ Python IDLE
✓ MYSQL

FEASIBILITY STUDY
Feasibility study is a system proposal according to its work,
ability, impact on the operation ability to meet the needs of
users and efficient use of resources. An important outcome
of preliminary investigations the determination of that sys-
tem requested feasible.
ECONOMICAL FEASIBILITY:

6 | Page
Economics analysis is the most frequent use method for
evaluating the effectiveness of the candidates the benefits
and savings that are expected from system and compare
them with cost.
This software is not very costly. It just worth Rs.5500/-.So
users records can be maintained at a cheaper cost and every
school would like to use this software so that the student’s
records can be managed easily.
TECHNICAL FEASIBILTY:
Technical feasibility centre on the existing computer system
and to what extent it can support the proposed task. This in-
volves financial consideration to accommodate technical en-
hancements.
It is technically feasible because whatever technology is
needed to develop this software is easily available.

ERRORS AND ITS TYPES

An error, some time called “A BUG” is anything in the code
that prevents a program from compiling and running cor-
rectly. There are broadly three types of errors as follows:
1. Compile- time errors: Errors that occurs during compi-
lation of a program is called compile time error. It has two
types as follows:

7 | Page
 a. Syntax error: It refers to formal rules governing the
construction of valid statements in a language.
b. Semantics error: It refers to the set of rules which
give the meaning of a statement.
2.Run time Errors: Errors that occur during the execution
of program are run time errors. These are harder to detect
errors. Some run-time error stop the execution of pro-
gram which is then called program “Crashed”.
3. Logical Errors: Sometimes, even if you don’t encounter
any error during compiling-time and runtime, your pro-
gram does not provide the correct result. This is because
of the programmer’s mistaken analysis of the problem he
or she is trying to solve. Such errors are called logical er-
ror.

TESTING
1. Alpha Testing: It is the most common type of testing
used in the software industry. The objective of this testing
is to identify all possible issues or defects before releasing
it into the market or to the user. It is conducted at the de-
veloper’s site.

8 | Page
2. Beta Testing: It is a formal type of software testing
which is carried out by the customers. It is performed in a
real environment before releasing the products into the
market for the actual end-users. It is carried out to ensure
that there are no major failures in the software or product
and it satisfies the business requirement. Beta Testing is
successful when the customer accepts the software.
3. White Box Testing: White box testing is based on the
knowledge about the internal logic of an application’s
code. It is also known as Glass box Testing. Internal Soft-
ware and code working should be known for performing
this type of testing. These tests are based on the coverage
of the code statements, branches, paths, conditions etc.
4. Black Box Testing: It is a software testing, method in
which the internal structure or design of the item to be
tested is not known to the tester. This method of testing
can be applied virtually to every level of the software test-
ing.

MAINTENANCE
Programming maintenance refers to the modifications in
the program. After it has been completed, in order to meet
changing requirement or to take care of the errors that
shown up. There are four types of maintenance:

9 | Page
 1. Corrective Maintenance: When the program after compi-
lation shows error because of some unexpected situations,
untested areas such errors are fixed up by Corrective
maintenance.
2. Adaptive Maintenance: Changes in the environment in
which an information system operates may lead to system
management. To accommodate changing needs time to
time maintenance is done and is called Adaptive mainte-
nance.
3. Preventive Maintenance: If possible the errors could be
anticipated before they actually occur; the maintenance is
called Preventive maintenance.
4. Perfective Maintenance: In this rapidly changing world, in-
formation technology is the fastest growing area. If the ex-
isting system is maintained to keep tuned with the new
features, new facilities, new capabilities, it is said to be
Perfective maintenance.

FLOW CHART OF THE

PROGRAM

10 | Page
 LIST OF CANDIDATE

INSERT SEARCH DELETE UPDATE DISPLAY

To To To To To
insert search delete update display
details details details records records

EXIT

11 | Page
 CODE

import mysql.connector as mcon

import sys

con = mcon.connect(host="localhost",port="3306",user="root",passwd="root")

12 | Page
mycursor = con.cursor()

if con.is_connected():

print("MySql DataBase is connected Successfully.")

mycursor.execute("create database if not exists LOC")

mycursor.execute("use LOC")

mycursor.execute("create table if not exists user \

(uname varchar(20) primary key,upwd varchar(20)\

,utype char(5),ustatus char(5))")

Q = "insert into user(uname,upwd,utype) values (\'LOC\',\'LOC\',\'S\')"

#print(Q)

#mycursor.execute(Q)

con.commit()

at = 1

while at <= 3:

at += 1

uid = input("Enter User Name : ")

pwd = input("Enter User Password : ")

status = 'A'

mycursor.execute("select * from user where uname = '{}' and upwd = '{}'

and ustatus = '{}'".format(uid,pwd,status))

13 | Page
 data = mycursor.fetchone()

count = mycursor.rowcount

#print(count)

if count == 1:

print("Login Successfully.")

print("Perform CRUD Operations.")

#--------------------------*CHOICES*-----------------------------

while True:

print("Input 'I' for Insertion a New Record.")

print("Input 'U' for Update an Existing Record.")

print("Input 'R' for Removal an Existing Record.")

print("Input 'S' for Searching a Record.")

print("Input 'D' for Display All Records.")

print("Input 'E' for Exit the Program.")

ch = input("Enter Your Option: ")

#--------------------------*TABLE CREATION*-----------------------------

if ch == 'I' or ch == 'i':

14 | Page
 ins = "create table if not exists students(\

reg_num int(20) primary key, loc_sr_num integer NOT NULL, yr_pass_xi int(5)
NOT NULL,\

exam_cat char(5) NOT NULL,cand_name char(50) NOT NULL,mother_name

char(50) NOT NULL,\

father_name char(50) NOT NULL,gender varchar(5),category1 varchar(5),mi-

nority varchar(5),\

PwD_status varchar(20),mob_num bigint NOT NULL,email_id varchar(50),aad-

har_num bigint,\

sub_1 char(15),sub_2 char(15) NOT NULL,sub_3 char(15) NOT NULL,\

sub_4 char(15) NOT NULL,sub_5 char(15) NOT NULL,add_sub_6 char(15) NOT

NULL,\

int_grade_sub1 char(30),int_grade_sub2 char(30),int_grade_sub3 char(30),an-

nual_income varchar(25),roll_num_of_equi_exam_passed integer,\

exam_of_equi_exam_passed char(20),board_of_equi_exam_passed
char(20),single_child char(5),\

migration_certificate char(5),adm_no integer,adm_date date)"

#print(ins)

mycursor.execute(ins)

#--------------------------*INSERTION OF RECORDS*-----------------------------

15 | Page
 print("Insertion Operation.")

reg = int(input("Enter student's registration_num: "))

locsr = int(input("Enter student's loc_sr_num: "))

yrpassc11 = int(input("Enter student's year_passing_class11: "))

ecat = input("Enter student's exam_cat: ")

cname = input("Enter student's Name: ")

mname = input("Enter student's mother's name: ")

fname = input("Enter student's father's name: ")

gender = input("Enter student's gender: ")

cat = input("Enter student's category: ")

minor = input("Enter if student belongs to minority section(y/n): ")

pwdis = input("Enter if student have disability (type of disability): ")

mnum = int(input("Enter student's mobile_num: "))

email = input("Enter student's email_id: ")

ad_num = int(input("Enter student's addhar number: "))

s1 = input("Enter subject1(compulsory language): ")

s2 = input("Enter subject2: ")

s3 = input("Enter subject3: ")

s4 = input("Enter subject4: ")

s5 = input("Enter subject5: ")

s6 = input("Enter subject6(additional): ")

16 | Page
 intsub1 = input("Enter name of internal grade subject1: ")

intsub2 = input("Enter name of internal grade subject2: ")

intsub3 = input("Enter name of internal grade subject3: ")

aninc = int(input("Enter annual income of student's parents: "))

eexrnum = int(input("Enter student's rollnum of equivalent exam

passed:"))

eexam = input("Enter student's exam of equivalent exam passed:")

eexboard = input("Enter student's board of equivalent exam

passed:")

sch = input("Enter if student is single girl child or not:")

mgcr = input("Enter if migration certificate is required or not:")

adm_num = int(input("Enter student's admission num:"))

adm_date = input("Enter student's admission date as (yyyy-mm-

dd):")

q = "insert into students

(reg_num,loc_sr_num,yr_pass_xi,exam_cat,cand_name,\

mother_name,father_name,gender,category1,minority,PwD_status,mob_num,e
mail_id,\

aadhar_num,sub_1,sub_2,sub_3,sub_4,sub_5,add_sub_6,int_grade_sub1,int_gr
ade_sub2,int_grade_sub3,\

annual_income,roll_num_of_equi_exam_passed,exam_of_equi_exam_passed,b
oard_of_equi_exam_passed,\

17 | Page
 single_child,migration_certificate,adm_no,adm_date) values ({},{},{},'{}',\

'{}','{}','{}','{}','{}','{}','{}',{},'{}',{},'{}','{}','{}','{}','{}','{}','{}','{}','{}',{},\

{},'{}','{}','{}','{}',{},'{}')\

".format(reg,locsr,yrpassc11,ecat,cname,mname,fname,gender,cat,minor,pwdis
,mnum,email,ad_num,s1,s2,s3,s4,s5,s6,intsub1,intsub2,intsub3,aninc,eexrnum,
eexam,eexboard,sch,mgcr,adm_num,adm_date)

mycursor.execute(q)

con.commit()

print("Record is inserted Successfully.")

#--------------------------*UPDATION*-----------------------------

elif ch == 'U' or ch == 'u':

print("Updation of Record.")

reg = input("Enter Student's registration Number: ")

sn = input("Enter New student's Name: ")

mn = input("Enter New student Mother's Name: ")

fn = input("Enter New student Father's Name: ")

qry = "update students set cand_name = '{}' , mother_name = '{}' , fa-

ther_name = '{}' where reg_num = {}".format(sn,mn,fn,reg)

mycursor.execute(qry)

18 | Page
 con.commit()

print("Record is updated Successfully.")

#--------------------------*DELETION*-----------------------------

elif ch == 'R' or ch == 'r':

print("Removal of Record.")

reg = input("Enter Student's registration Number: ")

qry = "delete from students where reg_num = {}".format(reg)

mycursor.execute(qry)

con.commit()

print("Record is deleted Successfully.")

#--------------------------*SEARCHING*-----------------------------

elif ch == 'S' or ch == 's':

print("Searching Operation.")

reg = input("Enter Student's registration Number: ")

qry = "select * from students where reg_num = {} ".format(reg)

#print(qry)

mycursor.execute(qry)

print("Record is found Successfully.")

19 | Page
 data = mycursor.fetchone()

count = mycursor.rowcount

print("Total No. of Record:",count)

for row in data:

print(row)

#--------------------------*DISPLAY*-----------------------------

elif ch == 'D' or ch == 'd':

print("Display ALl Records.")

qry = "select * from students"

mycursor.execute(qry)

data = mycursor.fetchall()

count = mycursor.rowcount

print("Total No. of Record: ",count)

print("{0:<9s}{1:<9s}{2:<9s}{3:<9s}{4:<9s}{5:<9s}{6:<9s}{7:<9s}{8:<9s}
{9:<9s}".format('Sl.No','Name','MName','FName','Subject1','Subject2','Sub-
ject3','Subject4','Subject5','Subject6'))

print("_____________________________________________________________
____________________________")

for row in data:

print("{0:<9s}{1:<9s}{2:<9s}{3:<9s}{4:<9s}{5:<9s}{6:<9s}{7:<9s}
{8:<9s}

20 | Page
{9:<9s}".format(str(row[1]),row[4],row[5],row[6],row[14],row[15],row[16],row[
17],row[18],row[19]))

elif ch == 'E' or ch == 'e':

print("Exiting Program.")

sys.exit(0)

else:

print("Wrong Input. Try Again!!!!!")

else:

print("Login Failed")

if at !=4:

print("Try Again")

else:

print("MySql DataBase Connection Failed.Terminating....")

21 | Page
 OUTPUT

22 | Page
1.Table created successfully.

23 | Page
 STRUCTURE OF THE TABLE

2. Insertion of record:

24 | Page
25 | Page
3. Updating record:

4. Deleting a record:

26 | Page
5. Searching a record:

27 | Page
6. Display all Records:

28 | Page
7. Exit:

29 | Page
 RECORDS:

30 | Page
 APPENDIX

31 | Page