NEW
Font size
WorksheetsDBMS Quiz 3
Total questions: 10
Worksheet time: 10mins
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
