Problem:

A company has several employees. Each employee is trained on some machines, and many employees can be trained on the same machine. For each employee, the company has an ID, name, address, zone, salary, tax level, machineid, trained since date, machine maximum capacity, machine type and machine energy rating on file. More information about various fields is below.

Question:

Calculate minimal cover. Using the minimal cover, convert the schema to 3NF. Is the result also in BCNF? Why or why not?

Table 1 : Employee Training Eid- employee ID, Ename - employee name, Eaddress- employee address, Ezone- zone depending on eaddress, Esalary-employee salary, Etaxlevel- tax bracket depending on esalary and ezone, Mid - Machine ID that the employee is trained on, Trained Since- Date since given employee was trained on given machine, Mcapacity - Maximum Capacity of that machine, Mtype- type of machine, Menergyrating- energy rating of machine, depending on mcapacity and mtype menergyrating A 120 Type A Note: As per convention, the underline below a field name signifies a key. eid ename eaddress ezone lesalaryetaxlevel mid trainedsince mcapacity mtype 3 Morty Smith 23 Harry Place 4200 3900 A 1 2000-01-01 5 Russell Bueno 803 Arroyo Lane 4523 3500Z 1 2011-04-03 120 Type A 5 Russell Bueno 803 Arroyo Lane 4523 3500Z 2. 2012-05-04 98 Types 3 Morty Smith 23 Harry Place 4200 3900 A 3 1999-05-03 230 Types 3 Morty Smith 23 Harry Place 4200 3900 A 4 2012-12-12 111 TypeP A C 2900F 4 2013-07-15 C 4 Frank Whitney 174 Ramsey Circle 2 Rick Astley 23 Harry Place 2300 4200 111 TypeP 30 TypeC 4100B 5 2010-04-01 B 2300 2900F 5 B 4 Frank Whitney 174 Ramsey Circle 2 Rick Astley 23 Harry Place 2019-08-01 2020-12-12 30 TypeC 110 TypeP 4200 4100B 7 B 4 Frank Whitney 174 Ramsey Circle 2300 2900F 7 2021-02-01 110 TypeP B 1 Glenda McCall 56573 Hintze Lane 4001 4000A 8 2013-07-15 99 Type A D 1 Glenda McCall 56573 Hintze Lane 4001 4000 A 9 2010-04-01 100 Types D