python-sqlite-hw3

University database management system with Python and SQLite - Homework solution

Python SQLite University Database

A complete university database management system built with Python and SQLite, implementing homework assignments for database operations.

📚 Project Description

This project demonstrates:

• Database creation and table structure (Homework 1)
• SQL SELECT queries implementation (Homework 2)
• Data manipulation with INSERT, UPDATE operations
• Python integration with SQLite

🛠️ Technologies Used

• Python 3.x
• SQLite3
• SQL queries

📁 Database Structure

The database includes the following tables:

• group - Student groups
• student - Student information
• lecturer - Lecturer information
• subject - Course subjects
• schedule - Subject-lecturer relationships

🚀 Installation & Usage

1. Clone the repository

git clone https://github.com/YOUR_USERNAME/python-sqlite-university.git cd python-sqlite-university

2. Run the main script

python python_solution.py