SCENARIO Lawn Moving Pro Lawn Mowing Pro provides gardening and yard maintenance services to individuals and organisations While the company will provide one time garden services, it specialises in recurring service and maintenance Many of its customers have multiple building, apartments, and rental properties that require gardening and lawn maintenance services The owner type of these properties is either Individual or Corporation Currently the manager uses a spreadsheet to keep records of everything in one table like This table mainly stores data about Property, Propertys Owner, Service, and Employee Sample data about properties and services collected by the Lawn Mowing Pro is shown in Figure 1 below Figure 1 shows data the Lawn Moving Pro collects about properties and services Rather than using a spreadsheet, the manager has asked you to design and develop a database for the company, using the sample data to get started with and the following basic business rules to be maintained Each property is owned by one owner An owner can own many properties Each property can have more than one services Each service is provided to one property An employee can do many services Each service is done by one employee Tasks to be completed Using the table and data in Figure 1, state assumptions about dependencies among the columns of the table Justify your assumptions on the basis of the sample data and also on the basis of what you know about service business PROP ID PROP NAME ADDR CITY STATE P CODE OWN ID OWN NAME OWN EMAIL OWN TYPE SERV DATE SERV DESC SERV HRS SERV CHG EMP ID HR EMP NAME EMP MOB 10 Eastlake Building 123 Eastlake Maroona VIC 3210 1 Helmet Jones helment jones gmail com Garden 05 05 2020 Service 2 5 75 101 Robert McGraw 401234567 Individual 11 Earls Court 235 East West Portland VIC 3330 2 Kenny Blackmore kenny blackmor e gmail com Corporation 07 05 2020 Lawn Mow 2 55 102 Mike Burrows 414563453 12 Barry Wilson 75 West Bound Dundee VIC 3500 3 Barry Wilson barry wilson b arrywilson com Garden 07 05 2020 Service 2 5 85 101 Robert McGraw 401234569 Individual 11 Earls Court 235 East West Portland VIC 3330 2 Kenny Blackmore kenny blackmor e gmail com 12 05 2020 Lawn Mow 1 5 50 102 Mike Burrows 414563453 Corporation 13 Jack and Jill 105 Young Freshy VIC 3350 14 Craig Noon craig noon gm ail com Garden 19 05 2020 Service 3 85 103 Ben Keen 414365679 Individual 14 Cosey Here 144 Sensible Sunshine VIC 3456 5 Wendy Sullivan wendy sulluvan gmail com 17 05 2020 Lawn Mow 2 50 102 Mike Burrows 414563453 Corporation 15 66 30 Palm Bruno Son Beach Newland VIC 3333 6 Jim Bruno jim gruno brun oandsone com Individual 14 05 2020 Lawn Mow 55 103 Ben Keen 414563453 16 Emerson Flying Jet 707 Arduino Mega VIC 3256 7 10 05 2020 Lawn Mow 1 50 101 Robert McGraw 401234574 peter emerson emersonflying jet com Corporation Peter Emerson

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 07, 2024

SCENARIO: Lawn Moving Pro Lawn Mowing Pro provides gardening and yard maintenance services to individuals and organisations. While the company will provide one-time garden services,

SCENARIO: Lawn Moving Pro

Lawn Mowing Pro provides gardening and yard maintenance services to individuals and organisations. While the company will provide one-time garden services, it specialises in recurring service and maintenance. Many of its customers have multiple building, apartments, and rental properties that require gardening and lawn maintenance services. The owner type of these properties is either Individual or Corporation.

Currently the manager uses a spreadsheet to keep records of everything in one table-like. This table mainly stores data about Property, Propertys Owner, Service, and Employee.

Sample data about properties and services collected by the Lawn Mowing Pro is shown in Figure 1 below.

image text in transcribed

Figure 1 shows data the Lawn Moving Pro collects about properties and services.

Rather than using a spreadsheet, the manager has asked you to design and develop a database for the company, using the sample data to get started with and the following basic business rules to be maintained.

Each property is owned by one owner
An owner can own many properties.
Each property can have more than one services.
Each service is provided to one property.
An employee can do many services
Each service is done by one employee.

Tasks to be completed:
1. Using the table and data in Figure 1, state assumptions about dependencies among the columns of the table. Justify your assumptions on the basis of the sample data and also on the basis of what you know about service business.

PROP_ID PROP_NAME ADDR CITY STATE P_CODE OWN_ID OWN_NAME OWN_EMAIL OWN_TYPE SERV_DATE SERV_DESC SERV_HRS SERV_CHG EMP_ID HR EMP_NAME EMP_MOB 10 Eastlake Building 123 Eastlake Maroona VIC 3210 1 Helmet Jones helment.jones@ gmail.com Garden 05/05/2020 Service 2.5 75 101 Robert McGraw 401234567 Individual 11 Earls Court 235 East West Portland VIC 3330 2 Kenny Blackmore kenny.blackmor e@gmail.com Corporation 07/05/2020 Lawn Mow 2 55 102 Mike Burrows 414563453 12 Barry Wilson 75 West Bound Dundee VIC 3500 3 Barry Wilson barry.wilson@b arrywilson.com Garden 07/05/2020 Service 2.5 85 101 Robert McGraw 401234569 Individual 11 Earls Court 235 East West Portland VIC 3330 2 Kenny Blackmore kenny.blackmor e@gmail.com 12/05/2020 Lawn Mow 1.5 50 102 Mike Burrows 414563453 Corporation 13 Jack and Jill 105 Young Freshy VIC 3350 14 Craig Noon craig.noon@gm ail.com Garden 19/05/2020 Service 3 85 103 Ben Keen 414365679 Individual 14 Cosey Here 144 Sensible Sunshine VIC 3456 5 Wendy Sullivan wendy.sulluvan @gmail.com 17/05/2020 Lawn Mow 2 50 102 Mike Burrows 414563453 Corporation 15 66/30 Palm Bruno & Son Beach Newland VIC 3333 6 Jim Bruno jim.gruno@brun oandsone.com Individual 14/05/2020 Lawn Mow 55 103 Ben Keen 414563453 16 Emerson Flying Jet 707 Arduino Mega VIC 3256 7 10/05/2020 Lawn Mow 1 50 101 Robert McGraw 401234574 peter.emerson @emersonflying jet.com Corporation Peter Emerson