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 algorithmI 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

The algorithm that takes a set of dependencies and adds one schema at

1.	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 algorithmI 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
Answer» 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.

Discussion

No Comment Found

Related InterviewSolutions

The functional dependency can be tested easily on the materialized view, using the constraints ____________.(a) Primary key(b) Null(c) Unique(d) Both Null and UniqueThe question was asked during an online interview.I need to ask this question from Algorithms for Decomposition in portion Normalization of Database Management
Blueprints are intended to:(a) Prototype of the screen layout showing navigation and main design elements(b) Show the grouping of pages and user journeys(c) Indicate the structure of a site during site design and as a user feature(d) Prototype typical customer journeys or clickstreams through a websiteThis question was addressed to me in an interview for job.My question is based upon Application Programs and User Interfaces topic in division Normalization of Database Management
In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?(a) Dept name, year->size(b) Year->size(c) Dept name->size(d) Size->yearThe question was asked by my school teacher while I was bunking the class.This interesting question is from Database Design Process in section Normalization of Database Management
Storyboards are intended to:(a) Indicate the structure of a site during site design and as a user feature(b) Prototype of the screen layout showing navigation and main design elements(c) Integrate consistently available components on the webpage (e.g. navigation, search boxes)(d) Prototype typical customer journeys or click streams through a websiteI had been asked this question in exam.My doubt stems from Application Programs and User Interfaces topic in portion Normalization of Database Management
_____________ can help us detect poor E-R design.(a) Database Design Process(b) E-R Design Process(c) Relational scheme(d) Functional dependenciesThis question was posed to me in an interview for job.The origin of the question is Database Design Process topic in chapter Normalization of Database Management
What is the best way to represent the attributes in a large database?(a) Relational-and(b) Concatenation(c) Dot representation(d) All of the mentionedThis question was addressed to me by my school teacher while I was bunking the class.The doubt is from Database Design Process in portion Normalization of Database Management
Which is a bottom-up approach to database design that design by examining the relationship between attributes:(a) Functional dependency(b) Database modeling(c) Normalization(d) DecompositionI had been asked this question in unit test.My question is based upon Normal Forms in portion Normalization of Database Management
Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:(a) 1NF(b) 2NF(c) 3NF(d) All of the mentionedThis question was posed to me in an online quiz.I need to ask this question from Normal Forms in portion Normalization of Database Management
A table on the many side of a one to many or many to many relationship must:(a) Be in Second Normal Form (2NF)(b) Be in Third Normal Form (3NF)(c) Have a single attribute key(d) Have a composite keyI got this question in an online quiz.Question is from Normal Forms topic in chapter Normalization of Database Management
Designers use which of the following to tune the performance of systems to support time-critical operations?(a) Denormalization(b) Redundant optimization(c) Optimization(d) RealizationI have been asked this question in an interview for internship.I would like to ask this question from Database Design Process in portion Normalization of Database Management

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment