Database Processing: SQL Functions

Database Processing

Directions:  Be sure to make an electronic copy of your answer before submitting it to Ashworth College for grading.  Unless otherwise stated, answer in complete sentences, and be sure to use correct English spelling and grammar.  Sources must be cited in APA format.  Your response should be four (4) pages in length; refer to the “Assignment Format” page for specific format requirements.

Project Question

53. Consider the following table:

TASK (EmployeeID, EmpLastName, EmpFirstName, Phone, OfficeNumber, ProjectName, Sponsor, WorkDate, HoursWorked)

with the following possible functional dependencies:

EmployeeID 🡪 (EmpLastName, EmpFirstName, Phone, OfficeNumber)

ProjectName 🡪 Sponsor

1. Write SQL statements to display the values of any rows that violate these func- tional dependencies.

2. If no data violate these functional dependencies, can we assume that they are valid? Why or why not? 

3. Assume that these functional dependencies are true and that the data have been corrected, as necessary, to reflect them. Write all SQL statements necessary to re- design this table into a set of tables in BCNF and 4NF. Assume that the table has data values that must be appropriately transformed to the new design.