Description Data Design Case Study Memorandum [WLOs: 1, 2, 3] [CLOs: 1, 3, 4] Prior to beginning work on this assignment, Read Chapter 9 (pp. 276-281) of Systems Analysis and Design. Review the article Dissecting Genetic Factors Affecting Phenylephrine Infusion Rates During Anesthesia: A Genome-wide Association Study Employing EHR Data (Links to an external site.). Put yourself in the position of the data analyst who is working with both the information technology department and the research team to develop the research data warehouse that will further this important research in the organization discussed in the article. You have been given permission to move forward utilizing resources within the information technology group to begin the process of database design. The information technology project manager has asked you to reflect on the overall design of the database and provide her a list of the type of entities that should be reflected in the new database as well as the nature of the relationships between these entities (one-to-one, one-to-many, or many-to-many). Put together a memo to outline these entities and relationships so that the information technology department can secure the appropriate data administrator in programming resources to begin the technical design of the database. In your memo, Explain the data entities that you see being necessary to design the new research database inclusive of data from the electronic health record, genetic sources and research administration sources. Describe the relationship between these entities in terms of one-to-one, one-to-many, or many-to-many database relationships. Discuss your rationale for the relationships between the proposed entities in this new database design. Describe any error checking or referential integrity programming that you would like included in the overall design of the research database. The Data Design Case Study Memorandum
Select your paper details and see how much our professional writing services will cost.
Our custom human-written papers from top essay writers are always free from plagiarism.
Your data and payment info stay secured every time you get our help from an essay writer.
Your money is safe with us. If your plans change, you can get it sent back to your card.
Check out some essay pieces from our best essay writers before your place an order. They will help you better understand what our service can do for you.
We offer more than just hand-crafted papers customized for you. Here are more of our greatest perks.
Get instant answers to the questions that students ask most often.See full FAQ