you can create the screens in Part E using javaFx NP

You are required to develop a simple database application for a small recruiting firm that wishes to keep track of all the employees at the firm; storing details about their name, phone numbers, hiredate, Gender, and Date of Birth. The firm has many departments and there are 5 to 20 employees in each department. The department information includes department name, description and total number of employees in that department. The company also provides vehicles for some of its employees. An employee maybe allocated one car. To ensure timely maintenance of vehicle, the company would like to store the following details of the vehicle: make, model, next_maintenance_date. Each employee has a position (manager, accountant, administrator, clerk, etc.). Various allowances are allocated to each position. For example, the managers have fuel allowance, house allowance, social allowance and managers allowance. On the other hand, the administrators have house allowance and social allowance. Clerks have social allowance and uniform allowance. The name and description of each allowance needs to be stored. The database keeps track of all Projects in the organization. Each department is assigned to one or more project. Project can be assigned to one or more department (Interdisciplinary projects). Each Employee has his own credentials to login into the system to manipulate the database. The credentials are stored in a table (Login). You will also need a table to store transactions (Transaction Date/Time, User Name, Job, and Employee Number). The system must store employees' grades. Each employee will have a grade (Example A, B, C). The grade should have a predefined salary range. The system also keep track of employees' bonuses through storing the name, job, commissions, and salary. You need to have the following constraints in your system: The employee's salary should be between the grade range (Example: Grade A - Salary between 30000-50000). Employee's phone number, Hiredate, Date of Birth should not be empty. The age should between 18 and 60. Vehicle next maintenance is within 3 month of current date. Each position should not exceed the predefined allowances. The System will need a constraint for Gender (M','F'). The Username must be Unique in Table Login.. Part A: Do not use MS Word to draw the Include the following before drawing the ERD: ERD. You can use: a. Identify all Entities and attributes https://erdplus.com/ b. Identify Primary key and Foreign Key in each table/Entity c. Identify the Relationships between Entities. https://www.smartdraw.com d. Resolve any M:N relationship between the entities. https://app.diagrams.net/ e. Mapping of relations to tables. Feel Free to add the necessary Part B: attributes to each relation (table). Draw the ERD using any Data Modelling Software. Part C: Create the SQL script to create tables and insert at least five record in each table. Part D: The System must provide the following functionalities: 1- Login Screen with a Username and Password for admin only. Retrieve Username and password from table login. (Use your own Username and Password to Login and connect to the Oracle Database Server). 2- Add a new Employee. 3- Remove an Employee. 4- Update employee's salary. 5- Search by Employee number to retrieve information about his/her Allowances. 6- The system must fire a SQL trigger whenever adding, removing, and updating an employee. The trigger must store the following information (Date/Time transaction and the Username) 7- The System must provide the following reports: 7-1- Employee History (Employee Name, Department Name, Hiredate). 7-2- Vehicle History (Employee Name, Vehicle Model, Next_Maintenance). 7-3- Project History. (Project Name, Project Description, Department Name). Part E: Create the Screens using Java Swing Windows Builder You are required to develop a simple database application for a small recruiting firm that wishes to keep track of all the employees at the firm; storing details about their name, phone numbers, hiredate, Gender, and Date of Birth. The firm has many departments and there are 5 to 20 employees in each department. The department information includes department name, description and total number of employees in that department. The company also provides vehicles for some of its employees. An employee maybe allocated one car. To ensure timely maintenance of vehicle, the company would like to store the following details of the vehicle: make, model, next_maintenance_date. Each employee has a position (manager, accountant, administrator, clerk, etc.). Various allowances are allocated to each position. For example, the managers have fuel allowance, house allowance, social allowance and managers allowance. On the other hand, the administrators have house allowance and social allowance. Clerks have social allowance and uniform allowance. The name and description of each allowance needs to be stored. The database keeps track of all Projects in the organization. Each department is assigned to one or more project. Project can be assigned to one or more department (Interdisciplinary projects). Each Employee has his own credentials to login into the system to manipulate the database. The credentials are stored in a table (Login). You will also need a table to store transactions (Transaction Date/Time, User Name, Job, and Employee Number). The system must store employees' grades. Each employee will have a grade (Example A, B, C). The grade should have a predefined salary range. The system also keep track of employees' bonuses through storing the name, job, commissions, and salary. You need to have the following constraints in your system: The employee's salary should be between the grade range (Example: Grade A - Salary between 30000-50000). Employee's phone number, Hiredate, Date of Birth should not be empty. The age should between 18 and 60. Vehicle next maintenance is within 3 month of current date. Each position should not exceed the predefined allowances. The System will need a constraint for Gender (M','F'). The Username must be Unique in Table Login.. Part A: Do not use MS Word to draw the Include the following before drawing the ERD: ERD. You can use: a. Identify all Entities and attributes https://erdplus.com/ b. Identify Primary key and Foreign Key in each table/Entity c. Identify the Relationships between Entities. https://www.smartdraw.com d. Resolve any M:N relationship between the entities. https://app.diagrams.net/ e. Mapping of relations to tables. Feel Free to add the necessary Part B: attributes to each relation (table). Draw the ERD using any Data Modelling Software. Part C: Create the SQL script to create tables and insert at least five record in each table. Part D: The System must provide the following functionalities: 1- Login Screen with a Username and Password for admin only. Retrieve Username and password from table login. (Use your own Username and Password to Login and connect to the Oracle Database Server). 2- Add a new Employee. 3- Remove an Employee. 4- Update employee's salary. 5- Search by Employee number to retrieve information about his/her Allowances. 6- The system must fire a SQL trigger whenever adding, removing, and updating an employee. The trigger must store the following information (Date/Time transaction and the Username) 7- The System must provide the following reports: 7-1- Employee History (Employee Name, Department Name, Hiredate). 7-2- Vehicle History (Employee Name, Vehicle Model, Next_Maintenance). 7-3- Project History. (Project Name, Project Description, Department Name). Part E: Create the Screens using Java Swing Windows Builder