answer the following questions on the world documentation feel free to ask when it is not clear.
Unformatted Attachment Preview
Normalize following table up to 3rd NF.
In this example we extend the PropertyInspection database to include property inspection by
members of staff. When staffs are required to undertake the inspections, they are allocated a
company car for use on the day of the inspections. However, a car may be allocated to several
members of staff as required throughout the working day. A member of staff may inspect several
properties on a given date, but a property is only inspected once on a given date.
The primary key
a) Find all the functional dependencies.
b) Get the first normal form
c) Get the second normal form
d) Get the third normal form
OffYear CourseNo Crsdesc EnrGrade
Please find all the functional dependencies.
Please find out the second normal form (in the format of relational schema).
Please find out the third normal form.
 Functional Dependency Exercise
PROJ_NUM PRJ_NAME EMP_NUM EMP_NAME JOB_CLASS CHR_HOUR
note: The charge_hour attribute represents the employee’s hourly charge and it can be decided by the
employee’s job class. Employees can work for different projects and each project-work hour is traced. A
project needs many employees.
[a] Find out the primary key(s)
[b] Define the modification anomalies. And give one example from above table.
[c] Define the insertion anomalies. And give one example from above table.
[d] Define the deletion anomalies. And give one example from above table.
[e] Find out all the functional dependencies.
[f] Please normalize above table to the first normal form.
[g] Please normalize [f] table to the second normal form.
[h] Please normalize [g] table to the third normal form.
Our essay writing service fulfills every request with the highest level of urgency.