Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    12THCOMPLETE PROJECT FESS (1)

    Uploaded by

    Rohithkumar ragupathi

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    12THCOMPLETE PROJECT FESS (1)

    Uploaded by

    Rohithkumar ragupathi
    3 views24 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    3 views24 pages

    12THCOMPLETE PROJECT FESS (1)

    Uploaded by

    Rohithkumar ragupathi

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 24

    SRI SAI VIDHYASHRAM SENIOR SECONDARY SCHOOL

    COMPUTER SCIENCE PROJECT


    TOPIC - FEES MANAGEMENT
    SUBMITTED BY: SUBMITTED TO:
    J.SASIREKHA

    Class: XII (subject teacher)

    CBSE Roll no:


    CERTIFICATE
    This is to certify that of class:
    XII of SRI SAIVIDHYASHRAM
    SENOIR SECONDARY SCHOOL
    has done his project on FEES
    MANAGEMENT under my
    supervision. He has taken interest
    and has shown at most sincerity
    in completion of this project.
    I certify this project up to
    my expectation & as per guidelines
    issued by CBSE, NEW DELHI.

    ___________________ ___________________
    Internal Examiner External Examiner

    _________
    principal
    ACKNOWLEDGMENT
    It is with pleasure that I
    acknowledge my sincere gratitude
    to our teacher MS J.SASIREKHA who
    taught and undertook the
    responsibility of teaching the
    subject computer science. I have
    been greatly benefited from her
    classes.

    sincere appreciation for all the


    other students of my batch and
    the good times that we all shared
    together.

    Finally, I would like to thank


    our principal who has always been
    a source of inspiration.
    INDEX
    1. HARDWARE AND SOFTWARE REQUIRED

    2. INTRODUCTION

    3. FUNCTIONS

    4. FUTURE SCOPE

    5. BENEFITS

    6. MODULES

    7. ER DIAGRAM

    8. CODING
    9.OUTPUT
    10.CONCLUSION
    11.BIBLIOGRAPHY
    HARDWARE AND SOFTWARE REQUIRED

    HARDWARE
    1. PC
    2. MOBILE PHONE

    SOFTWARE
    • PYTHON (latest version)
    • MYSQL
    • PYTHON CONNECTOR
    INTRODUCTION

    This project is entitled Fees Management System. It is a web-

    based application developed using PYTHON Language as the back

    end and MySQL as the database.

    The system allows the Education institution process its student

    related functions as easily.

    It has a pleasant user interface using Bootstrap Framework. The

    project consists of user-friendly features and functionalities.


    Functions of Fees Management System

    The Fees Management System comes with many modules such as


    1. To add student
    2. To view student details
    3. To update student detail
    4. To Remove student
    5. To View required student detail
    6. To create fees paid slip

    The Educational institution can easily do above process using this


    software as user friendly. Educational institution can easily retrieve
    student record .
    FUTURE SCOPE

    The use of FEES management systems has seen significant


    growth in recent years as more EDUCATION INSTITUTION prefer to
    process their functions.

    According to a study by the statistics 90 percent of


    EDUCATION INSTITUTION using employer management software

    EDUCATION INSTITUTION saves their time and process


    functions to STUDENT with speed and accuracy

    EDUCATION INSTITUTION can immediately provide any STUDENT


    detail WITH FEES DETAIL

    All concern uses this software to process as quickly


    And accurately

    BENEFITS OF FEES MANAGEMENT


    1. USER FRIENDLY
    2. Employee REGISTRATION

    3. Maximize Efficiency

    4. Availability of services

    5. Time Saver and Less Hectic

    6. Transparent process

    7. Know bank updated process

    8. Quick and Easy Process

    9. Easy updation

    10.easily access data

    11.more security

    12.More Conveniences for You


    MODULES
    1.REGISTER STUDENT data

    2.DISPLAY all STUDENTS DETAILS

    3.update STUDENT DETAILS

    4.DISPLAY FEES DETAILs

    5.delete STUDENT detail


    LOGIN

    FEE
    ADMIN MANAGEMENT
    SYSTEM
    USER

    DATABASE
    LOGIN
    FEES DETAILS

    FEES
    MANAGEMENT
    SYSTEM

    EXIT DISPLAY
    REQUIRED
    STUDENT
    DETAILS

    DISPLAY ALL
    STUDENTS DETAILS

    CODE:
    #SQL Commands to create both the tables:
    #Student table:
    #mysql> CREATE TABLE student (roll int(5) Primary key, name
    varchar(20) NOT NULL, age int(2) NOT
    #NULL, class varchar(3), City varchar(10));
    #Fee table:
    #mysql> CREATE TABLE fee (roll int(5) references Student(roll),
    FeeDeposit int(6) NOT NULL, month
    #varchar(10));

    import os
    import platform
    import mysql.connector
    import pandas as pd
    mydb =
    mysql.connector.connect(host='localhost',user='root',passwd='Sas
    i@2023',database='SSV',auth_plugin="mysql_native_password")
    mycursor=mydb.cursor()

    def stuInsert():
    L=[]
    roll=int(input("Enter the roll number : "))
    L.append(roll)
    name=input("Enter the Name: ")
    L.append(name)
    age=int(input("Enter Age of Student : "))
    L.append(age)
    classs=input("Enter the Class : ")
    L.append(classs)
    city=input("Enter the City ofthe Student : ")
    L.append(city)
    stud=(L)
    sql="""insert into student(roll,name,age,class,city) values
    (%s,%s,%s,%s,%s)"""
    mycursor.execute(sql,stud)
    mydb.commit()

    def stuView():
    print("Select the search criteria : ")
    print("1. Roll")
    print("2. Name")
    print("3. Age")
    print("4. City")
    print("5. All")
    ch=int(input("Enter the choice : "))
    if ch==1:
    s=int(input("Enter roll no : "))
    rl=(s,)
    sql="""select * from student where roll=%s"""
    mycursor.execute(sql,rl)
    elif ch==2:
    s=input("Enter Name : ")
    rl=(s,)
    sql="""select * from student where name=%s"""
    mycursor.execute(sql,rl)
    elif ch==3:
    s=int(input("Enter age : "))
    rl=(s,)
    sql="""select * from student where age=%s"""
    mycursor.execute(sql,rl)
    elif ch==4:
    s=input("Enter City : ")
    rl=(s,)
    sql="""select * from student where City=%s"""
    mycursor.execute(sql,rl)
    elif ch==5:
    sql="""select * from student"""
    mycursor.execute(sql)
    res=mycursor.fetchall()
    print("The Students details are as follows : ")
    print("(ROll, Name, Age, Class, City)")
    for x in res:
    print(x)

    def feeDeposit():
    L=[]
    roll=int(input("Enter the roll number : "))
    L.append(roll)
    feedeposit=int(input("Enter the Fee to be deposited : "))
    L.append(feedeposit)
    month=input("Enter month of fee : ")
    L.append(month)
    fee=(L)
    sql="""insert into FEES(roll,feeDeposit,Month) values
    (%s,%s,%s)"""
    mycursor.execute(sql,fee)
    mydb.commit()

    def feeView():
    print("STUDENTS FEES DETAILS")
    r=input("enter roll no")
    q="Select roll,sum(feeDeposit) from FEES group by roll having
    roll=%s"
    rl=(r,)
    mycursor.execute(q,rl)
    res=mycursor.fetchall()
    for x in res:
    print(x)
    def removeStu():
    roll=int(input("Enter the roll number of the student to be
    deleted : "))
    rl=(roll,)
    sql="""Delete from FEES
    where roll=%s"""
    mycursor.execute(sql,rl)
    sql="""Delete from student where roll=%s"""
    mycursor.execute(sql,rl)
    mydb.commit()

    def MenuSet(): #Function For The Student Management System


    print("Enter 1 : To Add Student")
    print("Enter 2 : To View Student ")
    print("Enter 3 : To Deposit Fee ")
    print("Enter 4 : To Remove Student")
    print("Enter 5 : To View Fee of Any Student")

    try: #Using Exceptions For Validation


    userInput=int(input("Please Select An Above Option: ")) #Will
    Take Input From User
    except ValueError:
    exit("\nHy! That's Not A Number") #Error Message
    else:
    print("\n") #Print New Line
    if(userInput==1):
    stuInsert()
    elif(userInput==2):
    stuView()
    elif(userInput==3):
    feeDeposit()
    elif(userInput==4):
    removeStu()
    elif(userInput==5):
    feeView()
    else:
    print("Enter correct choice. . . ")

    MenuSet()
    def runAgain():
    runAgn=input("\nwant To Run Again Y/n: ")
    while(runAgn.lower()=='y'):
    if(platform.system()=="Windows"):
    print(os.system('cls'))
    else:
    print(os.system('clear'))
    MenuSet()
    runAgn=input("\nwant To Run Again Y/n: ")

    runAgain()

    OUTPUT:

    Python 3.7.7 (tags/v3.7.7:d7c567b08f, Mar 10 2020, 10:41:24)


    [MSC v.1900 64 bit (AMD64)] on win32
    Type "help", "copyright", "credits" or "license()" for more
    information.
    >>>
    ===== RESTART: C:\Users\Admin\Downloads\sasiprojects\Fees
    management (1).py ====
    Enter 1 : To Add Student
    Enter 2 : To View Student
    Enter 3 : To Deposit Fee
    Enter 4 : To Remove Student
    Enter 5 : To View Fee of Any Student
    Please Select An Above Option: 1

    Enter the roll number : 1212


    Enter the Name: DIYA
    Enter Age of Student : 17
    Enter the Class : 12
    Enter the City ofthe Student : VLR

    want To Run Again Y/n: y


    0
    Enter 1 : To Add Student
    Enter 2 : To View Student
    Enter 3 : To Deposit Fee
    Enter 4 : To Remove Student
    Enter 5 : To View Fee of Any Student
    Please Select An Above Option: 2

    Select the search criteria :


    1. Roll
    2. Name
    3. Age
    4. City
    5. All
    Enter the choice : 5
    The Students details are as follows :
    (ROll, Name, Age, Class, City)
    (12001, 'shyam', 17, 12, 'vellore')
    (12002, 'GUGAN', 17, 12, 'KATPADI')
    (1010, 'sowmmi', 16, 11, 'kpd')
    (1212, 'DIYA', 17, 12, 'VLR')

    want To Run Again Y/n: y


    0
    Enter 1 : To Add Student
    Enter 2 : To View Student
    Enter 3 : To Deposit Fee
    Enter 4 : To Remove Student
    Enter 5 : To View Fee of Any Student
    Please Select An Above Option: 3

    Enter the roll number : 1212


    Enter the Fee to be deposited : 75000
    Enter month of fee : 2024/07/09

    want To Run Again Y/n: y


    0
    Enter 1 : To Add Student
    Enter 2 : To View Student
    Enter 3 : To Deposit Fee
    Enter 4 : To Remove Student
    Enter 5 : To View Fee of Any Student
    Please Select An Above Option: 5

    STUDENTS FEES DETAILS


    enter roll no1212
    (1212, Decimal('75000'))

    want To Run Again Y/n: n


    >>>
    CONCLUSION

    In this Fees Management System in Python with Source Code is

    free to download. Fees Management System contains the admin side

    and client side.

    This project is good for the student who want to learn python

    programming because this project contains many modules and a user’s

    friendly.

    It is easy to understand and manipulate this project and use for

    education purpose only.


    BIBLOGRAPHY

    • www.google.com

    • www.wikipedia.org

    REFERECE BOOK – SUMITRA ARORA


    Class XI & XII NCERT Book
    REFERENCE BOOK: REEMA THAREJA

    You might also like