LEARN MORE...

Home
Documents
July 2021
31
2 Given the following relations, explain what it will take to red

2 Given the following relations, explain what it will take to red

Content type

User Generated

Uploaded By

Nouvanixefvatu

Pages

Showing Page:

1/6

2 Given the following relations, explain what it will take

to reduce them to 2NF and then to 3NF. UNDERLINE all

primary keys in the resulting relation. ITALICIZE all foreign

keys in the resulting relation. If a key is both, then

underline it and italicize it. Notice that you might be

prompted to create a new table, if necessary. Identify the

name of this table and fill in the data appropriately. This

question is worth 25% of the assignment: part a is worth

5%, parts b and c are worth 10% each) Other than the

name of the tables, answers not entered in the tables will

not be graded.

a. Change this SALESPERSON/ORDER table to FIRST

NORMAL FORM (1NF). Use the same data and rearrange

it properly in the blank table below. Hint: in order to do this

properly, you may have to rearrange some of the columns.

Salesperson #

SP Lname

Dept ID

Manager LName

Order #

Order Dt

Order Tot $

134

Katz

003

Davis

0112

10/15/11

$403.00

137

Smith

004

Johnson

0117

10/16/11

Showing Page:

2/6

$135.00

134

Katz

003

Davis

0121

10/16/11

$338.50

Corrected SALESPERSON/ORDER in 1NF

b. Now change the resulting

SALESPERSON/ORDER(your answer above) table to

SECOND NORMAL FORM (2NF).

Corrected SALESPERSON/ORDER in 2NF

New XXXXX Table (replace the XXXX with the correct

name of this table)

New YYYYYY Table (replace the YYYY with the correct

name of this table)

XXXXX Table (replace the XXXX with the correct name of

this table) – note that it is correct that there is one less

column in this version than above

c. Now change the resulting tables (your answer above)

table to THIRD NORMAL FORM (3NF). Only fill in the

necessary attributes in each blank table below (i.e., there

may be more columns in a table then the answer requires)

Corrected SALESPERSON/ORDER in 2NF from above

XXXXX Table (replace the XXXX with the correct name of

this table) – note that it is correct that there is one less

column in this version than above

YYYYYY Table from above (replace the YYYY with the

correct name of this table)

New ZZZZZ Table (replace the ZZZZ with the correct name

Showing Page:

3/6

End of Preview - Want to read all 6 pages?

Access Now

Unformatted Attachment Preview

2 Given the following relations, explain what it will take to reduce them to 2NF and then to 3NF. UNDERLINE all primary keys in the resulting relation. ITALICIZE all foreign keys in the resulting relation. If a key is both, then underline it and italicize it. Notice that you might be prompted to create a new table, if necessary. Identify the name of this table and fill in the data appropriately. This question is worth 25% of the assignment: part a is worth 5%, parts b and c are worth 10% each) Oth er than the name of the tables, answers not entered in the tables will not be graded. a. Change this SALESPERSON/ORDER table to FIRST NORMAL FORM (1NF). Use the same data and rearrange it properly in the blank table below. Hint: in order to do this properly, you may have to rearrange some of the columns. Salesperson # SP Lname Dept ID Manager LName Order # Order Dt Order Tot $ 134 Katz 003 Davis 0112 10/15/11 $403.00 137 Smith 004 Johnson 0117 10/16/11 $135.00 134 Katz 003 Davis 0121 10/16/11 $338.50 Corrected SALESPERSON/ORDER in 1NF b. Now change the resulting SALESPERSON/ORDER(your answer above) table to SECOND NORMAL FORM (2NF). Corrected SALESPERSON/ORDER in 2NF New XXXXX Table (replace the XXXX with the correct name of this table) New YYYYYY Table (replace the YYYY with the correct name of this table) XXXXX Table (replace the XXXX with the correct name of this table) – note that it is correct that there is one less column in this version than above c. Now change the result ...
Purchase document to see full attachment