ch2
______________________________ is another name given to third normal form in this text.
Boyce-Codd
____ is the formal term for combining two or more columns to form a primary key.
Concatenation
A matrix is the association between entities. T/F
False
A primary key always comprises a single column. T/F
False
A relation is a characteristic or property of an entity.
False
A secondary key is the unique identifier for a table.
False
A tabular database is a collection of tables. T/F
False
Columns are sometimes called tuples. T/F
False
Normalization is done before creating the database design. T/F
False
You can determine functional dependence by viewing sample data. T/F
False
Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, ITEM_NUM, NUM_ORDERED, QUOTED_PRICE) table?
ORDER_NUM and ITEM_NUM
____ is the duplication of data.
Redundancy
An unnormalized relation is a relation that may contain repeating groups. T/F
True
Because there is a one-to-many relationship between sales reps and customers in the TAL Distributors database, one sales rep can be associated with zero, one, or more customers. T/F
True
If a table contained both employee numbers and Social Security numbers, both columns would be referred to as candidate keys. T/F
True
In a relation, all values in a column are values of the same attribute. T/F
True
In a relation, the order of the rows and columns is immaterial. T/F
True
In a relational database, each entity has its own table. T/F
True
It is possible for the computer to generate values that are used as the primary key column. T/F
True
The definition for a primary key really defines a candidate key as well. T/F
True
The statement "A sales rep's pay class functionally determines his or her pay rate" means that if you know the pay class, you can determine the pay rate. T/F
True
When you convert an unnormalized table to a table in first normal form, the primary key of the table in first normal form is usually the concatenation of at least two columns. T/F
True
You can indicate a table's primary key by underlining the column or collection of columns that comprises the primary key for each table in the database. T/F
True
A(n) ____ is a property of an entity.
attribute, column, field (all of the above)
A field is another term for a(n) ____.
column
Which of the following symbols is used to qualify column names?
comma(,)
The process of determining the particular tables and columns that will comprise a database is known as ____.
database design
Any column (or collection of columns) that determines another column is called a(n) ____.
determinant
If B is functionally dependent on A, you also can say that A functionally ____________________ B.
determines
A relationship is an association between ____________________.
entities
A relation is in _______ if it does not contain any repeating groups
first normal form
____ is one of the categories of update anomalies.
inconsistent data
In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as ____.
lines
In one style of entity-relationship (E-R) diagrams, the letter n is used to represent the ____________________ side of a relationship.
many
A ____ column is a column that is not part of the primary key.
nonkey
At TAL Distributors, there is a ____ relationship between sales reps and customers.
one-to-many
There is a commonly accepted shorthand representation to show the structure of a relational database: After the name of the table, all the columns in the table are listed within a set of ____.
parentheses
When you write a column in the format CUSTOMER.REP_NUM, you say that you ____________________ the column name.
qualify
In an entity-relationship (E-R) diagram, ____ are used to represent an entity.
rectangles
A(n) ____ is the association between entities.
relationship
A(n) ____________________ is the association between entities.
relationship
A table's design should be as simple as possible; you should restrict each position in a table to a single entry by not allowing multiple entries (called a(n) ____________________ group) in an individual location in the table.
repeating
A record is another term for a(n)
row
A relational database is a collection of ____________________.
tables
In this text, Boyce-Codd normal form is the same as ____.
third normal form
A(n) ____________________ is another name for a record or a row.
tuple
In a relational database each ____ should be unique.
tuple, row, record (all of the above)
____ can occur when there is a column in a table that is dependent on only a portion of the primary key.
update anomalies
The four categories of update anomalies are additions, deletions, inconsistent data, and ____________________.
updates