Database Section 2 Quiz

Which of the following is not a goal of ER modeling: -Capture all required information. -Ensure information appears only once. -Locate information in a logical manner -It is acceptable to include information that is derivable.

-It is acceptable to include information that is derivable.

The logical model becomes the blueprint for designing the ________ model -Data Integrity -Data Flow -Network -Physical

-Physical

Which of the following statements about attributes are true? (Choose Two) -They are the primary container for data. -They must be single valued unless they belong to more than one entity. -They describe, qualify, quantify, classify, or specify an entity. -They are often adjectives.

-They describe, qualify, quantify, classify, or specify an entity. -They are often adjectives.

Data Integrity ensures ______ in the information. -no duplication -duplication -anomalies -errors

-no duplication

Which symbol is used to show that a particular attribute is optional? -# -* -o -&

-o

In an ERD, optionality is depicted using __________. -names of relationships -solid or dashed lines -single toe or crows foot -soft boxes

-solid or dashed lines

All entities must be given a new artificial UID. True or False? (t/f)

false

Capturing all required data is the only goal of entity relationship modeling. (t/f)

false

A table must have a primary key. True or False?

true

When mapping a relationship for an ERD diagram both sides of the relationship have to be mapped. (t/f)

true

Which symbol is used to show that a particular attribute is mandatory? -* -o -# -&

-*

People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, etc. A shoe has a color, a size, a style, but may not have a descriptive "number". So, to be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created. -Unrealistic -Structured -Identification -Artificial

-Artificial

One-to-One relationships have _____________ of one to one in both directions. -Cardinality -Optionality -Foreign Keys -Naming

-Cardinality

An ERD is an example of a ______ Model. -Data Integrity -Conceptual -Physical -Network

-Conceptual

A relationship is transformed from logical to physical model using _________. -Candidate Keys -Foreign Keys -Composite Keys -Secondary Keys

-Foreign Keys