Question: Fix the E-R model 1.Make sure your 1..1 to 0..* (one to many) relationships go in the correct direction. Customer 1..1 0..* Plan is done
Business Case: Trash Haulers Deluxe Trash Haulers Deluxe (THD) is a company offering trash hauling and recycling services for residential and business customers. THD offers a number of different service offerings such as Twice weekly trash pickup" and "Once a week recycling pickup". Customers sign up for a service plan that can include one or more service offerings. Each service plan has a start and ending date and an address/location where the trash or recycling is picked up. THD also needs to record, on each of the offerings, the monthly price All of the typical customer information should be recorded such as business name, name of the contact person, complete address, telephone number and so on. It is possible for customers to have more than one plan. Finally is expected that each customer will send in a payment every month to cover the costs of their service plans. THD will need to record the date of the payment, the payment method (check, credit card, etc.) and a confirmation number (or check number) for the payment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
