The Driver Relationship considered that working on both DRIVERS and ACTIVE_DRIVERS tables is difficult and too much work. Therefore, the team wants you to remove the table for the active drivers.

Task Description: Consider the following relations for a company: Department (Did: integer, Dname: string, location: string) Employee (Eid: integer, Ename: string, Erank: integer, salary: real, DepartmentID, integer) Project (Pid: integer, DepartmentID: integer, Pname: string, budget: real, start year: integer) The “DepartmentID” fields in both Employee and Project are foreign keys referencing the “Did”field of the Department table.    Through Java application, use SQL to insert (random but meaningful) data records in the above tables:1) Create two different departments (named: Marketing and Human Resources)2) Create at least three employees per department (6 employees in total). A rank of an employee is an integer value between 1 and 3.3) Create at least three different projects per department (6 projects in total). The start year is between 2018 and 2020.

So I need help creating a schema for my data managment class. I need someone to inspect my code and make any necessary adjustments........

please answer with proper explanation and step by step solution.