in Education by
If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed. (a) DKNF (b) BCNF (c) Fourth (d) Third The question was asked in class test. The question is from Atomic Domains in chapter Database Systems Design and Implementation 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 option is (b) BCNF The explanation is: BCNF eliminates all redundancy that can be discovered based on functional dependencies.

Related questions

0 votes
    A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other ... for Decomposition topic in division Normalization of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    If every non-key attribute is functionally dependent primary key, then the relation will be in (a) First ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    A representation of an attribute that cannot be measured directly, and are subjective and dependent on the context of ... was derived. (1)Relative Metrics (2)Absolute Metrics...
asked May 15, 2021 in Technology by JackTerrance
0 votes
    Calling javax.persistence.criteria.Path.get(String name) fails for the simple class hierarchy detailed below. The ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jan 15, 2022 in Education by JackTerrance
0 votes
    Define composite key?...
asked Dec 13, 2020 in Technology by JackTerrance
0 votes
    In the __________ normal form, a composite attribute is converted to individual attributes. (a) First (b) ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    If needed to split a node or coalesce it with its siblings, or redistribute key values between siblings, ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    The relation with the attribute which is the primary key is referenced in another relation. The relation ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Which algorithm uses equality comparison on a key attribute with a primary index to retrieve a single ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Normalize the given text and comment on the vocabulary before and after the normalization: Raj and Vijay are best ... an online gamer. Select the correct answer from above options...
asked Nov 12, 2021 in Education by JackTerrance
0 votes
    There are situations in which it is necessary to write back the block to disk, even though the buffer ... Buffer in chapter Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    Which one of the following attribute can be taken as a primary key? (a) Name (b) Street (c) Id ... and Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    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
...