Ch.11

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

FALSE

A tuple is a property of an entity

FALSE - Attribute

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.

FALSE - Setermine

In designing a database, you must first identify the fields in the database and then the tables.

False

A foreign key is a field in one table whose values are required to match the primary key of another table

TRUE

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

TRUE

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

TRUE

In Access, the terms record and field are used to describe rows and columns in a relation.

TRUE

Relationships are implemented through matching fields.

TRUE

Rows in a table often are called records.

TRUE

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered an alternate key.

TRUE

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

TRUE

The goal of normalization is to take a table or collection of tables and produce a new collection of tables that represents the same information but is free of problems.

TRUE

The primary key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.

TRUE

You can use an entity-relationship diagram (ERD) to diagram a database design.

TRUE

The most common normal forms are ____.

a. 1NF b. 2NF c. 3NF

What will be the primary key of the table in first normal form?

a. Product and AccountNum

How can she convert this unnormalized table to a table in first normal form?

a. Remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group.

Columns in a table often are called fields or ____

a. attributes

When creating a database, a(n) ____ is represented as a table.

a. entity

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

a. matching

Columns in a table often are called ____.

b. attributes, c. fields

An organization can use either Social Security Number or Employee ID as the primary key for a table. These two fields are considered ____ keys.

b. candidate

The attributes of an entity become the ____ in the table.

b. columns

A(n) ____ key is a field in one table whose values are required to match the primary key of another table.

b. foreign

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

b. nonkey

When duplicate field names exist in a database, you need to indicate the field to which you are referring. You do so by writing both the table name and the field name separated by a ____.

b. period

The formal term for a table is ____.

b. relation

A table that contains a repeating group, or multiple entries for a single row, is called a(n) ____ table.

b. unnormalized

If you have already created a database and relationships in Access, the ____ window and corresponding report provide a helpful diagram of the design.

c. Relationships

If an account can be offered many workshops and each workshop is offered to many accounts, there is a(n) ____ relationship between accounts and workshops.

B. many-to-many

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

C. Entity

A dependent key is a field or combination of fields on which all fields in the table are functionally dependent.

FALSE

A field is a dependent field if it is not part of the primary key.

FALSE

A table that contains a repeating group, or multiple entries for a single row, is called a non-standard table.

FALSE

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

FALSE

In a relation, the order of rows is fixed; rows must be in ascending order by primary key

FALSE

Standardization is a process used to make sure a database design is free of potential update, redundancy, and consistency problems.

FALSE

The formal term for a table is tuple.

FALSE

The relationship between account managers and accounts is an example of a one-to-one relationship because one account manager is associated with many accounts, but each account has only one account manager.

False

When you merge entities in a database design, the merged entities automatically will be in third normal form (3NF).

False

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

TRUE

A table is in third normal form (3NF) if it is second normal form (2NF) and if the only determinants it contains are candidate keys.

TRUE

Existing documents, such as purchase orders and procedure manuals, can often furnish helpful information concerning the database design.

True

If an account can be offered many workshops and each workshop is offered to many accounts, there is a many-to-many relationship between accounts and workshops.

True

In a relation, the order of columns is immaterial.

True

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

True

Rows in a table often are called ____.

a. records, d. tuples

A ____ is an association between entities.

a. relationship

____ is(are) used in the shorthand representation of table.

a. underlining, c. parenthesis

In a relational database, each column in a table should have a ____ name and entries in each column should match this column name.

a. unique

____ are update anomalies.

all of the above

How can she convert this table to a table in 3NF? For each determinant that is not a candidate key, remove from the table the fields that depend on this determinant, but do not remove the determinant. Next, create a new table containing all the fields from the original table that depend on this determinant.

b. Finally, make the determinant the primary key of this new table.

A(n) ____ is a collection of relations.

b. relational database

A(n) ____ is a collection of tables.

b. relational database

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

b. systems analysis

In a relational database, each row should be ____.

b. unique

This table is not in 3NF. Why?

c. The table is not in 3NF because one nonkey field determines another nonkey field. PublisherCode determines PublisherName.

Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered a(n) ____ key.

c. alternate

Any field or collection of fields that determines another field is called a(n) ____.

c. determinant

If Account Number ____ Account Name, then Account Name is functionally dependent on Account Number.

c. determines

In a relational database, the order of the rows and the order of the columns are ____.

c. immaterial

The normalization process involves converting tables into various types of ____.

c. normal forms

If one employee is assigned to a project and each project has only one employee working on it, there is a(n) ____ relationship between employees and projects.

c. one-to-one

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

d. Normalization

A(n) ____ is a property of an entity.

d. attribute

A table is in third normal form (3NF) if it is in second normal form and if the only determinants it contains are ____ keys.

d. candidate

The process of determining the particular tables and fields that will make up a database is known as ____.

d. database design

A table is in second normal form (2NF) if it is in first normal form and no ____ field is dependent on only a portion of the primary key.

d. nonkey

There is a ____ relationship between account managers and accounts because one account manager is associated with many accounts but each account is associated with only one account manager.

d. one-to-many

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.

d. parentheses ( )

The ____ key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.

d. primary

When you combine a field name with a table name, you say that you ____ the field names.

d. qualify

In a relational database, you should restrict each position in the table to a single entry, that is, you do not permit multiple entries, often called ____ in the table.

d. repeating groups

Rows in a table often are called records or ____.

d. tuples