Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) ER Diagram (50 pts) Using ERDPlus. create the ERD necessary to capture the following information. Once you have completed your diagram, convert it to

image text in transcribed

1) ER Diagram (50 pts) Using ERDPlus. create the ERD necessary to capture the following information. Once you have completed your diagram, convert it to a Relational Schema. Submit both your ERD and your Relational Schema. 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 customer's 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 (1.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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

=+ 4. Why should policymakers think about incentives?

Answered: 1 week ago

Question

=+ 2. What is the opportunity cost of seeing a movie?

Answered: 1 week ago

Question

=+ what roles should government play in them ?

Answered: 1 week ago