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.   Create a sample list of owners and properties. Your list will be similar in structure to that in Figure 1-34 g, but it will concern owners and properties rather than owners and pets. Your list should include, at a minimum, owner name, phone, and billing address, as well as property name, type, and address. B. Describe modification problems that are likely to occur if Garden Glory attempts to maintain the list in a spreadsheet. C. Split the list into tables such that each has only one theme. Create appropriate ID columns. Use a linking column to represent the relationship between a property and an owner. Demonstrate that the modification problems you identified in part B have been eliminated. D. Create a sample list of owners, properties, and services. Your list will be similar to that in Figure 1-35 9. Your list should include the data items from part A as well as the date, description, and amount charged for each service. E. Illustrate modification problems that are likely to occur if Garden Glory attempts to maintain the list from part D in a spreadsheet. F. Split the list from part D into tables such that each has only one theme. Create appropriate ID columns. Use linking columns to represent relationships. Demonstrate that the modification problems you identified in part E have been eliminated.

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...
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.

 

  1. Create a sample list of owners and properties. Your list will be similar in structure to

that in Figure 1-34 g, but it will concern owners and properties rather than owners and pets. Your list should include, at a minimum, owner name, phone, and billing

address, as well as property name, type, and address. B. Describe modification problems that are likely to occur if Garden Glory attempts to

maintain the list in a spreadsheet. C. Split the list into tables such that each has only one theme. Create appropriate ID

columns. Use a linking column to represent the relationship between a property and an owner. Demonstrate that the modification problems you identified in part B have

been eliminated. D. Create a sample list of owners, properties, and services. Your list will be similar to

that in Figure 1-35 9. Your list should include the data items from part A as well as

the date, description, and amount charged for each service. E. Illustrate modification problems that are likely to occur if Garden Glory attempts to

maintain the list from part D in a spreadsheet. F. Split the list from part D into tables such that each has only one theme. Create

appropriate ID columns. Use linking columns to represent relationships. Demonstrate that the modification problems you identified in part E have been eliminated.

A
C
D
E
G
H
K
OwnerFirstName
Marsha
Richard
PetName
2 King
3 Teddy
4 Filo
5 AJ
6 Cedro
7 Woolley
8 Buster
9 Jiddah
PetType
Dog
Cat
PetBreed
Std. Poodle
PetDOB
27-Feb-14 Downs
OwnerPhone
201-823-5467
OwnerLastName
OwnerEmail
Service
Date
17-Aug-16 S
5-Sep-16 S
Charge
65.00
27.50
Marsha Downs@somewhere.com Ear Infection
Richard.James@somewhere.com Nail Clip
Marsha Downs@somewhere.com
Liz.Frier@somewhere.com
Richard James@somewhere.com Nail Clip
Richard James@somewhere com Skin Infection
Miles.Trent@somewhere.com
Hilary Evans@somewere.com
Cashmier
1-Feb-13 James
201-735-9812
Dog
Dog
Cat
Cat
Std. Poodle
Collie Mix
17 Jul-15 Downs
5-May-15 Frier
6-Jun-12 James
Marsha
201-823-5467
201-823-6578
Liz
Richard
Richard
5-May-16 S
5-Sep-16 S
3-Oct-16 S
5-Oct-16 S
One year shots
42.50
Unknown
201-735-9812
27.50
35.00
127.00
???
James
201-735-9812
201-634-7865
Unknown
Dog
Cat
Laceration Repair
Booster Shots
Border Collie
11-Dec-11 Trent
Miles
Abyssinian
1-Jul-08 Evans
Hilary
201-634-2345
4-Nov-16 S
111.00
Figure 1-35 The Veterinary Office List-Version Two
Transcribed Image Text:A C D E G H K OwnerFirstName Marsha Richard PetName 2 King 3 Teddy 4 Filo 5 AJ 6 Cedro 7 Woolley 8 Buster 9 Jiddah PetType Dog Cat PetBreed Std. Poodle PetDOB 27-Feb-14 Downs OwnerPhone 201-823-5467 OwnerLastName OwnerEmail Service Date 17-Aug-16 S 5-Sep-16 S Charge 65.00 27.50 Marsha Downs@somewhere.com Ear Infection Richard.James@somewhere.com Nail Clip Marsha Downs@somewhere.com Liz.Frier@somewhere.com Richard James@somewhere.com Nail Clip Richard James@somewhere com Skin Infection Miles.Trent@somewhere.com Hilary Evans@somewere.com Cashmier 1-Feb-13 James 201-735-9812 Dog Dog Cat Cat Std. Poodle Collie Mix 17 Jul-15 Downs 5-May-15 Frier 6-Jun-12 James Marsha 201-823-5467 201-823-6578 Liz Richard Richard 5-May-16 S 5-Sep-16 S 3-Oct-16 S 5-Oct-16 S One year shots 42.50 Unknown 201-735-9812 27.50 35.00 127.00 ??? James 201-735-9812 201-634-7865 Unknown Dog Cat Laceration Repair Booster Shots Border Collie 11-Dec-11 Trent Miles Abyssinian 1-Jul-08 Evans Hilary 201-634-2345 4-Nov-16 S 111.00 Figure 1-35 The Veterinary Office List-Version Two
A
B
C
F
OwnerLastName
PetType
Dog
PetBreed
Std. Poodle
OwnerPhone
|201-823-5467
PetDOB
OwnerEmail
Marsha Downs@somewhere.com
Richard James@somewhere.com
Marsha Downs@somewhere.com
Liz.Frier@somewhere.com
Richard James@somewhere.com
Richard James@somewhere.com
Miles.Trent@somewhere.com
Hilary.Evans@somewere.com
1
PetName
OwnerFirstName
2 King
3 Teddy
4 Fido
27-Feb-14 Downs
Marsha
Cat
Cashmier
1-Feb-13 James
Richard
201-735-9812
Std. Poodle
17-Jul-15 Downs
Dog
Dog
Cat
Marsha
201-823-5467
5-May-15 Frier
6-Jun-12 James
5 AJ
6 Cedro
7 Woolley
8 Buster
9 Jiddah
Collie Mix
Liz
201-823-6578
Unknown
Richard
201-735-9812
Cat
Unknown
???
James
Richard
201-735-9812
Border Collie
11-Dec-11 Trent
1-Jul-08 Evans
Miles
Dog
Cat
201-634-7865
Abyssinian
Hilary
201-634-2345
Figure 1-34 The Veterinary Office List-Version One
Transcribed Image Text:A B C F OwnerLastName PetType Dog PetBreed Std. Poodle OwnerPhone |201-823-5467 PetDOB OwnerEmail Marsha Downs@somewhere.com Richard James@somewhere.com Marsha Downs@somewhere.com Liz.Frier@somewhere.com Richard James@somewhere.com Richard James@somewhere.com Miles.Trent@somewhere.com Hilary.Evans@somewere.com 1 PetName OwnerFirstName 2 King 3 Teddy 4 Fido 27-Feb-14 Downs Marsha Cat Cashmier 1-Feb-13 James Richard 201-735-9812 Std. Poodle 17-Jul-15 Downs Dog Dog Cat Marsha 201-823-5467 5-May-15 Frier 6-Jun-12 James 5 AJ 6 Cedro 7 Woolley 8 Buster 9 Jiddah Collie Mix Liz 201-823-6578 Unknown Richard 201-735-9812 Cat Unknown ??? James Richard 201-735-9812 Border Collie 11-Dec-11 Trent 1-Jul-08 Evans Miles Dog Cat 201-634-7865 Abyssinian Hilary 201-634-2345 Figure 1-34 The Veterinary Office List-Version One
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 4 images

Blurred answer
Similar questions
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