Group Project Part IIRBS Veterinary Hospital Revenue Cycle Requirements: The second part of the project requires
Question:
Group Project – Part IIRBS Veterinary Hospital Revenue Cycle Requirements: 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.
2 Deliverable: 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.”
Database Systems Design Implementation and Management
ISBN: 978-1285196145
11th edition
Authors: Carlos Coronel, Steven Morris