A 3 NF relation is converted to BCNF by
1.removing composite keys
2.removing multivalued dependencies
3.dependent attributes of overlapping composite keys are put in a separate relation
4.dependent non-key attributes are put in a separate table
Posted Date:-2021-12-09 15:21:17