Computer Science
Finding Functional Dependencies & Second Normal Form Questions Assignment

Question Description

I’m trying to learn for my Computer Science class and I’m stuck. Can you help?

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








thanks

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. ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

Attached.

Normalize following table up to 3rd NF.
In this example we extend the Property Inspection 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. FD represent functional dependency
Property Inspection (property, no iTime, pAdress, comments, staffNo, sName, carReg)

b) Get the first normal form

c) Get the second normal form
In 2NF we remove partial dependency to have the following;

d) Get the third normal form
Here we remove the transitive dependency to obtain...

PDaven (1970)
Boston College

Anonymous
Top quality work from this tutor! I’ll be back!

Anonymous
Just what I needed… fantastic!

Anonymous
Use Studypool every time I am stuck with an assignment I need guidance.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags