Thursday, July 2, 2015

Entity Relationship Model Quiz

Relational model and Normalization Quiz


1. Cardinality in an ER or UML diagram can specify lower and upper limits to numbers of participants in a relationship. TRUE / FALSE?
    TRUE
    FALSE

2. An Attribute domain is a set of values that might be assigned to an attribute. TRUE/FALSE?
    TRUE
    FALSE

3. An entity that is existence-dependent on some other entity type is strong entity . TRUE/FALSE?
    TRUE
    FALSE

4. A Candidate key is an attribute or set of attributes that uniquely identifies individual occurrences of an entity type. TRUE/FALSE?
    TRUE
    FALSE

5. Degree of a relationship is always 1. TRUE/FALSE?
    TRUE
    FALSE

6. Relationships can’t have attributes . TRUE/FALSE?
    TRUE
    FALSE

7. A Composite key is a candidate key that consists of two or more attributes . TRUE/FALSE?
    TRUE
    FALSE

8. An ER diagram’s purpose is to support a user’s perception of the data and conceal the technical aspects associated with database design . TRUE/FALSE?
    TRUE
    FALSE

9. Entity Relationship diagram aims to facilitate database design. TRUE/FALSE?
    TRUE
    FALSE

10. In a one-to-many relationship, the entity that is on the one side of the relationship is called a parent entity. TRUE/FALSE?
    TRUE
    FALSE

Score =

Correct answers:

No comments:

Post a Comment