Q. What are composite attributes?

View solution

Q. Let E be an entity set in a relationship set R. If every entity in E participates in at least one relationships in R, Then the participation of E in R is __________

View solution

Q. Let E be an entity set in a relationship set R. If only some entities in E participate in relationships in R, Then the participation of E in R is __________

View solution

Q. State true or false: We cannot specify keys in the Entity-Relationship model

View solution

Q. State true or false: Multiple attributes combined together can be primary keys

View solution

Q. Which of the following is a good database management practice?

View solution

Q. Which of the following symbols represent entity sets in an ER diagram?

View solution

Q. Which of the following symbols represent relationship sets in an ER diagram

View solution

Q. What do double diamonds represent in an ER diagram

View solution

Q. What does a directed line ( → ) from a relationship set to two entity sets mean?

View solution

Q. How are roles specified in an ER diagram

View solution

Q. For schemas derived from strong entity sets, the _______ of the entity set serves as the primary key of the resulting schema

View solution

Q. State true or false: Derived attributes cannot be directly represented in the relational data model

View solution

Q. The primary key of the representation of a weak entity set consists of the primary key of the strong entity set and the _______

View solution

Q. For a binary many to many relationship, the ________ of the participating entity sets becomes the prime attribute

View solution

Q. For a binary one to one relationship, the ________ of the participating entity sets becomes the prime attribute

View solution

Q. For a n-ary relationship set without arrows, the ________ of the participating entity sets becomes the prime attribute

View solution

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