Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Figure 2-32 shows data that Garden Glory collects about properties and services.

Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services. Figure 2-32 shows data that Garden Glory collects about properties and services.

Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
icon
Related questions
Question

Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners. They employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.

Figure 2-32 shows data that Garden Glory collects about properties and services.

  1. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate, Description, Amount)
  2. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate)SERVICE (ServiceDate, Description, Amount)
  3. PROPERTY (PropertyID, PropertyName, PropertyType, Street, City, Zip, ServiceDate)
FIGURE 2-32 Sample Data for Garden Glory PropertyName Eastlake Buiding Elm St Apts Jeferson Hill Eastlake Building Eastlake Building Elm St Apts Eastlake Building Type Office Apartment Office Office Office Apartment Office Street 123 Eastlake 4 East Elm 42 West 7th St 123 Eastlake 123 Eastlake 4 East Elm 123 Eastlake ZIP 98119 98223 98040 98119 98119 ServiceDate 5/5/2012 5/8/2012 5/8/2012 5/10/2012 5/12/2012 5/15/2012 5/19/2012 Amount City Seattle Lynnwood Bellevue Seattle Seattle Lynnwood Seattle Description Lawn Mow Lawn Mow Garden Service Lawn Mow Lawn Mow Lawn Mow Lawn Mow 42.50 123.50 53.00 %24 42.50 %24 42.50 98223 123.50 98119 42.50 SSSS
Transcribed Image Text:FIGURE 2-32 Sample Data for Garden Glory PropertyName Eastlake Buiding Elm St Apts Jeferson Hill Eastlake Building Eastlake Building Elm St Apts Eastlake Building Type Office Apartment Office Office Office Apartment Office Street 123 Eastlake 4 East Elm 42 West 7th St 123 Eastlake 123 Eastlake 4 East Elm 123 Eastlake ZIP 98119 98223 98040 98119 98119 ServiceDate 5/5/2012 5/8/2012 5/8/2012 5/10/2012 5/12/2012 5/15/2012 5/19/2012 Amount City Seattle Lynnwood Bellevue Seattle Seattle Lynnwood Seattle Description Lawn Mow Lawn Mow Garden Service Lawn Mow Lawn Mow Lawn Mow Lawn Mow 42.50 123.50 53.00 %24 42.50 %24 42.50 98223 123.50 98119 42.50 SSSS
Expert Solution
Step 1

There is not specific question give, So is what I can answer

 

 

Solution A. The functional dependencies that can be identified from the data are The propertyName can uniquely determine TypThe propertyID can uniquely determine propertyName, Type, Street, City, LIP. Description property!D→ Property Name , Type, SThe serviceID uniquely determines The servicelD uniquely determines Description 2) To INF: Since all the attributes are atoSERVICE .FK propertyID references PROPERTY propertyID 4) To 3NF: Now in the PROPRTY table propertyID can determine and proper

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
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 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)
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
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS