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?


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 False


True


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.


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


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