Reference no: EM13839312

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.