DBMS Quiz 3

The function that an entity plays in a relationship is called that entity’s _____________

• Participation

• Position

• Role

• Instance

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

• Single valued

• Multi valued

• Composite

• Derived

The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

• Simple attribute

• Composite attribute

• Multivalued attribute

• Derived attribute

An entity in A is associated with at most one entity in B, and an entity in B is associated with at most one entity in A.This is called as

• One-to-many

• One-to-one

• Many-to-many

• Many-to-one

Which one of the following uniquely identifies the elements in the relation?

• Secondary Key

• Primary key

• Foreign key

• Composite key

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

• Divided rectangles

• Diamonds

• Lines

• Undivided rectangles

What do double line represent in an ER diagram

• They link entity sets to relationship sets

• Total participation of an entity in a relationship set

• Relationship sets linked to weak entity sets

• None of the mentioned

How are roles specified in an ER diagram

• By labelling the rectangles

• By labelling the diamonds

• Roles cannot be specified in an ER diagram

• By labelling the lines

ER Modelling Technique is a

• Top-down technique

• Bottom-Up Technique

• Left to Right

• None of the above

An ________ is a set of entities of the same type that share the same properties, or attributes.

• Entity set

• Attribute set

• Relation set

• Entity model