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

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 correctly.
The Offerings ... Plan relationship is not done correctly.
2.Make sure you have all of the necessary attributes in the payment entity.
 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

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

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!