Test: Section 2 Quiz

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 Quiz
(Answer all questions in this section)

1. The transformation from an ER diagram to a physical design involves Mark for

changing terminology. Primary Unique Identifiers in the ER diagram become
__________ and relationships become ____________.
Review
(1) Points

Primary keys, Foreign keys (*)

Foreign keys, Primary keys

Unique Keys, Primary keys

Foreign keys, mandatory business rules

Correct

2. In a physical data model, a relationship is represented as a combination of: Mark for

(Choose Two)

Review
(1) Points

(Choose all correct answers)

Foreign Key (*)

Primary Key or Unique Key (*)

Check Constraint or Unique Key

Column

Correct

3. In a physical data model, an attribute is represented as a/an Mark for

Review
(1) Points

Instance

Column (*)

Foreign Key

Row

Correct
 4. Flat file databases avoids data duplication. True or False? Mark for

Review
(1) Points

True

False (*)

Correct

5. What does single table refer to? (Choose Two) Mark for

Review
(1) Points

(Choose all correct answers)

A type of database storage method where all of the data elements are
stored on top of each other.
A fully-relational database system like Microsoft's SQL Server or Oracle's
database systems.
Non-relational systems that typically store each table and index in
separate files and often do not support the SQL language. (*)
A database where all of the data is stored in one large table. (*)

Correct

Test: Section 2 Quiz

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 Quiz
(Answer all questions in this section)

6. Unique Identifier has a NULL value for each instance of the entity for the Mark for
lifetime of the instance. True or False

Review
(1) Points

True

False (*)

Correct

7. What is the purpose of a Unique Identifier? Mark for

 Review
(1) Points

To identify one unique instance of an entity by using one or more

attributes and/or relationships. (*)
To identify a specific row within a table, using one or more columns
and/or foreign keys.
Create an entity that is unlike any other entity aside from itself.

To uniquely determine a table and columns within that table.

Correct

8. Many reasons exist for creating a conceptual model. Choose three Mark for
appropriate reasons from the options below.
(Choose 3)
Review
(1) Points

(Choose all correct answers)

They model functional and informational needs. (*)

They capture the implementation details of the physical model.

They capture current and future needs. (*)

They accurately describe what a physical model will contain. (*)

They model the information flow of data.

Incorrect. Refer to Section 2 Lesson 3.

9. Data models are drawn to show users the actual Data that their new system Mark for
will contain; only Data listed on the Diagram can be entered into the
Database. True or False?
Review
(1) Points

True (*)

False

Correct

10. Which of the following are reasons we create conceptual models? Mark for

Review
(1) Points

It facilitates discussion; a picture is worth a thousand words

It forms important ideal system documentation

It takes into account government regulations and laws

 It forms a sound basis for physical database design

All of the above (*)

Correct
Test: Section 2 Quiz

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Section 2 Quiz
(Answer all questions in this section)

11. A barred relationship is mapped to a primary-key column on the many side, Mark for
just like any other M:1 relationship.

Review
(1) Points

True

False (*)

Correct

12. One-to-One relationships are transformed into Foreign Keys in the tables Mark for
created at either end of that relationship. True or False?

Review
(1) Points

True

False (*)

Incorrect. Refer to Section 2 Lesson 6.

13. In the relational model, data is organized in two-dimensional tables called Mark for
___________.

Review
(1) Points

Relations (*)

Field

Row

Tuples

Correct

14. Each column in a relation is called an entity. True or False? Mark for
 Review
(1) Points

True

False (*)

Incorrect. Refer to Section 2 Lesson 2.

15. In the relational model, relationships between relations or tables are created Mark for
by using?

Review
(1) Points

Foreign Keys (*)

Primary Keys

Composite Keys

Candidate Keys

Correct