When an entity instance must be a member of only one sub-type, it is which of the following?(a) Disjoint with total specialization(b) Disjoint with partial specialization(c) Overlap with total specialization(d) Overlap with partial specializationThis question was addressed to me during an online interview.This intriguing question originated from The Atomic Data Models and Business Models in section Planning Oracle Applications of Oracle

When an entity instance must be a member of only one sub-type, it is w

1.	When an entity instance must be a member of only one sub-type, it is which of the following?(a) Disjoint with total specialization(b) Disjoint with partial specialization(c) Overlap with total specialization(d) Overlap with partial specializationThis question was addressed to me during an online interview.This intriguing question originated from The Atomic Data Models and Business Models in section Planning Oracle Applications of Oracle
Answer» <html><body><p>The correct option is (a) Disjoint with <a href="https://interviewquestions.tuteehub.com/tag/total-711110" style="font-weight:bold;" target="_blank" title="Click to know more about TOTAL">TOTAL</a> specialization<br/><br/>The explanation is: GradStudent (_id_, <a href="https://interviewquestions.tuteehub.com/tag/name-573193" style="font-weight:bold;" target="_blank" title="Click to know more about NAME">NAME</a>, gradStuff) UndergradStudent (_id_, name, underGradStuff) Professor (_id_, name) <a href="https://interviewquestions.tuteehub.com/tag/teaches-1240036" style="font-weight:bold;" target="_blank" title="Click to know more about TEACHES">TEACHES</a>(_prof_id_, _stud_id_)<br/><br/>Considering that the relational database above is meant to represent total disjoint specialization, i.e. there is no table Student but rather two completely separate ones, when writing this in SQL in <a href="https://interviewquestions.tuteehub.com/tag/order-1138220" style="font-weight:bold;" target="_blank" title="Click to know more about ORDER">ORDER</a> to implement the database, how would I fetch the student id for the Teaches table? I cannot figure out how to <a href="https://interviewquestions.tuteehub.com/tag/make-546668" style="font-weight:bold;" target="_blank" title="Click to know more about MAKE">MAKE</a> a foreign key from two different tables.</p></body></html>

Discussion

No Comment Found

Related InterviewSolutions

An n-array relationship is drawn using which symbol:(a) A diamond(b) A line with arrows showing direction(c) A line without arrows showing direction(d) A rectangleI had been asked this question in a national level competition.I need to ask this question from Attribute, Tuple and Entity topic in division Planning Oracle Applications of Oracle
The relational model is based on the concept that data is organized and stored in two-dimensional tables called _____________(a) Fields(b) Records(c) Relations(d) KeysThe question was asked during an internship interview.Origin of the question is Attribute, Tuple and Entity topic in portion Planning Oracle Applications of Oracle
A ___________ normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.(a) First(b) Second(c) Third(d) FourthI have been asked this question by my school principal while I was bunking the class.This intriguing question originated from Attribute, Tuple and Entity in division Planning Oracle Applications of Oracle
An aggregation association is drawn using which symbol:(a) a line which loops back onto the same table(b) small closed diamond at the end of a line connecting two tables(c) small open diamond at the end of a line connecting two tables(d) small triangle at the end of a line connecting the aggregated item and multiple component itemsThe question was posed to me during an online exam.I would like to ask this question from Attribute, Tuple and Entity in portion Planning Oracle Applications of Oracle
Identify the criteria for designing database from the point of view of user(a) No redundancy(b) No inapplicable attributes(c) Uniformity in naming & definitions of the data items(d) All of the MentionedI had been asked this question during an internship interview.My question comes from Attribute, Tuple and Entity in division Planning Oracle Applications of Oracle
Which of the following is record based logical model?(a) Network Model(b) Object oriented model(c) E-R Model(d) None of the MentionedThe question was asked during an interview.My enquiry is from Attribute, Tuple and Entity topic in portion Planning Oracle Applications of Oracle
E-R model uses this symbol to represent weak entity set ?(a) Dotted rectangle(b) Diamond(c) Doubly outlined rectangle(d) None of the MentionedThe question was posed to me in examination.My question is from Attribute, Tuple and Entity in division Planning Oracle Applications of Oracle
A relational database developer refers to a record as(a) A criteria(b) A relation(c) A tuple(d) An attributeI had been asked this question in a national level competition.I want to ask this question from Attribute, Tuple and Entity in portion Planning Oracle Applications of Oracle
The relational model feature is that there(a) is no need for primary key data(b) is much more data independence than some other database models(c) are explicit relationships among records(d) are tables with many dimensionsThe question was asked during an interview for a job.My question is based upon Attribute, Tuple and Entity topic in division Planning Oracle Applications of Oracle
In an E-R diagram an entity set is represent by a(a) Rectangle(b) Ellipse(c) Diamond box(d) CircleI got this question during an interview.My doubt is from Attribute, Tuple and Entity topic in portion Planning Oracle Applications of Oracle

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment