Canteen Management Application

This project was developed after just a few months of contact with the world of programming, and the goal was to put into practice the theoretical knowledge and exercises related to Python language and SqlServer database.

• In Python language, the following knowledge was applied:
  1. Programming logic
  2. List and dictionary manipulation
  3. Object-oriented programming
  4. Exception handling
• In the database:
  1. Data modeling
  2. Entity Relationship Modeling (ERM)
  3. Entity Relationship Diagram (ERD)
  4. Normalization
  5. Data dictionary
  6. DML and DDL

---

Usage

Follow the steps to run the application on your local machine.

1. Clone the repository:

   git clone https://github.com/ODCS1/Canteen-Management.git
   

2. Now make sure you have SqlServer and SSMS (Sql Server Management Studio) installed on your machine. Official Site
3. With SSMS open, execute the commands contained in the script.sql file.
4. Create a login with Sql Server authentication and grant modification access to the data in the Canteen database previously created.
5. Now, in the terminal, change the directory:

   cd Canteen-Management/src
   

6. Make sure Python is installed:

   python --version
   

7. Install Dependencies:

   pip install pyside6 pyodbc
   

8. Run main.py:

   python main.py
   

---

⚡ Thank you for visiting my Repository! If you like what you saw, please star it and follow me to see more interesting projects coming soon.