SQL Projects

School Portal & Library Management

This repository contains two Python projects that use MySQL for data storage:

• School Portal (schoolportal.py)
• Library Management System (library.py)

---

1. School Portal

A command-line portal for managing student and club information in a school.

Features

• Student and administrator login/signup
• Student details management (add, update, delete, view)
• Club management (add, delete, change incharge, join club)
• Password management for both students and administrators

Database Setup

Run the SQL commands in schoolportal_schema.sql to create the required database and tables:

mysql -u root -p < schoolportal_schema.sql

• Make sure to update the MySQL connection details in schoolportal.py if needed.

---

2. Library Management System

A command-line library system for managing books, members, and book issue/return records.

Features

• Add, update, delete, and search books
• Add, update, delete, and search members
• Issue and return books, with fine calculation
• View all records

Database Setup

Run the SQL commands in library_schema.sql to create the required database and tables:

mysql -u root -p < library_schema.sql

• Make sure to update the MySQL connection details in library.py if needed.

---

Requirements

• Python 3.x
• MySQL Server
• mysql-connector-python package

Install the required Python package:

pip install mysql-connector-python

---

Usage

1. Set up the databases by running the provided .sql files in your MySQL client.
2. Update the MySQL credentials in the Python scripts if necessary.
3. Run the desired script:
   • For the school portal:

     python schoolportal.py
     

   • For the library system:

     python library.py
     

---

Notes

• All data is stored in MySQL databases (schoolportal and library).
• These are console-based applications intended for educational/demo purposes.
• Make sure your MySQL server is running before starting the applications.

---

License

This project is for educational use. Feel free to modify and use as needed.