Use the following table to answer questions 1 and 2:
Table: BOOK-DETAIL
|
BookID**
|
GenreID
|
GenreDesc
|
Price
|
|
1
|
1
|
Gardening
|
25.99
|
|
2
|
2
|
Sports
|
12.99
|
|
3
|
1
|
Gardening
|
10.00
|
|
4
|
3
|
Travel
|
14.99
|
|
5
|
2
|
Sports
|
17.99
|
1. What, if any normalization error is present in the table?
a. None
b. First Normal Form
c. Second Normal Form
d. Third Normal Form
2. Describe or illustrate how you would correct the normalization error, if one is present.
Use the following table to answer questions 3 and 4:
Table: BOOKS
|
Book-Code**
|
Title
|
Price
|
Pub-Code**
|
Publisher
|
City
|
|
0180
|
Shyness
|
7.65
|
BB
|
Bantam Books
|
Boston
|
|
0189
|
Kane and Able
|
5.55
|
PB
|
Pocket Books
|
New York
|
|
0200
|
The Stranger
|
8.75
|
BB
|
Bantam Books
|
Boston
|
|
0378
|
The Dunwich Horror
|
19.75
|
PB
|
Pocket Books
|
New York
|
|
079X
|
Smokescreen
|
4.55
|
PB
|
Pocket Books
|
New York
|
3. What, if any normalization error is present in the table?
a. None
b. First Normal Form
c. Second Normal Form
d. Third Normal Form
4. Describe or illustrate how you would correct the normalization error, if one is present.
Use the following table to answer questions 5 and 6:
Table: PRODUCT
|
ProductID**
|
Color
|
Price
|
|
1
|
Red, Green
|
15.99
|
|
2
|
Yellow
|
13.99
|
|
3
|
Green
|
22.99
|
|
4
|
Yellow, Blue
|
17.50
|
|
5
|
Red
|
19.99
|
5. What, if any normalization error is present in the table?
a. None
b. First Normal Form
c. Second Normal Form
d. Third Normal Form
6. Describe or illustrate how you would correct the normalization error, if one is present.
Use the following table to answer questions 7 and 8:
Table: PURCHASE-DETAIL
|
CustomerID**
|
StoreID**
|
StoreLocation
|
|
1
|
1
|
Los Angeles
|
|
1
|
3
|
San Francisco
|
|
2
|
1
|
Los Angeles
|
|
3
|
2
|
New York
|
|
4
|
3
|
San Francisco
|
7. What, if any normalization error is present in the table?
a. None
b. First Normal Form
c. Second Normal Form
d. Third Normal Form
8. Describe or illustrate how you would correct the normalization error, if one is present.
Use the following table to answer questions 9 and 10:
Table: BOOK-LOCATION
|
BookID**
|
BranchID**
|
Quantity-on-Hand
|
|
1
|
5W
|
4
|
|
1
|
3E
|
6
|
|
2
|
5W
|
3
|
|
3
|
5W
|
5
|
|
3
|
2S
|
4
|
9. What, if any normalization error is present in the table?
a. None
b. First Normal Form
c. Second Normal Form
d. Third Normal Form
10. Describe or illustrate how you would correct the normalization error, if one is present.