This is my first Back End development project focused on Data Analysis and Data Engineering. It demonstrates my skills in Python, Shell Script, and SQL. I will continue to add features as I learn more.

• CSV Files:

  • cars_data.csv
  • customers_data.csv
  • cars_data_test.csv
  • customers_data_test

• SQL Files:

  • dump-rentcarssys.sql

• Python Files:

  • generate_graphs.py
  • system.py

• Shell Scripts:

  • insert-cars-data.sh
  • insert-costumers-data.sh
  • Dump.sh

• cars_data.csv: Cars data generated by chatgpt.com
• customers_data.csv: customers data generated by generatedata.com.
• cars_data_test.csv: First 5 results in the cars_data.csv to test the insert-cars-data.sh file without put more than 50 tuples into the database
• customers_data_test: First 5 results in the customers_data.csv to test the insert-customers-data.sh file without put 100 tuples into the database

• dump-rentcarssys: Database dump for easy setup.

• generate_graphs.py: Scripts for data analysis and graph generation.
• system.py: Previously as system.sh, now in python. System interface for managing customer and company data.

• insert-cars-data.sh: Cars data insertion script
• insert-customers-data.sh: Fictional customers insertion script
• Dump.sh: Dump & Truncate database.

1. Clone the repository:

   git clone https://github.com/Fadokkx/RENT_CARS-SYS.git
   cd RENT_CARS-SYS

2. Set up Database dump-rentcarsys.sql
3. Insert data in insert-costumers-data.sh and insert-cars-data.sh
4. Run system.py
5. Create graphs in generate_graphs.py