Consider the relational database schemas given below and the associated sets of functional dependencies and

answer the questions for each.

a.

CompanyRoster(comEmail, comName, numEmplyees, totalRevenue, presidentName, presidentEmail,

presidentPhone)

comEmail-->comName, numEmployees, totalRevenue, presidentName,presidentEmail,presidentPhone

presidentEmail-->presidentName, presidentPhone

presidentPhone-->presidentName, presidentEmail

Is this table in 2NF? Why or why not? Is this table in 3NF? why or why not. Do the decompositions to

produce a set of 3NF tables. Are the tables also in Boyce-Codd Normal Form? Why or why not?

b.

SurgicalTeam(sugeonID, nurseID, nurseStation, surgeryDate, patientName)

surgeonID, nurseID, surgeryDate-->nurseStation, patientName

nurseStation-->nurseID

Is this table 2NF? Why or why not? Is this table 3NF? Why or why not? Is this table BCNF? Why or why not

Do the decompositions to produce a set of BCNF tables.