Awesome q2a theme
0 votes

in Databases by (41 points) | 23 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.

Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Oct 2019

    410 Points

  2. Satbir

    317 Points

  3. Rudr Pawan

    163 Points

  4. srestha

    136 Points

  5. Mk Utkarsh

    127 Points

  6. Debapaul

    94 Points

  7. chandrikabhuyan8

    87 Points

  8. Shaik Masthan

    79 Points

  9. Verma Ashish

    77 Points

  10. !KARAN

    74 Points

Monthly Top User and those within 60% of his/her points will get a share of monthly revenue of GO subject to a minimum payout of Rs. 500. Current monthly budget for Top Users is Rs. 450.
1,680 questions
1,090 answers
89,591 users