Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Normalization
|
Question 77
|
Empdt1(emp code,name,street,city,state,pincode)is a schema. For any pincode, there
is only one city and state. AIso for a given street, city and state, there is just one
pincode. In normalization terms, empdtl is a relation in
is only one city and state. AIso for a given street, city and state, there is just one
pincode. In normalization terms, empdtl is a relation in
|
1NF oniy
|
|
|
2NF and hence in lNF
|
|
|
3NF and hence also in 2NF and 1NF
|
|
|
BCNF and hence also in 3NF and 2NF and 1NF
|
Question 77 Explanation:
Given,
Pincode → city, state
Street, city, state → pincode
The candidate keys are
(empcode, name, pincode)
and
(empcode, name, street, city, state)
Since in both the functional dependencies right side is prime attributes but left side is not super keys. So the given relation is in 3NF but not in BCNF.
Pincode → city, state
Street, city, state → pincode
The candidate keys are
(empcode, name, pincode)
and
(empcode, name, street, city, state)
Since in both the functional dependencies right side is prime attributes but left side is not super keys. So the given relation is in 3NF but not in BCNF.
Correct Answer: C
Question 77 Explanation:
Given,
Pincode → city, state
Street, city, state → pincode
The candidate keys are
(empcode, name, pincode)
and
(empcode, name, street, city, state)
Since in both the functional dependencies right side is prime attributes but left side is not super keys. So the given relation is in 3NF but not in BCNF.
Pincode → city, state
Street, city, state → pincode
The candidate keys are
(empcode, name, pincode)
and
(empcode, name, street, city, state)
Since in both the functional dependencies right side is prime attributes but left side is not super keys. So the given relation is in 3NF but not in BCNF.
Subscribe
Login
0 Comments