Ask a Question

The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is

in Education by
The algorithm that takes a set of dependencies and adds one schema at a time, instead of decomposing the initial schema repeatedly is (a) BCNF algorithm (b) 2NF algorithm (c) 3NF synthesis algorithm (d) 1NF algorithm I got this question by my school principal while I was bunking the class. I'd like to ask this question from Algorithms for Decomposition topic in division Normalization of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
Right answer is (c) 3NF synthesis algorithm The best I can explain: The result is not uniquely defined, since a set of functional dependencies can have more than one canonical cover, and, further, in some cases, the result of the algorithm depends on the order in which it considers the dependencies in Fc.

Related questions

0 votes
Q: What are the benefit of storing JARS/external dependencies in the local repository instead of a remote one?
    What are the benefit of storing JARS/external dependencies in the local repository instead of a remote one?...
asked May 4, 2021 in Technology by Editorial Staff
0 votes
Q: Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is
    Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then ... from Materialized Views topic in portion Query Processing Techniques of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Assuming a six-person team composed of three developers, two testers, and one PO, with no vacations, then the estimated initial velocity before time off
    Assuming a six-person team composed of three developers, two testers, and one PO, with no vacations, then the estimated initial velocity before time off...
asked Nov 30, 2020 in Technology by Editorial Staff
0 votes
Q: Which algorithm takes two sentences as input and returns a Unifier?
    Which algorithm takes two sentences as input and returns a Unifier? Inference Hill-Climbing Unify algorithm Depth-first search...
asked Mar 8, 2021 in Technology by JackTerrance
0 votes
Q: Can you outline a schema at run time?
    Can you outline a schema at run time?...
asked Mar 16, 2021 in Technology by JackTerrance
0 votes
Q: A man takes a step forward with probability `0.4` and backward with probability `0.6`. The probability that at the end of eleven steps he is just one
    A man takes a step forward with probability `0.4` and backward with probability `0.6`. The probability that at the end ... )^5(0.6)^5` Select the correct answer from above options...
asked Nov 16, 2021 in Education by JackTerrance
0 votes
Q: Why cooking food in an open vessel takes more time at a hill station ?
    Why cooking food in an open vessel takes more time at a hill station ? Select the correct answer from above options...
asked Jan 4, 2022 in Education by JackTerrance
0 votes
Q: A coin is tossed repeatedly until a tail comes up for the first time. Write the sample space for this experiment.
    A coin is tossed repeatedly until a tail comes up for the first time. Write the sample space for this experiment. Select the correct answer from above options...
asked Nov 22, 2021 in Education by JackTerrance
0 votes
Q: In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
    In which of the following, a separate schema is created consisting of that attribute and the primary key ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set.
    In which of the following, a separate schema is created consisting of that attribute and the primary key ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting set of relations is
    Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy ( ... topic in portion Query Processing Techniques of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Is it necessary to set initial weights in prceptron convergence theorem to zero?
    Is it necessary to set initial weights in prceptron convergence theorem to zero? (a) yes (b) no The ... Neural Networks of Neural Networks Please answer the above question....
asked Sep 3, 2022 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...