If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.(a) A many-to-many relationship set(b) A multivalued attribute of an entity set(c) A one-to-many relationship set(d) Both A many-to-many relationship set and A multivalued attribute of an entity setThis question was posed to me in an internship interview.Query is from Multivalued Dependencies in division Normalization of Database Management

If a multivalued dependency holds and is not implied by the correspond

1.	If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources.(a) A many-to-many relationship set(b) A multivalued attribute of an entity set(c) A one-to-many relationship set(d) Both A many-to-many relationship set and A multivalued attribute of an entity setThis question was posed to me in an internship interview.Query is from Multivalued Dependencies in division Normalization of Database Management
Answer» Right option is (d) Both A many-to-many relationship SET and A multivalued ATTRIBUTE of an entity set For explanation: For a many-to-many relationship set each RELATED entity set has its own schema and there is an additional schema for the relationship set. For a multivalued attribute, a separate schema is created consisting of that attribute and the primary key of the entity set.

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