The table below shows the names and qualifications of employees. Each employee has precisely one employee number, and any given employee number is assigned to precisely one employee (i.e. employees...

The table below shows the names and qualifications of employees. Each employee has precisely one employee number, and any given employee number is assigned to precisely one employee (i.e. employees cannot share the same employee number).

(a) How many employees called Smith are there in this table?

(b) How many employees called Jones are there in this table?

(c) Which attribute values are redundant in this table?

(d) Show how the redundancy can be eliminated by splitting the table into two.

(e) Satisfy yourself that the original Employee table can be derived from the new tables.