PATIENT RECORD: Over the coming weeks of this course,... | Information Systems

Over the coming weeks of this course, you are to design a database based on the business requirements of the Patton-Fuller Community Hospital. What you will take away from the experience of this project is a deep understanding of how databases work and their relationship to health care information pertaining to the organization, its staff, patients, and partners. This experience also underlines the organizational skills required of health care administrators in their oversight role at a given facility.  You begin your project this week and will continue with this assignment during Weeks 3 through 5. Each week involves different tasks that build upon a complete database design by Week 5.  This week, using information from the Patton-Fuller Community Hospital Virtual Organizations Portal and the Patton-Fuller Entities and Attributes document, create an entity-relationship diagram (ERD) that includes the following:  Tables used  Defined use and relationships  Attributes  Fields in each table detail  Diagram of tables, entities, and relationships  Then, write a 525- to 700-word report that includes the following:  Describe the requirements that are being met in the line of business.  Explain in detail the data that is being collected.  Describe how the information generated from the relationships can help the business in the decision-making process.  Develop your database design as a Word document, Excel workbook, or a combination of the two. Include diagrams in the design document and not separately.   Cite any sources to support your assignment.  Format your sources according to APA guidelines.  Submit your assignment. Resources Center for Writing Excellence Reference and Citation Generator Grammar Assistance