QUESTION 4 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
QUESTION 4
-
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
QUESTION 5
-
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
QUESTION 6
-
List the advantages of 3NF over BCNF
Can always preserve functional dependencies
Ensures no losslessness
It's a subset of BCNF
It's stricter
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
