Class lime

Natic

process. Please identify and prosided a detailed description of each step in this process betow.

$52.$ Assume you have the following relations and accompanying business rules:

$\backslash$table$[[$Employee$,$Title$],[$Employee ID$,$Title ID$],[$Last Name,Title$],[$First Name,Description$],[$Gender$,$Education Required$],[$Title ID$,$Average Salary$],[$Salary$,],[$Location$,],[$Datehired$,],[$Performance$,]]$

Business rules:

An employee can hase one and only one title.

A title may be assigned to one or many employees.

Identify the primary key$(s)$ for each relation:

Identify the foreign key$($s$)$:

Is this relational database structure in $3^{rd}$ normal form? Please FULLY explain your answer: