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

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


1.   Identify one anomaly that might arise from using the above table.                              (6 marks)


2.   Identify all functional dependencies in the above mentioned table.                             (7 marks)


3.   Explain why this table does not satisfy BCNF.                                                            (7 marks)


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


Note: Document the tables in your design using the notation below.