Question: PLEASE FULLY DESIGN THIS ERD ACCORDING TO THE GIVEN SCENARIO!!! here is the definition of an ERD: An entity relationship diagram (ERD), also known as
PLEASE FULLY DESIGN THIS ERD ACCORDING TO THE GIVEN SCENARIO!!!
here is the definition of an ERD: "An entity relationship diagram (ERD), also known as an entity-relationship model, is a graphical representation that depicts relationships among people, objects, places, concepts or events within an information technology (IT) system."
this is the third time I've posted this question, please do not answer my question in writing I NEED A DIAGRAM. if you cannot do that please do not answer my question.
the ERD pictured below is an example of how it could look but it has flaws and is missing attributes and keys. please redesign it.

Here is how the business works: A customer calls Bob and asks him to bid on a home repair. He drives over, looks at the situation, and provides the customer with a bid. A customer can have more than one bid based on the repair. Bob decides how long it will take to do the repair (he bills by the hour), how much material will be needed and an overall price. Bob doesn't bill his customers until the work is complete. Bob allows his customers to make monthly payments on the total amount. Bob purchases material from multiple suppliers. The suppliers allow Bob to purchase material on credit. Bob makes monthly payments to each supplier based on the minimum monthly amount due. Currently, all business records are kept in Bob's head and in one file cabinet. This doesn't allow Bob to scale his business because he is busy with manual bookkeeping. So, he wants to computerize these elements of the business to make things more efficient. Can you help him
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
