Q. State true or false: The schema for the relationship set linking a weak entity set to its corresponding strong entity set is redundant.

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

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

View solution

Q. Weak entity set is represented as

View solution

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

View solution

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

View solution

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.

View solution

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

View solution

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

View solution

Q. A window into a portion of a database is

View solution