adplus-dvertising
frame-decoration

Question

Statement 1: We can create foreign key constraints on relational schema derived from ER diagram
Statement 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 false

Posted under DBMS

Answer: (c).Statement 1 is true and Statement 2 is false

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Statement 1: We can create foreign key constraints on relational schema derived from ER diagram Statement 2: Relational schema cannot be derived from an ER diagram

Similar Questions

Discover Related MCQs

Q. Which of the following can affect the placement of the relationship attributes?

Q. The process of designating sub groupings within the entity set is called as _______

Q. State true or false: Specialization can be applied only once

Q. Which of the following is the specialization that permits multiple sets

Q. The similarities between the entity set can be expressed by which of the following features?

Q. Higher level entity sets are designated by the term _________

Q. State true or false: The attributes of the higher level entity sets are inherited by the attributes of the lower level entity sets

Q. Which of the following is not a generalization constraint?

Q. Condition defined generalization constraint is also said to be ________

Q. If each higher level entity belongs to the lower level entity, then what kind of generalization is it?

Q. ________ is an abstraction through which relationships are treated as higher level entities

Q. Weak entity set is represented as

Q. If you were collecting and storing information about your music collection, an album would be considered a(n) _____

Q. What term is used to refer to a specific record in your music database; for instance; information stored about a specific album?

Q. Let us consider phone_number ,which can take single or several values . Treating phone_numberas an _________ permits instructors to have several phone numbers (including zero) associated with them.

Q. The total participation by entities is represented in E-R diagram as

Q. Which of the following is a low level operator?

Q. A window into a portion of a database is

Q. The entity set person is classified as student and employee. This process is called _________

Q. Which relationship is used to represent a specialization entity ?