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. PROPERTY (PROPERTY_ID, OFFICE_NUM, ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY_RENT, OWNER_NUM, LAST_NAME, FIRST_NAME)
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. PROPERTY (PROPERTY_ID, OFFICE_NUM, ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY_RENT, OWNER_NUM, LAST_NAME, FIRST_NAME)
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
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.
PROPERTY (PROPERTY_ID, OFFICE_NUM, ADDRESS, SQR_FT, BDRMS, FLOORS, MONTHLY_RENT, OWNER_NUM, LAST_NAME, FIRST_NAME)
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
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education