BY, ROJA.A XII - “A” ACKNOWLEDGEMEN T I would like to express my special thanks of gratitude to my teacher Mrs. Rexline mam as well as our principal Mrs. A.M JAYANTHI mam who gave me the golden opportunity to do this wonderful project on the topic (“student information table ”), which also helped me in doing a lot of Research and i came to know about so many new things I am really thankful to them. Secondly i would also like to thank my parents and friends who helped me a lot in finalizing this project within the limited time frame. -ROJA.A XII “A”. TABLE OF CONTENTS hardware specification 1
introduction about python 2
brief on sql 3
about this project 4
functions and modules used 5
pyhton source code 6
sql query 7
overall output 8
biblography 9 HARDWARE SPECIFICATIONS • CPU: Intel Core or Xeon 3GHz (or Dual Core 2GHz) or equal AMD CPU. Cores: Single (Dual/Quad Core is recommended) • RAM: 4GB (6GB recommended) • Graphic Accelerators: nVidia or ATI with support of OpenGL 1.5 or higher. • Display Resolution: 1280x1024 is recommended, 1024x768 is minimum. SOFTWARE REQUIREMENTS: • Windows OS • Python 3 • MySQL connector module INTRODUCTION ABOUT PYTHON Python is a versatile, high-level programming language known for its readability and simplicity. Created by Guido van Rossum and released in 1991, it emphasizes code clarity and developer productivity. Python supports multiple programming paradigms, including procedural, object-oriented, and functional programming, making it suitable for various applications.
Its extensive standard library and a vibrant ecosystem of third-party packages
facilitate tasks ranging from web development and data analysis to artificial intelligence and automation. Frameworks like Django and Flask streamline web development, while libraries like NumPy and Pandas are essential for data science.
Python's strong community support and cross-platform capabilities further enhance
its appeal, making it a popular choice for beginners and experienced developers alike. Its growing use in academia and industry underscores its importance in the tech landscape. BRIEF ON MYSQL MySQL is a widely-used open-source relational database management system (RDBMS) that allows users to efficiently store, manage, and retrieve data. Developed in the mid-1990s by MySQL AB and now owned by Oracle Corporation, MySQL is known for its speed, reliability, and ease of use. It employs Structured Query Language (SQL) for database interactions, enabling users to perform operations like querying, updating, and managing data.
Features like data security, transaction support, and replication
contribute to its robust performance. With a strong community and extensive documentation, MySQL remains a foundational technology in modern software development. ABOUT THIS PROGRAM This Python program implements a simple Student Information System using MySQL as the backend database. It allows users to manage student records by creating a database table, adding new student entries, and viewing existing records. The program leverages the mysql.connector library to establish a connection with a MySQL database. It features functions to create the student table, add student details, and retrieve a list of students. Input validation ensures proper date formats when adding students. The user interacts with the system through a console menu, making it easy to navigate and manage student information. FUNTIONS: Built-in funtions: print(), input(), int(), float(), str(), len(), lower(), try, finally,mysql.connector: connect(), cursor(), execute(), fetchall(), commit(), close() User-defined Functions: connect_db(), selection(), student_management(), insert_student(), display_students(), update_student(), delete_student(), fee_management(), insert_fee(), update_fee(), delete_fee(), exam_management(), insert_exam(), update_exam(), delete_exam()
USER DEFINED FUNTIONS USES:
mysql.connector.connect(): connect_db(): Establishes a connection to the database. selection(): Displays the main menu and processes user choice. student_management(): Manages student-related operations. insert_student(): Adds a new student record to the database. display_students(): Retrieves and displays all student records. update_student(): Updates the class of an existing student. delete_student(): Deletes a student record based on admission number. fee_management(): Manages fee-related operations. insert_fee(): Adds a new fee record to the database. update_fee(): Updates an existing fee record. delete_fee(): Deletes a fee record based on admission number. exam_management(): Manages exam-related operations. insert_exam(): Adds a new exam record to the database. update_exam(): Updates the result of an existing exam record. delete_exam(): Deletes an exam record based on admission number.
INBUILT FUNTION USES
float(): Converts input to a floating-point number for fee values. str(): Converts values to strings (not explicitly used in the code). len(): Returns the length of an object (not explicitly used in the code). lower(): Converts a string to lowercase for case-insensitive comparisons. try / finally: Manages exceptions and ensures resources are closed. PACKAGES AND MODULES USED:- mysql.connector: This is the main package for connecting to and interacting with a MySQL database. Error: A module within mysql.connector for handling database errors. datetime: This module provides classes for manipulating dates and times. PYTHON SOURCE CODE SQL QUERIES
TABLE CREATION DATABASE CREATION AND USING IT INSERTION OF RECORDS OVERALL OUTPUT DISPLAYING RECORDS
FURTHER QUUERIES BIBLIOGRAPHY
Wikipedia sumitha Arora grade 12 QUORA
https://en.wikipedia.org/wiki/Python_(programming_language) https://www.quora.com/What-is-the-advantage-of-learning-Python-and-SQL-at-the-same-time THANK YOU
