Could you please tell me all the entities and their attributes along with the primary key and the foreign key also the relationship in the model this is SQL general instructions reed the case below?

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. Below is a copy of 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 performs services and tests.

When an animal is seen it is possible to have multiple services or tests performed. Every visit has at least one test performed.

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 each visit. Finally she clarifies the Performed By column. With each service, at least one person needs to be associated with it.

Next you move on to the 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.

With regards to the people Clintonview manages, 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.

Your last topic to clear up is more about how data is entered into the database. An owner cannot exist in the database without being associated with a pet. When a new patient is entered into the database, if the owner is not already present in the database, they must be added so that the pet can be associated with that owner. As mentioned earlier a pet is only associated with one owner. Pets can exist in the database without having an appointment. An appointment can only have one pet on it. When a Pet comes in for a visit, there must be at least one service on it. A service can exist in the database without being associated with a visit.