Statement 1: We can create foreign key constraints on relational schema derived from ER diagramStatement 2: Relational schema cannot be derived from an ER diagram(a) Both the statements are true(b) Both the statements are false(c) Statement 1 is true and Statement 2 is false(d) Statement 2 is true and statement 1 is falseThe question was asked in my homework.My doubt is from Reduction to Relational Schema in section Database Design and the ER Model of RDBMS

Statement 1: We can create foreign key constraints on relational schem

1.	Statement 1: We can create foreign key constraints on relational schema derived from ER diagramStatement 2: Relational schema cannot be derived from an ER diagram(a) Both the statements are true(b) Both the statements are false(c) Statement 1 is true and Statement 2 is false(d) Statement 2 is true and statement 1 is falseThe question was asked in my homework.My doubt is from Reduction to Relational Schema in section Database Design and the ER Model of RDBMS
Answer» The correct choice is (c) Statement 1 is true and Statement 2 is false The best explanation: We can create foreign key constraints on relational schema derived from ER diagram and ALSO it is POSSIBLE to derive relational schema from ER DIAGRAMS.

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