In this text, Boyce-Codd normal form is the same as _____.
third normal form
How many tables make up the Premiere Products database?
A record is another term for a(n) _____.
The ORDERS table consists of the order number, order date, and _____.
A _____ column is a column that is not part of the primary key.
A field is another term for a(n) _____.
_____ is the formal term for combining two or more columns to form a primary key.
The process of determining the particular tables and columns that will comprise a database is known as _____.
In an entity-relationship (E-R) diagram, one to many relationships between entities are drawn as _____.
When designing tables a _____ structure is preferred.
_____ is the duplication of data.
(True or False)
An example of a relationship between categories is the relationship that exists in the Premiere Products database between sales reps and customers.
A relation is in _____ if it does not contain any repeating groups.
first normal form
Each publisher has a _____ that uniquely identifies the publisher at Henry Books.
In an entity-relationship (E-R) diagram, _____ are used to represent an entity.
A(n) _____ is a characteristic or property of an entity.
In a relational database each _____ should be unique.
row, record, tuple
Premiere Products sells _____.
appliances, housewares, and sporting goods
A(n) _____ is the association between entities.
Each book at Henry Books is uniquely identified with a(n) _____.
A two-dimensional table of data is called a:
An attribute (or attributes) that uniquely identifies each row in a relation is called a:
A relation that contains no multivalued attributes, and has nonkey attributes solely dependent on the primary key, but contains transitive dependencies is in which normal form?
The entity integrity rule states that
no primary key attribute can be null.
A group of fields related to one topic
A group of related records
a collumn which values are limited to the values of the primary key which it references.
List and explain the steps of the normalization process
(a) 1NF: Eliminate all repeating values, and identify a primary key or primary composite key.(b) 2NF: Make certain the table is in 1NF, and eliminate any partial dependencies.(c) 3NF: Make certain the table is in 2NF, and remove any transitive dependencies.
Explain Second Normal Form
a table is in 1NF -and no nonkey column (a column that is not part of the primary key) is dependent on only a portion of the primary key.
a table is in ____ when it does not contain a repeating group.
First normal form
What is the most normal of NF's ("Normal Forms")?
3rd Normal Form
How do you achieve Third normal form?
2NF - Look for transitive dependencies (are there non-key attributes that depend on another nonkey attribute?)
bringing back levels of redundancy to increase database performance
the process of eliminating duplicates in a relational database design- converting an entity into tables of progressively smaller degree and cardinality until you reach an optimum level of decomposition
a structure that contains different categories of information and the relationships betwwen these categories.
a collection of tables is
a Relational Database
an ____ is a property of an entity.
a _____ the association between entities
an _____ is like a nousn, it is a person, place, thing, or event.
SQL Quiz Chap 1 and 2
SQL, Structured Query Language, Database Quiz Chapter 1 and 2 of A Guide to SQL