in Education by
A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key. (a) 2NF (b) 3NF (c) BCNF (d) 1NF I had been asked this question in exam. I want to ask this question from Algorithms for Decomposition topic in division Normalization of Database Management

1 Answer

0 votes
by
The correct option is (b) 3NF For explanation: A relation is in 3 NF if an attribute of a composite key is dependent on an attribute of other composite key. (If an attribute of a composite key is dependent on an attribute of other composite key then the relation is not in BCNF, hence it has to be decomposed.).

Related questions

0 votes
    If an attribute of a composite key is dependent on an attribute of the other composite key, a ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 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
    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
    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
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
    A _______ on the attribute A of relation r consists of one bitmap for each value that A can take. ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    In order to include an attribute Name to the teaches relation which of the following command is used? (a ... , 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
    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
    I have the following models: class Project(models.Model): name = models.CharField(max_length=300, unique= ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked May 22, 2022 in Education by JackTerrance
0 votes
    In the section relation which of the following is used as a foreign key? (a) Course_id (b) ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Which of the following can be used as a primary key entry of the instructor relation. (a) DEPT_NAME ... in section Database Systems Design and Implementation of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    An ____________ consists of a search-key value and pointers to one or more records with that value as ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
...