Posted: December 21st, 2020

For this Course Project, you will be presented with a scenario involving a pharmacy

For this Course Project, you will be presented with a scenario involving a pharmacy mini clinic much like those that are found in many drug stores—providing a location where patients can pick up prescriptions and get vaccinated. As one of the health care providers at the mini clinic, you have been asked by the manager to create a basic relational database that can be used to gather information about the patients who have received vaccines at the mini clinic.The database will include information on the following:Patients that visit the clinicInformation about the vaccines that are dispensedInformation about the insurance companies that the patients useThe insurance company that the patient used to pay for the vaccineThe type of vaccine and dosage administered on a particular visitYou will also be working under the following assumptions:The clinic dispenses different types of vaccines.Each vaccine vial has a serial number, lot number, expiration date, and manufacturer.Each vial will contain multiple doses of the vaccine and will be used for multiple patients until all of the doses have been used up.Visits will always be paid for by an insurance company.A particular patient might use a different insurance company on each visit (e.g., if they change jobs and thus have a new insurance carrier).The "Pharmacy Mini Clinic" Course Project will consist of seven stages. It is important to note that a stage will be due each week, with the exception of Week 8, so that your Instructor can monitor your progress and provide you with the support you need. Each subsequent stage of work will build upon the prior week’s work and each stage is to be completed individually. The seven stages are as follows:Stage 1: Data AnalysisStage 2: Entity RelationshipsStage 3: Database Development (Step 1)Stage 4: Database Development (Step 2)Stage 5: Database QueriesStage 6: Generating ReportsStage 7: User InterfaceNote: In order to complete the Course Project, you should have certain software installed on your computer.Excelhttps://support.office.com/en-US/article/Excel-2013-training-courses-videos-and-tutorials-aaae974d-3f47-41d9-895e-97a71c2e8a4aPowerPointhttps://support.office.com/en-US/article/PowerPoint-2013-training-courses-videos-and-tutorials-bd93efc0-3582-49d1-b952-3871cde07d8aFurther details about this project are provided in the Course Project sections of Weeks 1–7.Stage 1: Data AnalysisNote: Before you begin this stage, review the "Pharmacy Mini Clinic" Course Project Rubric in the Course Information area.This week, you will begin your Course Project by completing Stage 1. This stage will be a component in your "Pharmacy Mini Clinic" Course Project and will be due on Day 5.To prepare for this stage of the Course Project, view the "Designing a Database" video located under the Week 1 Learning Resources. Then, review the "Perspective" section on pages 196–199 of your Health Care Information Systems course text for a definition of the main terminology and an example of a partial attribute list for a similar set of entities. Finally, familiarize yourself with the Stage 1 Example PowerPoint slide as well as the Project Supporting Document.Stage 1 Example PowerPointProject Supporting DocumentTo complete this stage of the Course Project, download and save the Stage 1 Template file linked below, as you will need it to complete your assignment for this stage. Select each of the attributes listed below the table and determine which entity it would go under, and type it in the appropriate place. After you have assigned all of the attributes, insert the correct data type for each attribute. The data types that you may select from are listed next to the attributes list on the template. You may review the Data Types section of the Project Supporting Document as needed. Also, make sure that you use a consistent naming convention for your attributes (see the Naming Conventions section of the Project Supporting Document.)Stage 1 TemplateReading materials:Video: Laureate Education, Inc. (Executive Producer). (2009). Information systems management: Data and information management. Baltimore: AuthorCourse Text: Wager, K. A., Lee, F. W., & Glaser, J. (2013). Health care information systems: A practical approach for health care management (3rd ed.). San Francisco: Jossey-Bass.Chapter 1, "Introduction to Health Care Information"Chapter 2, "Health Care Data Quality "Chapter 9, "Technologies That Support Health Care Information Systems" (read pp. 273–284, "Learning Objectives" through "Data Mining")Course Text: Tan, J. K. H., & Payton, F. C. (2010). Adaptive health management information systems: Concepts, cases, and practical applications. Sudbury, MA: Jones and Bartlett.Technology Brief IV, "Database, Data-Mining, and Data-Warehousing Concepts for Healthcare Services Organizations" (read pp. 133–141)Article: Kaipa, P. (2000). Knowledge architecture for the twenty-first century. Behaviour & Information Technology, 19(3), 153–161.Retrieved from http://ezp.waldenulibrary.org/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=lxh&AN=3961794&site=ehost-live&scope=siteArticle: Amatayakul, M. (2008). Good data stewardship makes good cents. Healthcare Financial Management, 62(2), 122–124. Retrieved from http://ezp.waldenulibrary.org/login?url=http://search.ebscohost.com/login.aspx?direct=true&db=mnh&AN=18309603&site=ehost-live&scope=site

Tags: Best Online Essay Writers - Thesis and Dissertation Help, Custom Dissertation Writing Services for PhD Students, Essay USA, UK - Cheap Essay Writing Service