Question $1$

$[100$ marks$]$

SCENARIO

An organisation wants to streamline its employee onboarding process using a digital solution. The current system uses paper forms to collect new employee information, which is time$-$consuming and prone to errors. The organisation plans to develop an application to collect and manage employee data efficiently to address this.

Application Requirements:

User Registration and Login: The application will have a registration and login system to ensure secure access. Only authorised personnel can use the application.

$2$

HSYD$201-1-$Jan$-$Jun$2024-$SA$1-$RM$-$V$2-0612203$

New Employee Onboarding: The HR department will use the application to input new employee information during onboarding.

The following data will be collected for each new employee:

Employee First Name and Last Name

Employee Gender

Employee Date of Birth

Employee Email

Position$/$Job Title

Department

Starting Date

Employee ID $($automatically generated$)$

Emergency Contact Information

Additionally, a user must be able to create new patient records and view, edit, and delete them using the application.

Required

a$.$ Use MySQL WorkBench and NetBeans IDE to complete the project. In MySQL WorkBench, create the database using MySQL WorkBench and call it employee$\_$db$.$ Create a table within the employee database to store patient's details and name the table employee$\_$records. Create the table fields using the information given above in the scenario.

b$.$ Create a Graphic User Interface application using NetBeans IDE and Java Swing components. The clinic secretary will use the application to capture, edit, delete, and view employee records.

c$.$ When you have finished your project and it is fully functional, draft a guide $($documentation$)$ that explains how your application works and what it can do$,$ and