BCNF is more advanced in terms of 3 NF. It can also be called 3.5 NF.
For example – In 3 NF example (Gender -> Salutation). This means Salutation is functionally dependent on Gender.
Hence to achieve BCNF make gender a primary key in other tables.
In this, we can see that table 3 is functionally dependent on table 1.
This means we can obtain the table 3 data i.e contact_no using the user_id of table 1.
This shows that table 3 is functionally dependent on table 1.
So to achieve BCNF
For example, table 2 doesn’t have any primary key till 3NF, while table 1 and table 2 has already primary key user_id and gender respectively.
Hence we added id as a primary key in table 2.
Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique
Don't hesitate to give us a call or send us a contact form message