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 tothat 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 billingaddress, as well as property name, type, and address. B. Describe modification problems that are likely to occur if Garden Glory attempts tomaintain the list in a spreadsheet. C. Split the list into tables such that each has only one theme. Create appropriate IDcolumns. Use a linking column to represent the relationship between a property and an owner. Demonstrate that the modification problems you identified in part B havebeen eliminated. D. Create a sample list of owners, properties, and services. Your list will be similar tothat in Figure 1-35 9. Your list should include the data items from part A as well asthe date, description, and amount charged for each service. E. Illustrate modification problems that are likely to occur if Garden Glory attempts tomaintain the list from part D in a spreadsheet. F. Split the list from part D into tables such that each has only one theme. Createappropriate ID columns. Use linking columns to represent relationships. Demonstrate that the modification problems you identified in part E have been eliminated. ACDEGHKOwnerFirstNameMarshaRichardPetName2 King3 Teddy4 Filo5 AJ6 Cedro7 Woolley8 Buster9 JiddahPetTypeDogCatPetBreedStd. PoodlePetDOB27-Feb-14 DownsOwnerPhone201-823-5467OwnerLastNameOwnerEmailServiceDate17-Aug-16 S5-Sep-16 SCharge65.0027.50Marsha Downs@somewhere.com Ear InfectionRichard.James@somewhere.com Nail ClipMarsha Downs@somewhere.comLiz.Frier@somewhere.comRichard James@somewhere.com Nail ClipRichard James@somewhere com Skin InfectionMiles.Trent@somewhere.comHilary Evans@somewere.comCashmier1-Feb-13 James201-735-9812DogDogCatCatStd. PoodleCollie Mix17 Jul-15 Downs5-May-15 Frier6-Jun-12 JamesMarsha201-823-5467201-823-6578LizRichardRichard5-May-16 S5-Sep-16 S3-Oct-16 S5-Oct-16 SOne year shots42.50Unknown201-735-981227.5035.00127.00???James201-735-9812201-634-7865UnknownDogCatLaceration RepairBooster ShotsBorder Collie11-Dec-11 TrentMilesAbyssinian1-Jul-08 EvansHilary201-634-23454-Nov-16 S111.00Figure 1-35 The Veterinary Office List-Version Two ABCFOwnerLastNamePetTypeDogPetBreedStd. PoodleOwnerPhone|201-823-5467PetDOBOwnerEmailMarsha Downs@somewhere.comRichard James@somewhere.comMarsha Downs@somewhere.comLiz.Frier@somewhere.comRichard James@somewhere.comRichard James@somewhere.comMiles.Trent@somewhere.comHilary.Evans@somewere.com1PetNameOwnerFirstName2 King3 Teddy4 Fido27-Feb-14 DownsMarshaCatCashmier1-Feb-13 JamesRichard201-735-9812Std. Poodle17-Jul-15 DownsDogDogCatMarsha201-823-54675-May-15 Frier6-Jun-12 James5 AJ6 Cedro7 Woolley8 Buster9 JiddahCollie MixLiz201-823-6578UnknownRichard201-735-9812CatUnknown???JamesRichard201-735-9812Border Collie11-Dec-11 Trent1-Jul-08 EvansMilesDogCat201-634-7865AbyssinianHilary201-634-2345Figure 1-34 The Veterinary Office List-Version One

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

See similar textbooks

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.

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.