Please only answer if you know 100% and dont. Copy form past post it a wrong answer. Don't any other information all other data is just make it up there is no specific data

Need to create ERD diagram first needs to create table from the below information and then indentify primary key and foreign key.

Sample of ERD diagram how it suppose to be done.

Cape Elder Care Center Case Scenario Cape Elder Care Center is a small, but growing, skilled care facility for patients who no longer can live independently and require medical attention. In order to house, take care of, and receive payment from patients, the Center needs to collect quite a bit of data in their database. I have created some of the entities for you, but some you will need to create on your own as indicated by "Need a. Entity." In the section below, the heading indicates what entities need to be created and the paragraphs describe the data to be collected for that entity. (You may want to refer back to exercise 2.) Data Collection Need a Patient Entity and a Condition Entity The Center needs to know who their patients are, when they were born, their gender, and their medical condition. The PatientCondition entity is provided below. To standardize conditions, you would need a table describing Conditions in general so you would not have to write the same general description for each patient, Instead it would be provided once in the Condition table and linked to the Patient entity through the ConditionD field. The facility has two beds in each room, so the Center will have to keep track of the room in which the patient is assigned as well as the bed. (Patients may get moved to a different wing of the facility due to a change in nursing skill needs, so they may have multiple rooms and beds in their history.) The patient room location and bed assignment entity is provided below as "Patientlocation. Information must also be collected about patient contacts and the contacts' addresses. A patient may have three different contacts with one contact being for billing purposes, one being the primary contact, and one being a secondany contact in case the primary contact cannot be reached. A primary or secondary contact can also be a billing contact. Information about patient ordered medications from the doctor is also collected such as the name of the medication, the date the medication was prescribed, the frequency of dosage, the amount of dosage, the prescribing doctor, number of refills, and last refill. In order to link the patient medication information to its administration to the patient, I created the "MedicationAdministration" entity listed below. Need Nurselnformation Entity, NurseAddress Entity and Work Hours Entity Nurses work at the Center to take care of the patients and data must be collected about the nurses such as their names, date of birth, gender, highest education status (CNA, LPN, RN, BSRN, FNP). We will also have to collect their address data too. In order to get paid for their hours, nurses need to record their starting and ending time each day. Nurses are assigned up to five specific patients each day. The PatientAssignment entity below provides the link between patients and their nurse assignment for the day. Companies often purchase a ZipCode table to upload into their databases, so will want to use the ZipCode entity when referencing any addresses. The zipcode fields are provided in the "ZipCode" entity below. Provided Entities Pa PatientCondition PatientID ConditionID, Notes) ZipCode ZipCode City, State) PatientAssignment NurselD, PatientiD, Date MedicationAdministration(PatientiD MedicationlD, NurselD, DateAdministered TimeAdministered, Dosage, Notes) RoomNumber RoomEntryDate, RoomExitDate, BedNo.) A patient may take multiple medications, each day, multiple times a day, so to reference one specific dosage and any notes or side effects from that dosage, you would need to have the PatientiD, MedicationlD, DateAdministered, and the TimeAdministered.* Cape Elder Care Center Case Scenario Cape Elder Care Center is a small, but growing, skilled care facility for patients who no longer can live independently and require medical attention. In order to house, take care of, and receive payment from patients, the Center needs to collect quite a bit of data in their database. I have created some of the entities for you, but some you will need to create on your own as indicated by "Need a. Entity." In the section below, the heading indicates what entities need to be created and the paragraphs describe the data to be collected for that entity. (You may want to refer back to exercise 2.) Data Collection Need a Patient Entity and a Condition Entity The Center needs to know who their patients are, when they were born, their gender, and their medical condition. The PatientCondition entity is provided below. To standardize conditions, you would need a table describing Conditions in general so you would not have to write the same general description for each patient, Instead it would be provided once in the Condition table and linked to the Patient entity through the ConditionD field. The facility has two beds in each room, so the Center will have to keep track of the room in which the patient is assigned as well as the bed. (Patients may get moved to a different wing of the facility due to a change in nursing skill needs, so they may have multiple rooms and beds in their history.) The patient room location and bed assignment entity is provided below as "Patientlocation. Information must also be collected about patient contacts and the contacts' addresses. A patient may have three different contacts with one contact being for billing purposes, one being the primary contact, and one being a secondany contact in case the primary contact cannot be reached. A primary or secondary contact can also be a billing contact. Information about patient ordered medications from the doctor is also collected such as the name of the medication, the date the medication was prescribed, the frequency of dosage, the amount of dosage, the prescribing doctor, number of refills, and last refill. In order to link the patient medication information to its administration to the patient, I created the "MedicationAdministration" entity listed below. Need Nurselnformation Entity, NurseAddress Entity and Work Hours Entity Nurses work at the Center to take care of the patients and data must be collected about the nurses such as their names, date of birth, gender, highest education status (CNA, LPN, RN, BSRN, FNP). We will also have to collect their address data too. In order to get paid for their hours, nurses need to record their starting and ending time each day. Nurses are assigned up to five specific patients each day. The PatientAssignment entity below provides the link between patients and their nurse assignment for the day. Companies often purchase a ZipCode table to upload into their databases, so will want to use the ZipCode entity when referencing any addresses. The zipcode fields are provided in the "ZipCode" entity below. Provided Entities Pa PatientCondition PatientID ConditionID, Notes) ZipCode ZipCode City, State) PatientAssignment NurselD, PatientiD, Date MedicationAdministration(PatientiD MedicationlD, NurselD, DateAdministered TimeAdministered, Dosage, Notes) RoomNumber RoomEntryDate, RoomExitDate, BedNo.) A patient may take multiple medications, each day, multiple times a day, so to reference one specific dosage and any notes or side effects from that dosage, you would need to have the PatientiD, MedicationlD, DateAdministered, and the TimeAdministered.*