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.
Prepare a data dictionary
: In this lab, you will prepare a Data Dictionary based on the list of elements. Also, your task will be determined the tables, their relationships, primary and foreign keys. Based on this analysis, you will create Database Schema, relational tables..
|
If we reject the null hypothesis
: If we reject the null hypothesis, H0: p=0 , what can we conclude about the population correlation coefficient? A. it is zero b. it could be zero
|
A randomly selected person is a runner
: 1) The probability that a randomly selected person has high blood pressure (the event H) is P(H) = 0.4 and the probability that a randomly selected person is a runner (the event R) is P(R) = 0.5. The probability that a randomly selected person has hi..
|
Prevalence of hyperglycemia
: A recent study reported that the prevalence of hyperlipidemia (defines as total cholesterol over 200) is 30 % in children 2 to 6 years old of age. If 12 children are analyzed. a) What is the probability that at least 3 are hyperlipidemia? b) What is ..
|
What if any normalization error is present in the table
: What, if any normalization error is present in the table? a. None b. First Normal Form c. Second Normal Form d. Third Normal Form Describe or illustrate how you would correct the normalization error, if one is present.
|
Feasibility of providing a dental insurance plan
: The personnel department of a large corporation wants to estimate the family dental expenses of its employees to determine the feasibility of providing a dental insurance plan. There are a total of 2,931 employees at the corporation.
|
Interpret these banks credit quality over 2006-2014
: What is the difference between lending to individual borrowers via a residential home mortgage compared to other types of consumer lending
|
Database management and applications
: What errors prevent the table displayed above from being first normal form compliant? Bring the table(s) into first normal form compliance without loss of any data. Identify primary and foreign keys (when present) for all tables.
|
What would the mean and the variance equal
: Measured the tail lengths of 250 cats, and found that the average length is 28 cm and the variance is 75 cm2. If these tail lengths are normally distributed, (A) what would the mean and the variance equal if we multiplied each tail length by three? (..
|