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