If every non-key attribute is functionally dependent primary key, then the relation will be in(a) First normal form(b) Second normal form(c) Third form(d) Fourth normal formThis question was addressed to me in unit test.The origin of the question is Atomic Domains topic in chapter Database Systems Design and Implementation of Database Management

If every non-key attribute is functionally dependent primary key, then

1.	If every non-key attribute is functionally dependent primary key, then the relation will be in(a) First normal form(b) Second normal form(c) Third form(d) Fourth normal formThis question was addressed to me in unit test.The origin of the question is Atomic Domains topic in chapter Database Systems Design and Implementation of Database Management
Answer» Correct option is (b) Second NORMAL form Easy explanation - THIRD normal form (3NF) relaxes this constraint slightly by ALLOWING certain nontrivial functionaldependencieswhose left SIDE is not a SUPERKEY.

Discussion

No Comment Found

Related InterviewSolutions

Functional dependencies are a generalization of(a) Key dependencies(b) Relation dependencies(c) Database dependencies(d) None of the mentionedThis question was addressed to me during an online exam.Asked question is from Extended E-R Features in section Database Systems Design and Implementation of Database Management
There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called(a) Commonality(b) Specialization(c) Generalization(d) SimilarityThis question was posed to me in an international level competition.I'd like to ask this question from Extended E-R Features in chapter Database Systems Design and Implementation of Database Management
Which of the following can be used as a primary key entry of the instructor relation.(a) DEPT_NAME(b) NAME(c) ID(d) All of the mentionedI had been asked this question in semester exam.This is a very interesting question from Querying database part-1 DDL in section Database Systems Design and Implementation of Database Management
Identify the error in the section relation(a) No error(b) Year numeric (4,0)(c) Building varchar (15)(d) Sec_id varchar (8)I got this question in semester exam.This question is from Querying database part-1 DDL topic in portion Database Systems Design and Implementation of Database Management
If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has(a) Hierarchy(b) Multilevel inheritance(c) Single inheritance(d) Multiple inheritanceThe question was asked in unit test.Question is taken from Extended E-R Features in section Database Systems Design and Implementation of Database Management
A _____________ constraint requires that an entity belong to no more than one lower-level entity set.(a) Disjointness(b) Uniqueness(c) Special(d) RelationalI got this question in a job interview.This intriguing question originated from Extended E-R Features topic in chapter Database Systems Design and Implementation of Database Management
The refinement from an initial entity set into successive levels of entity subgroupings represents a ________ design process in which distinctions are made explicit.(a) Hierarchy(b) Bottom-up(c) Top-down(d) RadicalI got this question in an interview for internship.My question comes from Extended E-R Features topic in portion Database Systems Design and Implementation of Database Management
Which of the following command is used to display the departments of the instructor relation?(a) Select * from instructor where Dept_name = Finance;(b) Select * from instructor ;(c) Select dept_name from instructor;(d) Select dept_name for instructor where Name=Jackson;This question was posed to me in homework.The above asked question is from Querying database part-2 DML in chapter Database Systems Design and Implementation of Database Management
Which relationship is used to represent a specialization entity?(a) ISA(b) AIS(c) ONIS(d) WHOISI got this question in unit test.I need to ask this question from Extended E-R Features in section Database Systems Design and Implementation of Database Management
If an attribute of a composite key is dependent on an attribute of the other composite key, a normalizationcalled _____ is needed.(a) DKNF(b) BCNF(c) Fourth(d) ThirdThe question was asked in class test.The question is from Atomic Domains in chapter Database Systems Design and Implementation of Database Management

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment