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 system requested feasible.
ECONOMICAL FEASIBILITY:
Economics analysis is themost 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 recirds
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 FEASIBILITY:
Technical Feasibility centre on the existing computer system and to what
extent it can support the proposed task. This involves financial
consideration to accommodate technical enhancements.
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 correctly. There are
broadly three types of errors as follows:
1. Compile-time errors: Errors that occur during compilation of a
program is called compile time error. It has two types as follows:
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 program which is the
called program “Crashed”.
3. Logical Errors: Sometimes, even if you don’t encounter any error
during compiling-time and runtime, your program 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 error.
TESTING
1. Alpha Testing: It’s 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 developer’s site.
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 Software 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 and 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 testing.
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:
1. Corrective Maintenance: When the program after compilation
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 manangement. To
accommodate changing needs time to time maintenance is done
and is called Adaptive maintenance.
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,
information technology is the fasted growing area. If the existing
system is maintained to keep tuned with the new features, new
facilities, new capabilities, it is said to be perfective maintenance.
CODE
Import mysql.connector as mcon
Import sys
Con=
Mcon.connect(host=”localhost”,port=”3306”,user=”root”,passwd=”root
”)
Mycursor-con.cursor()
If con.is_connect();
Print(“My SQL 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)0”)
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 upw=
‘{}’ and ustatus = ‘{}’”.format(uid,pwd,status))
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 inserting a New Record.”)
print(“ Input ‘U’ for update on existing record.”)
print(“ Input ‘R’ for removing 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 ’:
ins = “create table if not exist students(\
reg_num int(20) primary key , loc_sr_num integer NOT NULL,
yr_pass_xi int(5) MOT 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), minority varchar(5),\
PwD_status varchar(20),mob_num bigint NOT NULL,email_id
varchar (50), aadhar_num bignit,\
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),annual_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*------------------------
print(“Insertion Operation.”)
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 minor
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 aadhar 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): ”)
intsub1 = input(“Enter name of internal grade
subject1:”)
intsub2 = input(“Enter name of internal grade
subject2:”)
intsub3 = input(“Enter name of internal grade
subject3:”)
anic =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, email_id,\
aadhar_num,sub_1, sub_2, sub_3, sub_4, sub_5,add_ sub_6,int_grade_
sub1, int_grade_ sub2, int_grade_ sub3,\
annual_income,roll_num_of_equi_exam_passed,
exam_of_equi_exam_passed, board_of_equi_exam_passed,\
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,anl
nc,eexrnum,eexam,eexboard,sch,mgcr,adm_num,adm_date)
my.cursor.execute(q)
con.commit()
print(“Record is inserted Successfully.”)
#------------------------------*UPDATION*--------------------------------------
elif ch == ‘U’ or ch== ‘u’:
print = (“Updation of Record.”)
reg = input(“Enter New student’s Name: ”)
sn = input(“Enter New student Mother’s Name:”)
fn = input(“Enter New student Father’s Name:”)
qry = “update students set cand_name = ‘{}’ ,
mother_name = ‘{}’ ,father_name = ‘{}’ where reg_num =
{}”.format(sn,mn,fn,reg)
mycursor.execute(qry)
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)
my.cursor.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.”)
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 ALI Records.”)
qry = “select * from students”
mycursor.execute(qry)
data = mycursor.fetchall()
count = mycursor.rowcount
print (“Total No. of Records:”,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’, ‘Subject3’, ‘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}{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
else:
print(“Wrong Input. Try Again!!!!!”)
else:
print(“Login Failed”)
if at !=4:
print(“Try Again”)
else:
print(“MySQL DataBase Connection Failed.Terminating….”)
PRABHUJEE ENGLISH MEDIUM SCHOOL
VSS NAGAR, BHUBANESWAR
SESSION-2023-24
CLASS-XII SCIENCE
COMPUTER PROJECT
ROLL NO-
TOPIC- FEASABILITY STUDY
SUBMITTED TO: SUBMITTED BY:
RESHMI SHAH KANAKA PRABHA MAJHI
Certificate
This is to certify that Kanaka Prabha Majhi a student of
class XII has successfully completed the project under the
guidance of Reshmi Shah during the year2022-2023 in
partial fulfillment of computer practical conducted by
AISSCE as per CBSE.
Date:
Signature of internal examiner Signature of external examiner
Acknowledgment
I would like to express my special thanks to my computer
teacher Reshmi Shah as well as our principal Sir Abhaya
Rath for providing me with the opportunity to work on
this beautiful project.
Secondly, I would also like to thank my parents and
friends who helped me to finish this project within the
limited time frame.
Finally, I would like to thank everyone without whose
help I could not have completed my project successfully.
index
1. Feasibility Study
2. Errors and their types
3. Testing
4. Maintenance
5. Code
6. Bibliography
BIBLIOGRAPHY
1. python.org
2. tutorialsPoint.com
3. Learn Python.org
OUTPuT
OUTPuT
