1 Database Implementation

Create a SQL script create_database.sql containing all the SQL commands to define the database based on the provided relational model.
Include at least one stored procedure to implement a business rule.

2 Web Management Application

Complete the provided Python Flask Application by creating the file manager_app.py.
Implement the PostgreSQL connection using ODBC.
Update the necessary tables to have a manager that can access the Flask application. Passwords should be stored as SHA-256 hashes (check out the example in password.py).
Write SQL queries for:
Adding, updating, and deleting employees.
Updating salaries and technicians' expertise.
Managing airplane models and airplanes.
Managing FAA test details.
Viewing airworthiness tests recorded by technicians.
Ensure updates only modify non-empty fields.
Ensure deletions check for foreign key dependencies before removal.

3 Airplane Test Recording Application

Complete the integration for a provided Java program AirportTestApp.java.
Login using their credentials.
Select an airplane and FAA test.
Record a test event with date, duration, and score.
Tasks: Implement the PostgreSQL connection using JDBC in Java.
Write SQL queries for:
Technician authentication using hashed passwords (SHA-256).
Fetching airplane and FAA test lists.
Inserting new test events.