Which of the following is not a condition for X→Y in Boyce codd normal form?(a) X →Y is trivial(b) X is the superkey for the relational schema R(c) Y is the superkey for the relational schema R(d) All of the mentionedThe question was asked in examination.This intriguing question comes from Decomposition Using Functional Dependencies topic in portion Relational Database Design of RDBMS

Which of the following is not a condition for X→Y in Boyce codd norm

1.	Which of the following is not a condition for X→Y in Boyce codd normal form?(a) X →Y is trivial(b) X is the superkey for the relational schema R(c) Y is the superkey for the relational schema R(d) All of the mentionedThe question was asked in examination.This intriguing question comes from Decomposition Using Functional Dependencies topic in portion Relational Database Design of RDBMS
Answer» Right option is (c) Y is the superkey for the RELATIONAL schema R Easiest explanation: Y does not need to be a superkey of the relation for the given functional dependency to SATISFY BCNF. X→ Y must be trivial and X must be the superkey of the relation R.

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