FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 12: Database Design

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

Multiple Choice

Review LaterAdd Note

Review Later

_____ is the process of making sure that a database design is free of potential update, redundancy, and consistency problems.

A) Redaction
B) Synchronization
C) Replication
D) Normalization

E) A) and D)
F) None of the above

Correct Answer

verified

Show Answer

Question 52

Short Answer

Review LaterAdd Note

Review Later

Columns in a table often are called fields or ____________________.

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

A(n) _____ is a collection of relations.

To depict the structure of a relational database, you can use a commonly accepted shorthand representation. You write the name of the table and then within _____ list all of the fields in the table.

If the primary key of a table contains only a single field, the table is automatically in ____________________ normal form.

The definition of a relation includes four rules. What are these rules?

If you know that whenever you are given a value for one field, you will be able to determine a single value for a second field, the first field is said to define the second field.

The determination of database requirements is part of a process known as _____.

There is a _____ relationship between business analysts and clients because one business analyst is associated with many clients but each client is associated with only one business analyst.

Critical Thinking Questions Case 11-2 An employee at Regional Books is using the normalization process to analyze her database design. She has created the following Book table: Book ( ISBN , Title, Publisher Code, PublisherName) This table is not in 3NF. Why?

A table is in first normal form (1NF) if it does not contain repeating groups.

A field is a(n) _____ field if it is not part of the primary key.

You always must qualify field names, even if there is no possibility of confusion.

If the primary key of a table contains only a single field, the table is automatically in second normal form (2NF).

If you use the word, Order, for the name of a table, you cannot use SQL to query that table.

Any field or collection of fields that determines another field is called a descendent.

A(n) _____ is like a noun: It is a person, place, thing, or event.

The formal term for a table is tuple.

Many-to-many relationships are implemented through an additional table that contains _____ fields for both of the related tables.

The accompanying figure shows the Access relationship diagram for the Camashaly Design database. A key symbol appearing in front of a field name means the field is the ____________________ key.