Ask a Question

R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?

in Education by
R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition? (a) A->B, B->CD (b) A->B, B->C, C->D (c) AB->C, C->AD (d) A->BCD I have been asked this question in an interview for job. I'm obligated to ask this question of Algorithms for Decomposition in portion 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
Correct answer is (d) A->BCD Explanation: This relation gives a relation without any loss in the values.

Related questions

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: 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: Which of the following is not a part of the characteristic of 4G network? (a) Multirate management (b) Fully converged services (c) Software dependency (d) Diverse user devices
    Which of the following is not a part of the characteristic of 4G network? (a) Multirate management (b) Fully converged services (c) Software dependency (d) Diverse user devices...
asked Oct 4, 2021 in Technology by JackTerrance
0 votes
Q: Oxygen is released in the process of (a) Respiration (b) Decomposition (c) Combustion (d) Photosynthesis
    Oxygen is released in the process of (a) Respiration (b) Decomposition (c) Combustion (d) ... ,Science proposed by,electromagnetic theory engineering physics,Science nptel...
asked Nov 7, 2021 in Education by JackTerrance
0 votes
Q: Oxygen is released into the atmosphere by the process of (a) Photosynthesis (b) Respiration (c) Oxidation (d) Decomposition
    Oxygen is released into the atmosphere by the process of (a) Photosynthesis (b) Respiration (c) ... ,Science proposed by,electromagnetic theory engineering physics,Science nptel...
asked Nov 7, 2021 in Education by JackTerrance
0 votes
Q: In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?
    In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which ... from Database Design Process in section Normalization of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: If a relation is in BCNF, then it is also in
    If a relation is in BCNF, then it is also in (a) 1 NF (b) 2 NF (c) 3 NF (d) ... Questions and Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: The relation AD – BC = 1, (where A, B, C and D are the elements of a transmission matrix of a network) is valid for ___________
    The relation AD - BC = 1, (where A, B, C and D are the elements of a transmission matrix of a network ... Questions for GATE EC Exam, Network Theory MCQ (Multiple Choice Questions)...
asked Oct 13, 2021 in Education by JackTerrance
0 votes
Q: which of the following is used to display an alternative content in case browser does not support frames. a. no frames b. yes frame c. false frame d. true frame
    which of the following is used to display an alternative content in case browser does not support frames. a. no ... d. true frame Select the correct answer from above options...
asked Dec 13, 2021 in Education by JackTerrance
0 votes
Q: What are the resolution steps when Burp does not intercept HTTPS requests?A)Toinstall Burp’s CA certificate in your browser.B)To run the Burp scanner again and again.C)To request additional memory for Burp by starting Burp from the command line using the -Xmx argument.D)To check the browser configuration AND To install Burp’s CA certificate in your browser.
    What are the resolution steps when Burp does not intercept HTTPS requests? A)Toinstall Burp's CA certificate ... browser configuration. Select the correct answer from above options...
asked Nov 30, 2021 in Education by JackTerrance
0 votes
Q: A fair coin is tossed 99 times. If X is the number of times heads occur, then `P(X=r)` is maximum when `r` is `49 , 50` b. `50 , 51` c. `51 , 52` d. n
    A fair coin is tossed 99 times. If X is the number of times heads occur, then P(X=r) is maximum when r is ... 51,52 D. none of these Select the correct answer from above options...
asked Nov 16, 2021 in Education by JackTerrance
0 votes
Q: The elements A, B, C and D have atomic numbers 9, 10, 11 and 12 respectively. The correct order of ionization energy is 1) D > C > B > A
    The elements A, B, C and D have atomic numbers 9, 10, 11 and 12 respectively. The correct order of ionization energy is ... > A > D > C Select the correct answer from above options...
asked Aug 3, 2022 in Education by JackTerrance
0 votes
Q: Four candidates A, B, C, D have applied for the assignment to coach a school cricket team. If A is twice as likely to be selected as B,
    Four candidates A, B, C, D have applied for the assignment to coach a school cricket team. If A is twice as ... A will not be selected? Select the correct answer from above options...
asked Nov 21, 2021 in Education by JackTerrance
0 votes
Q: Suppose we have four boxes A,B,C and D containing coloured marbles as given below :One of the boxes has been selected at random and a single marble is
    Suppose we have four boxes A,B,C and D containing coloured marbles as given below :One of the boxes has been selected ... B?, box C? Select the correct answer from above options...
asked Nov 13, 2021 in Education by JackTerrance

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

...