SQL Diagram with Primary and Foreign Keys. Use relationship tables and proper types of relationship. Clintonview Veterinary Clinic A good friend of yours is in the VetTech Program at Macomb Community College. She recently started an internship with Clintonview Veterinary Clinic and noticed that they have a very antiquated database. She therefore, has employed your help to build a new database. Your first step is to gather as much information as possible. You schedule a meeting with the office manager, Jody. She hands you a bunch of paper input forms as well as reports. You pull out the Invoice. Jody immediately mentions the following to you: In addition to the appointment date and time, they also record when the appointment was scheduled. The name of the person on the invoice is who took care of the person when they came in. The veterinary clinic sells vitamins, medication, tests and of course a vast array of services. When people come in, they normally purchase a number of items. Although a pet can have multiple owners they only record one. Next you pull out the What Was Done report. This report is handed to each customer as they leave. It provides a brief summary of their visit. On this form you are very curious about the diagnosis and who performed what. Jody tells you that with every visit there is at least one diagnosis. You look at the report and see None for diagnosis and ask for clarification. Jody tells you that is OK. None is considered a diagnosis. They tried putting NA or leaving that part of the report blank, but too many people became confused. In addition she adds there can be multiple diagnoses when a pet comes in. The diagnosis is attached to the visit and not necessarily to a purchased item. Finally she clarifies the Perfomed By column. With each service and or product sold, at least one person needs to be associated with it. Next you move on to their products and services. Jody mentions that for the Services, they keep track of the name, description, the recommended price, any restrictions that go along with that service and any after care instructions. For the products they sell, they keep track of the name, description, wholesale price, retail price and who manufactures it. One of the issues they would like to clean up with the new database is some way to commonize the names of the manufacturers. Additionally they would like a way to note not only the names of the manufacturers but also their business address, and who their representative is at the company or their point of contact. There is only one point of contact for each manufacturer. Your last item to clarify deals with how Clintonview manages the data surrounding the people. Jody mentions that in addition to the owner information you see on the invoice, they also keep track of when they became a customer and if they were referred by anyone. They also need to keep track of employee data, including when they were hired, terminated, the social security number, their position and pay rate. Finally all people have multiple forms of contact. Clintonview asks for work, home and cell phone numbers along with e-mail addresses. Using the information you have collected build an Entity Relationship Diagram for Clintonview Veterinary Clinic. If you need more clarification regarding the diagram requirements please post these to the weekly forum. You do not need to supply data types for this model. Focus your attention on building a fully normalized database that avoids all anomalies and shows proper cardinality. All of the entities you will need for this diagram you have seen before in either prior homework assignments, labs and warm up exercises. Consult all of your examples. When you have completed your model, consult the rubric to make sure you have included all necessary items. Then generate a .pdf file. Make sure your .pdf can print on one 8 X 11 sheet of paper, is legible (please not too small) and includes your name.Turn the .pdf file into Canvas.