SQL Quiz Chap 1 and 2

In this text, Boyce-Codd normal form is the same as _____.

third normal form3NF

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 _____.

customer number

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 _____.

database design

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.
True False


A relation is in _____ if it does not contain any repeating groups.

first normal form1NF

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:

primary key

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.

foreign key

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 form1NF

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 Database

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.