bookstore_dbms

bookstore_dbms

The application manages the database of a publishing house. The main object of the base is the management of the books designed, printed and sold by the house. The application has no graphical elements.

Relational Model:

Application usage examples:

Initial Options.

Base information in various typical scenarios.

Result for List of books.

Tuple input.

Instructions

For the operation of the application we need to connect Python(ver 3.7) with MySQL Workbench:

1. Install MySQL Workbench based on the link https://www.youtube.com/watch?v=WuBcTJnIuzo
2. We open the connection we have created.
3. We import the SQL file SQL_DB_init.sql which includes CREATE TABLE to create the database. (So ​​far we have constructed the microcosm)
4. Install Python 3.7
5. Open the Bookstore_DBMS.py file and run it. (Now we can browse our base)
6. Depending on what we want to do from now on we choose according to the instructions. CAUTION: Attribute names must be given as defined in SQL.