1. Which of the two choices below are the reasons why the relation below is not BCNF.

   
   

   in_dep (ID, name, salary, dept_name, building, budget )

   with a functional dependency dept_name --> building, budget

   
   

   		dept_name is not a superkey
   		dept_name --> building, budget is not a trivial dependency
   		id --> name, salary, dept_name is also a functional dependency
   		It is not 3NF

1. in_dep (ID, name, salary, dept_name, building, budget )

   Choose the following decompositions of in_dep into BCNF when

   dept_name->building, budget causes a violation of BCNF.

   
   

   		id, name, salary, dept_name
   		id, name, salary
   		dept_name, building, budget
   		salary, dept_name, budget

1. List the advantages of 3NF over BCNF

   		Can always preserve functional dependencies
   		Ensures no losslessness
   		It's a subset of BCNF
   		It's stricter

Answer rating: 100% (QA)

The detailed answer for the above question is provided below The correct answer for the first questi... View the full answer