Thursday, 2 July 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

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...