In this text, Boyce-Codd normal form is the same as _____.
third normal form
3NF
How many tables make up the Premiere Products database?
5
A record is another term for a(n) _____.
row
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.
nonkey
A field is another term for a(n) _____.
column
_____ is the formal term for combining two or more columns to form a primary key.
Concatenation
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 _____.
lines
When designing tables a _____ structure is preferred.
simple
_____ is the duplication of data.
Redundancy
(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
A relation is in _____ if it does not contain any repeating groups.
first normal form
1NF
Each publisher has a _____ that uniquely identifies the publisher at Henry Books.
code
In an entity-relationship (E-R) diagram, _____ are used to represent an entity.
rectangles
A(n) _____ is a characteristic or property of an entity.
attribute
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.
relationship
Each book at Henry Books is uniquely identified with a(n) _____.
code
A two-dimensional table of data is called a:
relation
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?
second
The entity integrity rule states that
no primary key attribute can be null.
A group of fields related to one topic
Record
A group of related records
File
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 form
1NF
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
De-Normalization
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
Normalization
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.
attribute
a _____ the association between entities
relationship
an _____ is like a nousn, it is a person, place, thing, or event.
entity
Author
zlittlerabbit
ID
69495
Card Set
SQL Quiz Chap 1 and 2
Description
SQL, Structured Query Language, Database Quiz Chapter 1 and 2 of A Guide to SQL
