Need help with this lab ---

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.

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 at 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 Larrys 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 data types at this time.

PLARRY'S LANDSCAPING Invoice Date: Employee 584795 8/20/2020 Mart 47859 Account: Customer Name Terry Janson Address 7564 White Hill City: Utica Phone #: 586 445-7412 48093 State: MI Zip: e-mail: AlDansen@gmail.com Item Description Mow Lawn 60 X 180 Standard Lot 2 Lawn Edge 60 X 180 Standard Lot 3 Clean-up 60 X 180 Standard Lot Price $15.00 $7.50 $2.50 $25.00 Subtotal Tax $1.50 Total $26.50 LARRY'S LANDSCAPING Invoice Date Employee 584796 8/25/2020 Jason 47851 Account Customer Name Joyce Baker Address B456 Liberty City: Utica Phone : 585-445-7412 48093 State: M Zip: e-mail: Rakel omcast.net Item Description 1 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 5 Weed Large Planting Bed Price $20.00 $10.00 $3.50 $65.00 $15.00 Subtotal $113.50 Tax $6.81 Total $120.31 PLARRY'S LANDSCAPING Invoice Date: Employee 584795 8/20/2020 Mart 47859 Account: Customer Name Terry Janson Address 7564 White Hill City: Utica Phone #: 586 445-7412 48093 State: MI Zip: e-mail: AlDansen@gmail.com Item Description Mow Lawn 60 X 180 Standard Lot 2 Lawn Edge 60 X 180 Standard Lot 3 Clean-up 60 X 180 Standard Lot Price $15.00 $7.50 $2.50 $25.00 Subtotal Tax $1.50 Total $26.50 LARRY'S LANDSCAPING Invoice Date Employee 584796 8/25/2020 Jason 47851 Account Customer Name Joyce Baker Address B456 Liberty City: Utica Phone : 585-445-7412 48093 State: M Zip: e-mail: Rakel omcast.net Item Description 1 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 5 Weed Large Planting Bed Price $20.00 $10.00 $3.50 $65.00 $15.00 Subtotal $113.50 Tax $6.81 Total $120.31