Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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)

Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section5.3: Pivottable And Pivotchart
Problem 6QC
See similar textbooks
icon
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)

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: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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Basic sql queries
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
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage
SEE MORE TEXTBOOKS