Data modeling for healthcare

Introduction A data model provides a user’s view of how the data should be structured and displayed. It also provides an understanding of how information is acquired and required to support business practices within an organization. Preparation In this assignment, you will develop a data model for a specific scenario. The following steps will help prepare you: Read the “Data Modeling 101: An Introduction” article in the Week 7: Data ModelingLinks to an external site. reading list. View the Creating an ERD media. Complete the Data Modeling media. Review the resources in the Week 7: Visio Support for Data Model AssignmentLinks to an external site. reading list if you are using Visio to complete the assignment. Microsoft Software You may use Visio, Word, Excel, or any free program on the Internet to create your model. If you choose to use Visio, access the resources in the Week 7: Visio Support for Data Model AssignmentLinks to an external site. reading list for support. If you choose to use Visio and haven’t downloaded it yet, complete the following steps. Visit Capellas Microsoft Azure for EducationLinks to an external site. page for instructions on obtaining free Microsoft software. Identify the version of MS Visio that is compatible with your operating system. Download and install. Note: When logging into Microsoft Azure, make sure to use your Capella University email and password to access these. For example, if your user ID is tjones123, your Capella email will be tjones123@capellauniversity.edu. If you encounter any difficulties in the download and installation process, post a detailed question in the Ask Your Instructor section of the course. Your instructor should be able to help you or point you in the right direction for the answers you need. Instructions You have been provided the data points in the bulleted list below from a St. Anthony Medical Center clinic. Using the data points provided, develop a data model for the St. Anthony Medical Center clinic; apply the knowledge gained from this weeks study resources on data modeling concepts. Your data model should structure the data to support the business practices of a healthcare organization. The data points should be grouped together under a category heading. Each category should have a title that is short but descriptive. Develop your data model using the symbols and notations found in entity-relationship diagrams. Use Visio, Word, Excel, or any free program on the Internet to create your model. Consumer ID. Last name. First name. Date of birth. Sex or gender. Street address. City. State. Zip code. Telephone number. Social Security Number. Type of radiological test. Date ordered. Physician’s last name. Physician’s first name. Physician’s specialty. Physician’s ID. Physician’s telephone number. Insurance name. Insurance group number. Insurance type. Effective date. Expiration date. Diagnosis. Signs and symptoms. Presenting problem. Time of arrival. Time of discharge. In your assignment: Step 1: Create your data model. Include appropriate application of symbols and notations used in data modeling. Step 2: After you have completed your model, write a 12 paragraph explanation summarizing the model and the entity relationships included in it. Be sure to include a supporting reference. Additional Requirements Your assignment should also meet the following requirements: Written communication: Written communication should be clear and generally free of grammatical errors. Format: Word, Excel, Visio, or PDF documents. APA formatting: Use current APA style and format for the paper, references, and citations. See the Writing CenterLinks to an external site. for APA resources specific to your degree level. Length of paper: Diagram plus a 12 paragraph explanation of the model. Font and font size: Times New Roman, 12 point. Competencies Measured By successfully completing this assignment, you will demonstrate your proficiency in the following course competencies and rubric criteria: Competency 1: Interpret healthcare data. Summarize the model and its entity relationships. Competency 3: Use data analysis tools and privacy concepts to support health information integrity and data quality. Construct a data model. Apply symbols and notations used in data modeling. Competency 5: Communicate in a professional manner to support healthcare data analytics. Follow APA style and formatting guidelines for references and citations. Create a document that is clearly written and generally free of grammatical errors.