What does the BCNF decomposition algorithm do?(a) States a method to decompose a relation satisfying BCNF(b) States a method for joining two relations satisfying BCNF(c) States a method to decompose a relational schema such that there are no multiple occurrences(d) None of the mentionedThe question was posed to me by my college director while I was bunking the class.My doubt is from Decomposition Algorithms topic in division Relational Database Design of RDBMS

What does the BCNF decomposition algorithm do?(a) States a method to d

1.	What does the BCNF decomposition algorithm do?(a) States a method to decompose a relation satisfying BCNF(b) States a method for joining two relations satisfying BCNF(c) States a method to decompose a relational schema such that there are no multiple occurrences(d) None of the mentionedThe question was posed to me by my college director while I was bunking the class.My doubt is from Decomposition Algorithms topic in division Relational Database Design of RDBMS
Answer» Correct choice is (a) States a method to DECOMPOSE a RELATION SATISFYING BCNF For explanation I would say: If a relation is not in BCNF, it can be DECOMPOSED into simpler relations that are in BCNF. The BCNF decomposition ALGORITHM states a method to decompose a relation satisfying BCNF.

Discussion

No Comment Found

Related InterviewSolutions

To specify the foreign keys in relations referencing temporal data we need to specify _______(a) The time interval(b) The Boolean value for the working(c) The integer corresponding to the relation number(d) None of the mentionedI had been asked this question in exam.I'd like to ask this question from Normal Forms in division Relational Database Design of RDBMS
Which of the following is the time of temporal data that record when a fact was recorded in a database?(a) Transaction time(b) Valid time(c) Enter time(d) Exit timeI have been asked this question during an interview.This interesting question is from Normal Forms topic in chapter Relational Database Design of RDBMS
State true or false: Overlapping time intervals cannot be prevented(a) True(b) FalseI got this question in quiz.This interesting question is from Normal Forms topic in chapter Relational Database Design of RDBMS
Functional dependencies that have a time associated with them during which they are valid are called as________(a) Timed functional dependencies(b) Clocked functional dependencies(c) Temporal functional dependencies(d) Modeled functional dependenciesThe question was posed to me during a job interview.The above asked question is from Normal Forms topic in portion Relational Database Design of RDBMS
The value of the data at a particular time is called as?(a) Instance(b) Picture(c) Snapshot(d) None of the mentionedThis question was posed to me in quiz.This intriguing question originated from Normal Forms topic in section Relational Database Design of RDBMS
The data that have a time interval associated with them during which they are valid are called as________(a) Timed data(b) Temporal data(c) Model data(d) Clocked dataI had been asked this question in quiz.This is a very interesting question from Normal Forms in chapter Relational Database Design of RDBMS
State true or false: Crosstabs are not desirable in a database design(a) True(b) FalseI have been asked this question in an online quiz.This intriguing question comes from Normal Forms topic in portion Relational Database Design of RDBMS
The process of making a normalized schema unnormalized is called as _________(a) Unnormalization(b) Denormalization(c) Renormalization(d) AnnormalizationThe question was posed to me during a job interview.My query is from Normal Forms topic in section Relational Database Design of RDBMS
What is unique role assumption?(a) The attribute name has a unique meaning in the database(b) The attributes are all unique(c) No two tuples have even a single same value in a relation(d) None of the mentionedThis question was addressed to me during a job interview.Question is taken from Normal Forms topic in section Relational Database Design of RDBMS
Which of the following is not a process of generating a good relational schema?(a) Converting ER diagrams to relational schema(b) Decomposing the relational schema while satisfying functional dependencies(c) Joining multiple relations together to form a single relation containing all the attributes(d) A design of relations which is then tested and modified to satisfy given normal formsThis question was addressed to me in class test.My doubt stems from Normal Forms in section Relational Database Design of RDBMS

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment