Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

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)

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
expand button
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
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
expand button
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
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education