Awesome q2a theme
0 votes

in Databases by (43 points) | 32 views
What problem do you facing even after seeing the solution, do tell ??
I think the given solution is self-explanatory

first, check if it is in 2NF or not, by checking partial dependencies
then check if the resulting decomposition is in 3NF or not, by checking transitive dependencies
and then go for BCNF

Let us know you are facing any problem.
for finding BCNF why they have used minimal cover

They are using minimal cover to “identify the attributes and FD’s which should be included in the new table after decomposition” and along with that they are checking that the dependency can be preserved or not.

And all the above things can be done easily by getting the minimal cover.

That’s the only reason why they are using minimal cover in the solution

They are not using minimal cover to find BCNF.

Please log in or register to answer this question.

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Jun 2020
  1. ummokkate

    8 Points

  2. nehaPal13

    7 Points

  3. Taraka

    6 Points

  4. pratyush12

    6 Points

  5. Radheram

    6 Points

  6. vps123

    4 Points

  7. reboot

    2 Points

  8. Chinmay Agnihotri

    2 Points

  9. Shubham Aggarwal

    2 Points

  10. Musa

    1 Points

7,410 questions
1,744 answers
90,372 users