Determine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form. OFFICE (OFFICE_NUM, OFFICE_NAME, (ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY_RENT, OWNER_NUM))
Determine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form. OFFICE (OFFICE_NUM, OFFICE_NAME, (ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY_RENT, OWNER_NUM))
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
100%
Determine the functional dependencies that exist in the following table and then convert this table to an equivalent collection of tables that are in third normal form.
OFFICE (OFFICE_NUM, OFFICE_NAME, (ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY_RENT, OWNER_NUM))
Transcribed Image Text:Answer each of the following questions using the StayWell Student Accommodation data shown in Figures 1-4 through 1-9 in Module 1.
OFFICE
OFFICE_NUM OFFICE_NAME
FIGURE 1-4 Sample data for StayWell offices
MO100
PA101
AK102
C0103
KO104
OWNER
OWNER_NUM LAST_NAME FIRST NAME
Elle-May
Makesh
|51105
StayWell-Columbia City
StayWell-Georgetown
BU106
RE107
LO108
BI109
JO110
11
Moore
Patel
Aksoy
Cole
Kowalczyk
Sims
Burke
Redman
Lopez
Bianchi
Jones
2
7431 S. Bishop St.
527 Primrose Rd.
613 Old Pleasant St.
7681 Fordham St.
9856 Pumpkin Hill Ln.
7990 Willow Dr.
730 Military Ave.
FIGURE 1-5 Sample data for the owners of StayWell properties
1
1
2
Ceyda
Meerab
PROPERTY
PROPERTY ID OFFICE_NUM ADDRESS
Jakub
Haydon
Ernest
Seth
2
2
2
ADDRESS
AREA
1135 N. Wells Avenue Columbia City Seattle WA
986 8. Madison Rd
Georgetown
Seattle WA
Janine
Nicole
Ammarah
ADDRESS
CITY
8006 W. Newport Ave. Reno
7337 Sheffield St.
411 Griffin Rd.
9486 Circle Ave.
30 West Thomas Rd.
782 Queen Ln.
9800 Sunbeam Ave.
105 North Illinois Rd.
887 Vine Rd.
8 Laurel Dr.
447 Goldfield St.
594 Leatherwood Dr.
504 Windsor Ave.
891 Alton Dr.
Plumbing
Heating
Painting
Electrical systems
9531 Sherwood Rd.
2 Bow Ridge Ave.
FIGURE 1-6 Sample data for StayWell properties
SERVICE_CATEGORY
CATEGORY_NUM CATEGORY_DESCRIPTION
2
1
1
1
2
2
2
CITY STATE ZIP CODE
1
1
1
2
Seattle
Seattle
WA
Olympia
Bellingham WA
Portland
Twin Falls
Seattle
Everett
New York
Seattle
STATE ZIP CODE
NV
WA
WA
SQR_FT BDRMS FLOORS MONTHLY RENT OWNER NUM
1,400 BU106
1,900 AK102
1,200 BI109
1,650 KO104
1,160 81105
2,050 MO100
1,600 3
2,100 4
1,005 2
1,750 3
1,125 2
2,125 4
1,675 3
2,700 5
700 2
1,300
1,075 2
1,400 3
98118
98108
OR
ID
WA
WA
NY
WA
89508
98119
98131
96506
98226
97203
83303
98119
98213
10005
98126
1,700 CO103
2,750 KO104
1,050 PA101
1,600 LO 108
1,100 JO110
1,700 RE107
Carpentry
Furniture replacement
FIGURE 1-7 Sample category data for StayWell maintenance services
Transcribed Image Text:SERVICE REQUEST
SERVICE PROPERTY CATEGORY OFFICE
NUMBER
HUM
5
7
8
9
10
12
13
14
15
16
17
18
19
20
FIGURE 18 Sample service request category
21
22
23
RESIDENTS
RESIDENT_ID FIRST NAME SURNAME
Albie
Tariq
Ismail
Callen
24
25
26
28
29
30
31
32
33
34
35
36
37
Milosz
Ashanti
Randy
Aisling
Monique
Amara
Rosalie
Carina
Valentino
Kaylem
Alessia
Tyrone
Constance.
Eamonn
Misbah
Gianluca
Elinor
Ray
Damon
Dawood
2
Dora
Leroy
Tamila
Amelia
Zarah
Sara
Delilah
DESCRIPTION
The second
bedroom
spetsin is n
heating e
Dougle
Tahir
Mila
Glenn
Zayn
Awk
The back
New F
bedroom (There i
(kengel
Shower is
Beating win
O'Ryan
Khan
Salib
Beck
Kitchen k
property.
Now Open
Britton
Ortega
Kent
Wagner
Galvan
Fleming
Bain
Yacob
Esposito
Lake
Rosas
Caldwell
STATUS
Busby
Harris
Stokes
Hess
Sanders
Byers
Farrow
Roy
Col
nghu
McDaniel
Halabi
Zhikin
Servis
Polansky
2
Lucas
2
Woodrue 2
Lawrence
3
French
3
Dejsuwan 4
Blackmore
4
Priddes
wered
Ph
Tole des
1
1
1
2
PROPERTY ID
4
5
5
6
6
6
6
7
7
7
8
8
8
8
8
9
9
10
10
10
EST SPENT NEXT
HOURS HOURS SERVICE DATE
11
11
12
12
12
10
1
Donovan
Fowler
FIGURE 1-9 Sample data for StayWell residents
L
0
0
2
0
2
1002/2009
110/2009
10002009
1000/2009
11/12/2009
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY