ER Diagram

Using the ERDPlus website, create the ERD necessary to capture the following information.

Squirrels Unlimited Yard Service (SUYS) does basic yardwork (mowing, trimming, weeding, etc.) as well as more complex tasks (e.g., removing trees, installing sprinkler systems, etc.) for customers in Boise. They have many long-term customers as well as one-time customers. Some customers own more than one property which they have SUYS maintain. They would like to start tracking their business more carefully through a database system.

Customers receive bills for any services performed after the fact. Therefore SUYS must record the customers name, address, and phone number. SUYS also likes to record the date on which a customer first uses their services.

Each property has an address and SUYS also wants to record if the property is a residential or commercial property.

When contracting with SUYS for services, some customers wish a one-time only service, such as removing a tree. Each of those services is priced based on the specific job.

Many other customers wish a repeating package of services (i.e., mowing and trimming every week in the summer), and still others wish a comprehensive package of services such that all yard care needs are handled by SUYS regardless of the season (i.e., mowing in the summer, raking in the fall, trimming of trees and shrubs in the spring, etc.). SUYS offers a number of packages for these repeating customers. For each package SUYS has a unique code and a description of the services included (e.g., Pkg A includes mowing and trimming around fences, trees, etc. during the summer months only, Pkg B is a year-round service). For the packages, there is a monthly fee determined for that particular customer.

Business Rules:

Each customer owns at least one property, but may own more than one property. Each property is owned by one and only one customer

Each property may have had many services performed on it, or may have had no services performed. Each service has been performed for one and only one property.

Each package SUYS offers may be performed for many properties, or may not have been performed at all. Each property may have had many packages, or may have had none.

Be sure to:

Convert all many-to-many relationships to associative entities (also called many-to-many entities).

Convert all multi-valued attributes to entities.

Specify the maximum and minimum cardinality for each relationship.

Add as few extra attributes as possible.