Normalization Exercises for Access

Due date: Friday, March 1, 2019 before midnight. Upload to Blackboard a word document or a pdf file with the solution. Convert the following relations into 3NF. NOTE: The underlined fields are the PK. JOB (clientId.iobNo, firstName, lastName, address, phone, referredBy, jobdescription, estTime, estCost, plannedStartDate, plannedEndDate, actualStartDate, actualEndDate, actualTime, actualCost, decoratorld, d name, d phone, dateHired, salary) Given that decoratorld ->d name, d phone, dateHired, salary clientld -> firstName, lastName, address, phone, referredBy jobNo ->jobdescription