Task:
Hager
Realty has the below table for beach house rentals (with associated functional
dependencies). What level of normalization is the table in? (the best level it
is in). Produce a new design that is in 3NF, and show all of the records in the resulting tables.
|
Agent |
House |
Renter |
Week |
Price |
Agent Name |
Agent Phone |
Renter Name |
Bedrooms |
Blocks From
Beach |
|
1 |
505 |
1001 |
1 |
800 |
Wilson |
x3145 |
Redmond |
4 |
2 |
|
5 |
512 |
1003 |
1 |
1500 |
Brewer |
x9091 |
Phillips |
3 |
0 |
|
8 |
555 |
1005 |
2 |
750 |
Cline |
x5656 |
Wiley |
4 |
3 |
|
1 |
511 |
1007 |
2 |
600 |
Wilson |
x3145 |
Munson |
3 |
3 |
|
12 |
505 |
1011 |
2 |
900 |
Hart |
x2020 |
Hanson |
4 |
2 |
|
1 |
512 |
1013 |
2 |
1600 |
Wilson |
x3145 |
Schaub |
3 |
0 |
|
5 |
590 |
1015 |
3 |
1350 |
Brewer |
x9091 |
Dailey |
4 |
1 |
|
1 |
555 |
1005 |
3 |
850 |
Wilson |
x3145 |
Wiley |
4 |
3 |
|
8 |
512 |
1013 |
3 |
1700 |
Cline |
x5656 |
Schaub |
3 |
0 |
|
1 |
505 |
1017 |
3 |
1000 |
Wilson |
x3145 |
Gale |
4 |
2 |
|
5 |
590 |
1015 |
4 |
1650 |
Brewer |
x9091 |
Dailey |
4 |
1 |
|
1 |
512 |
1019 |
4 |
1800 |
Wilson |
x3145 |
Stewart |
3 |
0 |
|
12 |
505 |
1017 |
4 |
1100 |
Hart |
x2020 |
Gale |
4 |
2 |
|
12 |
511 |
1001 |
4 |
800 |
Hart |
x2020 |
Redmond |
3 |
3 |
PK: House,
Week
Functional
Dependencies:
House, Week è Price
House, Week è Agent
House, Week è Renter
House è Bedrooms
House è Blocks from Beach
Agent è Agent Name
Agent è Agent Phone
Renter è Renter Name