The primary key of the representation of a weak entity set consists of the primary key of the strong entity set and the _______(a) Discriminator of the weak entity set(b) Foreign key(c) Primary key of all the other entity sets(d) All the attributes of the weak entity setThis question was posed to me in an online interview.This question is from Reduction to Relational Schema topic in portion Database Design and the ER Model of RDBMS

The primary key of the representation of a weak entity set consists of

1.	The primary key of the representation of a weak entity set consists of the primary key of the strong entity set and the _______(a) Discriminator of the weak entity set(b) Foreign key(c) Primary key of all the other entity sets(d) All the attributes of the weak entity setThis question was posed to me in an online interview.This question is from Reduction to Relational Schema topic in portion Database Design and the ER Model of RDBMS
Answer» Right choice is (a) Discriminator of the weak ENTITY set The best I can explain: The PRIMARY key of the REPRESENTATION of a weak entity set consists of the primary key of the STRONG entity set and the discriminator of the weak entity set.

Discussion

No Comment Found

Related InterviewSolutions

________ is an abstraction through which relationships are treated as higher level entities(a) Creation(b) Superseding(c) Attribute separation(d) AggregationI had been asked this question during an online exam.My enquiry is from Extended E-R Features topic in section Database Design and the ER Model of RDBMS
If each higher level entity belongs to the lower level entity, then what kind of generalization is it?(a) Modal generalization(b) Partial generalization(c) Total generalization(d) None of the mentionedThe question was asked in final exam.Question is taken from Extended E-R Features in chapter Database Design and the ER Model of RDBMS
Condition defined generalization constraint is also said to be ________(a) Attribute defined(b) Constraint defined(c) Value defined(d) UndefinedI have been asked this question in final exam.Enquiry is from Extended E-R Features in section Database Design and the ER Model of RDBMS
Which of the following is not a generalization constraint?(a) Condition-defined(b) User defined(c) Disjoint(d) Machine definedI have been asked this question by my school teacher while I was bunking the class.I want to ask this question from Extended E-R Features topic in section Database Design and the ER Model of RDBMS
State true or false: The attributes of the higher level entity sets are inherited by the attributes of the lower level entity sets(a) True(b) FalseThis question was posed to me by my college director while I was bunking the class.The origin of the question is Extended E-R Features topic in section Database Design and the ER Model of RDBMS
Higher level entity sets are designated by the term _________(a) Sub class(b) Super class(c) Parent class(d) Root classThe question was asked in exam.This is a very interesting question from Extended E-R Features in portion Database Design and the ER Model of RDBMS
The similarities between the entity set can be expressed by which of the following features?(a) Specialization(b) Generalization(c) Uniquation(d) InheritanceThis question was posed to me in class test.My enquiry is from Extended E-R Features topic in division Database Design and the ER Model of RDBMS
Which of the following is the specialization that permits multiple sets(a) Superclass specialization(b) Disjoint specialization(c) Overlapping specialization(d) None of the mentionedThe question was posed to me in examination.The above asked question is from Extended E-R Features topic in portion Database Design and the ER Model of RDBMS
State true or false: Specialization can be applied only once(a) True(b) FalseThis question was posed to me by my school principal while I was bunking the class.My query is from Extended E-R Features in portion Database Design and the ER Model of RDBMS
The process of designating sub groupings within the entity set is called as _______(a) Specialization(b) Division(c) Aggregation(d) FinalizationThe question was asked in a job interview.This interesting question is from Extended E-R Features topic in chapter Database Design and the ER Model of RDBMS

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment