This project uses Python (Flask-SQLAlchemy), PostgreSQL (PgAdmin 4) and Postman (for API Testing) to enable CRUD functionality for a database 'Company', with many tables and constraints in those tables.
- For each department whose average employee salary is more than $30,000, retrieve the department name and the number of employees working for that department.
- A view that has the department name, its manager's name, number of employees working in that department, and the number of projects controlled by that department (for each department).
- A view that has the project name, controlling department name, number of employees working on the project, and the total hours per week they work on the project (for each project).
- A view that has the project name, controlling department name, number of employees, and total hours worked per week on the project for each project with more than one employee working on it.
- A view that has the employee name, employee salary, department that the employee works in, department manager name, manager salary, and average salary for the department.
Thanks to Akshay sir and Anchit sir for the constant guidance and support.
Thanks to Cubastion Consulting Pvt. Ltd. for a productive and supportive environment that fosters learning.