School Library Management Project

[shiv325]

Python MySQL Project : School Library Management

1. Python
2. MySQL Connector Python
3. Tables Created

Python

• All Operations through MySQL Commands
• Handles DataBases, Tables and the Data Stored in Tables

MySQL Connector Python

• Connects Python with MySQL DataBase through a Connection Object
• Cursor is associated to Connection Object
• This Cursor helps execute SQL Commands in Python
• Cursor stores the corresponding Output Data which can be obtained from it

• Cursor can also Create Tables and DataBases

  To install this connector, use the following command in your terminal : pip install mysql-connector-python

Tables Formed

1. school_students
2. library_books
3. issued_books

[shrey141102]

nice