Chat with us, powered by LiveChat Finding Functional Dependencies & Second Normal Form Questions Assignment | All Paper
+1(978)310-4246 credencewriters@gmail.com
  

answer the following questions in the world documentations feel free to ask when it is not clear.thanks
hw_normalization_19b.docx

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
{propertyNo, iDate}
a) Find all the functional dependencies.
b) Get the first normal form
c) Get the second normal form
d) Get the third normal form
[2]
StdSSN
S1
S1
S2
S2
S3
StdCity
SEATTLE
SEATTLE
BOTHELL
BOTHELL
BALTIMORE
StdClass OfferNo
OffTerm
OffYear CourseNo Crsdesc EnrGrade
JUN
JUN
JUN
JUN
SEN
FALL
FALL
WINTER
FALL
SPRING
2003
2003
2003
2003
2004
O1
O2
O3
O2
O4
C1
C2
C3
C2
C2
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.
DB
VB
OO
VB
VB
3.5
3.3
3.1
3.4
3.2
[3] Functional Dependency Exercise
PROJECT/EMPLOYEE
PROJ_NUM PRJ_NAME EMP_NUM EMP_NAME JOB_CLASS CHR_HOUR
HOURS
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.
attachment

error: Content is protected !!