Question

Q2. The following unnormalized table named Employee. Transform it to third normal form (3NF). You don’t need to provide the process of normalizing the data, just include the final tables. Table.

Table. Employee empl id first_name last_name job title email user role Administrator, 10158 Jane Ford IT Analystjford@sgi.sk.caBase_Employee, Systems Base Employee, BI_Power_User Systems Power User 10196 Lisa Duffy Medical Consult duffy@sgi.sk.ca Adie Noels Rand 10602 Sarah sadie@sgi.sk.ca Driver Examiner mnoels@sqi.sk.caBase Employee IT Architect 10615 10628 Mellissa Am Clerk 5 arand@sgi.sk.caCreative_Dev

Answer 1

Answer)
Employee (empl_id, first_name, last_name, job_title, email, user_role)

FDs:
empl_id -> first_name, last_name, email
job_title -> user_role

Normalization to 3NF:

R1(empl_id email last_name first_name)
FD: empl_id -> first_name, last_name, email

R2(job_title user_role)
FD: job_title -> user_role

R3(empl_id job_title)