For schemas derived from strong entity sets, the _______ of the entity set serves as the primary key of the resulting schema(a) First attribute(b) Primary key(c) Foreign key(d) None of the mentionedThe question was asked during an interview.My question is from Reduction to Relational Schema in section Database Design and the ER Model of RDBMS

For schemas derived from strong entity sets, the _______ of the entity

1.	For schemas derived from strong entity sets, the _______ of the entity set serves as the primary key of the resulting schema(a) First attribute(b) Primary key(c) Foreign key(d) None of the mentionedThe question was asked during an interview.My question is from Reduction to Relational Schema in section Database Design and the ER Model of RDBMS
Answer» Correct choice is (b) Primary key To elaborate: For schemas derived from STRONG entity sets, the primary key of the entity SET SERVES as the primary key of the resulting schema. This is because the primary KEYS are to be preserved as they are unique.

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