Test: Quiz: ER Diagramming

Section 1

1. On an ER diagram which symbol identifies an attribute as part of a unique identifier. Mark for Review
(1) Points

# (*)

*

o

x





2. Entity names are always plural. True or False? Mark for Review
(1) Points

True

False (*)





3. Which symbol is used to indicate that a particular attribute is optional? Mark for Review
(1) Points

*

o (*)

#

&





4. Entity boxes are drawn as Mark for Review
(1) Points

Soft Boxes (*)

Hard Boxes

Bold Circles

Normal Circles





5. Attributes are written inside the entity to which they belong. True or False? Mark for Review
(1) Points

True (*)

False





6. Consider the recommended drawing conventions for ERD's. Indicate which of the following accurately describes diagramming conventions for entities and attributes: Mark for Review
(1) Points

The * means that an attribute is optional and entity names should be plural verbs

The 'o' means that the attribute is optional and entity names should be plural verbs

The * means that an attribute is mandatory or required and the entity name should be singular (*)

The 'o' means that the attribute is mandatory or required and the entity name should be a singular noun