Please come up with the database report from given scenario $1.$ This case study represents record of the information regarding Aged Care Facility Management, where employees and management unit holds an important position in the facility. For instance, each management unit have the unique unit$$s name, unit ID$,$ office phone extension, internal fax number and nursing station. A management unit can assign many employees; however, each employee is assigned to only one management unit. Employees have attributes such as employee Id$,$ first name, last name, contract number and work email. All position of employees mainly depends on the job contract as assigned and mainly in this facility employees such as Registered Nurses $($RN$),$ assistant nurses $($AN$),$ care givers $($CG$),$ lifestyle staff $($LS$),$ kitchen staffs $($KS$)$ and cleaner$($C$)$ are working. Additionally, all these employees are working as per the contracted hours and their wages rate also differ as per the position and working hour $($for example, $40$ hours a week, $32$ hours$/$week and for others $20$ hours$).$ As per the role, salary type is coded as $1$ for RN$,2$ for AN$,3$ for $($CG$),4$ for $($LS$),5$ for $($KS$)$ and $6$ for $($C$).$ Similarly, few employees are considered as a first$-$level employee, such as facility managers, clinical managers, and accounting managers, who are contracted in special salary package with profit sharing schemes. These mangers also hold unique identity as per their assign role, such as their targets, commissions including personal attributes names, address and contact number, under which account managers are responsible for all the pay roll records and should keep all the record of compliance order.$-$ Case study

$-$Executive Summary and Introduction

$-$Assumption

$-$ERD Diagram

$-$Relation Schema

$-$Business Rules

$-$Cardinalities and Connectivity

$-$Normalisation steps $(3$NF$)$ that include dependency diagrams for each entity.

$-$Data DictionaryDDL includes screenshots from Xampp that show the database name Aarati $(20030804)$

$-$DML includes screenshots from Xampp that show the database Aarati $(20030804)$DDL

Statements

$$ The DDL statements required to create a physical

implementation of the conceptual data modelabove.

$$ Students must use XAMPP or Microsoft SQL to

create these tables, attributes, and relationships.

$$ Transaction and Commit statements should be

included in the DDL$.$

$$ All constraints should be included such as $($PK$,$

FK$,$ Null, and Not Null$)$

DML

Statements to

Insert Data

$$ DML statements to insert $(5$ rows$)$ data into the

database.

$$ Transaction and Commit statements should be

included in the DML$.$

$$ A screenshot is provided after inserting the data.

$-$A Txt file that includes all the SQL code $($DDL and DML Commands$).$