Questions Support your answers to questions below with any assumptions that help to clarify your understanding of data in the Software_details table. 1Identify one anomaly that might arise from using...

Questions

Support your answers to questions below with any assumptions that help to clarify your understanding of data in the Software_details  table.

1Identify one anomaly that might arise from using the above table.

2Identify all functional dependencies in the above mentioned table.

3.Explain why this table does not satisfy BCNF.

4.Convert this table into a set of BCNF tables that can hold the sample data shown in the above table.