Draw an entity-relationship diagram for each of the following data sets. Remember to identify keys and to label relationships with their functionality. If you have to make any assumptions in order to decide what to draw, then state those assumptions. Think carefully about what is an entity, what is a relationship and what is an attribute. Sometimes things sound like one but are better represented in another way a. Doug's Dog Walking Service has grown from a part-time venture for earning beer money to a big 3. business. (It seems like everyone in Richmond has a dog these days.) Doug needs a database to keep track of his clients and their beloved pet(s). Data is to be stored about clients, dogs, and walking history (track record, if you) This data includes the animals name, date of birth, breed of dog, owner, and the dog's exercise history. Data to be stored about owners includes name, address, and phone number Data stored about the exercise history is: which dog went for a walk, date walked, length of the walk, and the charge to the owner. Doug is expanding his business and has hired some employees as dog walkers, so he'd like you to include some employee information, too. Data stored about each employee is their name, address, and phone number, along with which dogs they exercised, and when they did so Draw an entity-relationship diagram for each of the following data sets. Remember to identify keys and to label relationships with their functionality. If you have to make any assumptions in order to decide what to draw, then state those assumptions. Think carefully about what is an entity, what is a relationship and what is an attribute. Sometimes things sound like one but are better represented in another way a. Doug's Dog Walking Service has grown from a part-time venture for earning beer money to a big 3. business. (It seems like everyone in Richmond has a dog these days.) Doug needs a database to keep track of his clients and their beloved pet(s). Data is to be stored about clients, dogs, and walking history (track record, if you) This data includes the animals name, date of birth, breed of dog, owner, and the dog's exercise history. Data to be stored about owners includes name, address, and phone number Data stored about the exercise history is: which dog went for a walk, date walked, length of the walk, and the charge to the owner. Doug is expanding his business and has hired some employees as dog walkers, so he'd like you to include some employee information, too. Data stored about each employee is their name, address, and phone number, along with which dogs they exercised, and when they did so