Question: Please help me with this .... Thank you. Lab # 3 ~ Larry's Landscaping Creating a New Database As a way to pay for college

Please help me with this .... Thank you.Please help me with this .... Thank you. Lab # 3 ~Larry's Landscaping Creating a New Database As a way to pay for

Lab # 3 ~ Larry's Landscaping Creating a New Database As a way to pay for college a good friend of yours started cutting lawns for his neighbors and family. Because he does such a good job, his neighbors and family has been referring him to their friends and the business has grown. Recently your friend took on a condominium complex and has been asked to not only cut the lawn but trim it, weed and plant flower beds, trim bushes, plant bushes and trees, rake leaves and plow the snow in the winter. Because of the increase in business, your friend had to hire additional help. Additionally your friend has noticed that his current method of keeping track of his revenues and expenses is not adequate. He therefore, approaches you for some help. On a rather cool April afternoon, you and your friend meet to discuss his database needs. He brings with him printed out copies of various Excel spreadsheets, forms, invoices and a few reports. He hands you two example invoices. LARRY'S LANDSCAPING Invoice Date: 8/20/2020 Employee : Matt 47859 Account Customer Name Terry Janson Address 7554 White Hill City Utica Phone : 586-445-7412 48093 State: MI Zip: e-mail Awansen email.com Item Description 1 Mow Lawn 60 X 180 Standard Lot 2 Lawn Edge 50 X 180 Standard Lot Clean-up 60 X 180 Standard Lot Price $15.00 $7.50 $2.50 Subtotal $25.00 Tax $1.50 Total $26.50 LARRY'S LANDSCAPING + Invoice 584795 Date/25/2020 Employee leson 47851 Customer Name Joyce Baker Address 3456 Liberty City Utica Phone 586-445-7412 49093 State: MI Zips e-mail: Baker.comcast.net them Description 3 Mow Lawn 80 x 200 Large Lot 2 Lawn Edge 80 X 200 Large Lot 3 Clean-up 80 X 200 Lot 4 Plant Tree Mid Size Sweed Large Planting Bed Price $20.00 $10.00 $3.50 $65.00 $15.00 Subtotal $113.50 Tax $6.81 Total $120.31 He mentions during your meeting how long it takes for him to get ready for his meeting with his tax accountant. Further, he mentions how he would like to keep better track of which employee goes out on which jobs and what specifically they did that job. An employee can complete many tasks on a job and a task can be completed by many employees. You notice that there is an employee number on the invoice. You ask your friend what this means. In other words does this employee go out on the job or just process the invoice. Your friend tells you that this person only fills out the job order when someone wants something done. This person may or may not actually go out on a job. You finish your meeting with your friend and let him know that you will work up a draft ERD and will be in contact with him soon. Create an ERD After reading this case, analyze the two invoices from Larry's Landscaping. Based upon what was mentioned in the case and the invoices, construct an ERD that includes properly formed entities, attributes and relationships. Do not worry about datatypes at this time. Lab # 3 ~ Larry's Landscaping Creating a New Database As a way to pay for college a good friend of yours started cutting lawns for his neighbors and family. Because he does such a good job, his neighbors and family has been referring him to their friends and the business has grown. Recently your friend took on a condominium complex and has been asked to not only cut the lawn but trim it, weed and plant flower beds, trim bushes, plant bushes and trees, rake leaves and plow the snow in the winter. Because of the increase in business, your friend had to hire additional help. Additionally your friend has noticed that his current method of keeping track of his revenues and expenses is not adequate. He therefore, approaches you for some help. On a rather cool April afternoon, you and your friend meet to discuss his database needs. He brings with him printed out copies of various Excel spreadsheets, forms, invoices and a few reports. He hands you two example invoices. LARRY'S LANDSCAPING Invoice Date: 8/20/2020 Employee : Matt 47859 Account Customer Name Terry Janson Address 7554 White Hill City Utica Phone : 586-445-7412 48093 State: MI Zip: e-mail Awansen email.com Item Description 1 Mow Lawn 60 X 180 Standard Lot 2 Lawn Edge 50 X 180 Standard Lot Clean-up 60 X 180 Standard Lot Price $15.00 $7.50 $2.50 Subtotal $25.00 Tax $1.50 Total $26.50 LARRY'S LANDSCAPING + Invoice 584795 Date/25/2020 Employee leson 47851 Customer Name Joyce Baker Address 3456 Liberty City Utica Phone 586-445-7412 49093 State: MI Zips e-mail: Baker.comcast.net them Description 3 Mow Lawn 80 x 200 Large Lot 2 Lawn Edge 80 X 200 Large Lot 3 Clean-up 80 X 200 Lot 4 Plant Tree Mid Size Sweed Large Planting Bed Price $20.00 $10.00 $3.50 $65.00 $15.00 Subtotal $113.50 Tax $6.81 Total $120.31 He mentions during your meeting how long it takes for him to get ready for his meeting with his tax accountant. Further, he mentions how he would like to keep better track of which employee goes out on which jobs and what specifically they did that job. An employee can complete many tasks on a job and a task can be completed by many employees. You notice that there is an employee number on the invoice. You ask your friend what this means. In other words does this employee go out on the job or just process the invoice. Your friend tells you that this person only fills out the job order when someone wants something done. This person may or may not actually go out on a job. You finish your meeting with your friend and let him know that you will work up a draft ERD and will be in contact with him soon. Create an ERD After reading this case, analyze the two invoices from Larry's Landscaping. Based upon what was mentioned in the case and the invoices, construct an ERD that includes properly formed entities, attributes and relationships. Do not worry about datatypes at this time

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!