engineering recuitment NIC NIELIT Scientist B 2023 Mock Test DBMS Integrity Constraints and Normal Form Normal Form
Consider the following two relational schemas. The underlined attributes are the respective primary keys. For each schema, all non-trivial functional dependencies are listed.
Schema 1: instructor(ID, name, salary, dept_name)
Functional Dependency: ID → name, dept_name, salary
Schema 2: Department(ID, dept_name, budget, building)
Functional Dependency: ID, dept name → building, budget
Which one of the following statements is correct?
1
Both Schema 1 and Schema 2 are in BCNF.
2
Schema 1 is in 2NF and Schema 2 is in 3NF.
3
Both Schema 1 and Schema 2 are in 3NF.
4
Schema 1 is in BCNF and Schema 2 is in 3NF.