Group Project Part IIRBS Veterinary Hospital Revenue CycleRequirements:The second part of the project requires your team to perform step 8 in the event-oriented modeling (as described in chapters 8 and 9). Examine the standard partial solution for the RBS Veterinary Hospital. Use the provided partial solution as a starting point for this stage. Convert the REA diagram into tables. Make sure that you follow the procedure described in chapter 9. Implement the rules in chapter 9 for determining whether a table conforms to the first, second, or third normal form. Normalize tables that are not in the 3rd normal form. Make sure that all your tables are normalized (each table should be in the 3rd normal form). You should complete the attached table describing the list of all your tables, the attributes in each table, and primary and foreign keys for each table. In addition, you must summarize all the steps that you sued in the normalization process. Example:When the diagram was converted into a table form this already made all of the tables into the second normal form. At this point then the only thing that needs to occur to make all of the tables into third normal form is to remove all transitive dependencies that may be still in the tables......

2Deliverable:Complete the document (i.e., TeamNumber-Part2.docx). Submit one file. Be sure to change the file name using your team number. For example, my MS file would be Team10-Part2.docx.

3REA Diagram

4Partial List of Attributes for Each EntityEntityAttributesEmployeeEmployeeID, EmployeeName, EmployeeAddress, DateStarted, JobTitle, Phone, EmployeeEmailServiceServiceNo, ServiceName, ServiceCharge, ServiceHourMedicationMedicationNo, DrugName, UnitCost, QtyOnHand, CashAccountNo, AccountType, BankName, AccountBalancePet ParentParentID, ParentName, ParentAddress, DayPhone, NightPhone, ParentEmailPetPetID, PetName, Breed, Color, DateOfBirthAppointmentAppointmentNo, PetID, AppointmentDateExaminationExamNo, Weight, Height, Heartbeat, Temperature, SymptomCashReceiptReceiptNo, ReceiptDate, AmountReceivedAppointment_ServiceSpecialNeedsExamination_ServiceActualServiceHours, ExaminationResultsExamination_MedicationQtyOfMedicationNote: The list does not include all the attributes (i.e., primary and foreign keys) which are characteristic of relationships with other entities.