as soon as possible Design a database using Entity Relationship modelling notati

Question

as soon as possible

Design a database using Entity Relationship modelling notation on paper to support the , following small business. You have decided to find a way to make extra money this summer performing work for others. You are employing many of your friends as part of this new endeavor . . You are offering several services for customers to choose from: Dog sitting, Lawn care, Computer Repair, Web design, Birthday party clown, etc. Each service has a different daily rate. Only one job per day can be accepted per employee. Customers will pay using cheque or cash Create a key structure that will prevent an employee being assigned to more than . . one event on a given day Once complete... please have the professor review the database design before considering it complete This is an individual assignment. Please do not share this solution electronically with anyone.

Explanation / Answer

customer_id

Primary key

job_description

job_id

primary key

rate

as per day

emp_id

primary key

emp_id

foreign key

job_id

foreign key

customer_id

foreign key

job_id

foreign key

customer_id

foreign key

mode

(cheque or cash)

status

(done or pending)

Customer

customer_id

Primary key

cu_name cu_address cu_contact c1 mary 1street 788900 c2 john 2 city 455677

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.