People are always looking for a good recommendation for help with household jobs and chores, such as handyman work, cleaning, and moving. You recognize the business potential of linking prospective clients with workers who perform these household jobs and chores. You decided to name the company Household Help (HHH). Your company will solicit workers who want to perform household chores such as cleaning, shopping and delivery, handyman work and moving. To record the information to run HHH, first, clients need to submit personal information such as their full name, address, phone number, email address, and credit card information for ease of billing. Workers also need to register after their background checks by providing their full name, home address, and email address. You envision that HHH will offer four different types of service that clients can request: cleaning, shopping and delivery, handyman jobs, and moving. Each service will be assigned a unique code so you don’t have to repeatedly enter the exact name of the task when you populate the database with appointments. In addition, each service will have a specific pay rate per hour. For example, a handyman’s services will be more expensive per hour than those of worker who makes shopping trips and deliveries. To begin, each worker in the database will be associated with one task he chooses to perform. In the future, you can see that workers might want to perform more than one task, so you will design your database to allow that possibility. When the clients call or eventually use the app to schedule a task, they will need to specify the workers they want, the date they need the task performed, and the start and end times. Deliverable: Design the HHH ERD. You need to identify the entities (tables) and their attributes (fields) and the relationship between tables
People are always looking for a good recommendation for help with household jobs and chores, such as handyman work, cleaning, and moving. You recognize the business potential of linking prospective clients with workers who perform these household jobs and chores. You decided to name the company Household Help (HHH). Your company will solicit workers who want to perform household chores such as cleaning, shopping and delivery, handyman work and moving. To record the information to run HHH, first, clients need to submit personal information such as their full name, address, phone number, email address, and credit card information for ease of billing. Workers also need to register after their background checks by providing their full name, home address, and email address. You envision that HHH will offer four different types of service that clients can request: cleaning, shopping and delivery, handyman jobs, and moving. Each service will be assigned a unique code so you don’t have to repeatedly enter the exact name of the task when you populate the database with appointments. In addition, each service will have a specific pay rate per hour. For example, a handyman’s services will be more expensive per hour than those of worker who makes shopping trips and deliveries. To begin, each worker in the database will be associated with one task he chooses to perform. In the future, you can see that workers might want to perform more than one task, so you will design your database to allow that possibility. When the clients call or eventually use the app to
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
