SQL Chapter 2 Quiz
True
An unnormalized relation is a relation that contains repeating groups.
True
Because there is a one-to-many relationship between sales reps and customers n the Premiere Products database, One sales rep can be associated with zero, one, or more customers.
True
Each column in a table of a relational database should have a distinct name.
updates
The four categories of update anomalies are additions, deletions, inconsistent data, and ______.
database design
The process of determining the particular tables and columns that will comprise a database is known as ____.
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 also know the pay rate.
parentheses
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 ____.
nonkey
A ____ column is a column that is not part of the primary key.
False
A determinant is any column (or collection of columns) that determines another table.
column
A field is another term for a(n) ____.
False
A programmer interviews users, examines existing and proposed documents, and examines organizational policies to determine exactly the type of data needs the database must support
tuple
A record is another term for a(n) ____.
False
A relation is essentially a three-dimensional table.
first normal form
A relation is in ____ if it does not contain any repeating groups.
relations
A relational database is a collection of ________.
Entities
A relationship is an association between _______.
False
A table is in third normal form if it is in second normal form and no nonkey column is dependent on only a portion of the primary key.
REPEATING
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.
False
A tabular database is a collection of tables.
All of the above (attribute, field, column)
A(n) ____ is a characteristic or property of an entity.
tuple
A(n) ____ is another name for a record or a row.
relationship
A(n) ____ is the association between entities.
NONKEY
A(n) _____ column is a column that is not part of the primary key.
ENTITY
A(n) ______ is a person, place, object, event, or idea for which you want to store and process data.
RELATIONSHIP
A(n) ________ is the association between entities.
PRIMARY
The _______ key of a table (relation) is the column or collection of columns that uniquely identifies a given row in that table.
dependency
Any column (or collection of columns) that determines another column is called a(n) ____.
one-to-many
At Premiere Products, there is a ____ relationship between sales reps and customers.
False
Columns are sometimes called tuples.
True
The definition for a primary key really defines a candidate key as well
second
If the primary key of a table contains only a single column, the table is automatically in _____ normal form.
True
In a relation, all values in a column are values of the same attribute.
immaterial
In a relation, the order of the rows and columns is ____________________
row, record, tuple
In a relational database each ____ should be unique.
functionally dependent
In a relational database, column B is ______ on another column A, it at any point in time a value for A determines a single value for B.
True
In a relational database, relationships are implemented by having common columns in two or more tables.
False
In a relational database, two columns can be identical
rectangles
In an entity-relationship (E-R) diagram, ____ are used to represent an entity.
lines
In an entity-relationship (E-R) diagram, one-to-many relationships between entities are drawn as ____ .
RELATIONSHIPS
In one style of entity-relationship (E-R) diagrams, diamonds are used to describe _____.
third normal form
In this text, Boyce-Codd normal form is the same as ____.
False
Normalization is done before creating the database design
qualify
When you write a column in the format CUSTOMER.REP_NUM, you say that you _____ the column name
Order_num and Part_num
Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?
(.)
Which of the following symbols is used to qualify column names?
update anomalies
____ can occur when there is a column in a table that is dependent on only a portion of the primary key.
inconsistent data
____ is one of the categories of update anomalies.
redundancy
____ is the duplication of data.
concatenation
____ is the formal term for combining two or more columns to form a primary key.
BOYCE-CODD NORMAL FORM (BCNF)
________ is another name given to third normal form in this text.