Expert answer:Normalization of Data

Expert answer:Consider the following scenario:You have recently been hired by a small community hospital as a nurse informaticist. One of your first responsibilities is to help to convert records to an electronic format. You decide to address the process of ordering medicine for patients and you need to develop a database to address the issue. Currently all of the patient information is contained in an Excel spreadsheet, which contains the following categories: PATIENT ORDER, PATIENT medical record number (MRN), PATIENT Name, Order Number, MEDICATION Name, MEDICATION Description, Quantity, PATIENT Address, and Date Ordered. In designing your database, you need to normalize the data in order to remove redundancies and duplications. What approach will you take to normalize the data?Note: A PATIENT can have multiple orders but an order can be for only one MEDICATION. Patient medical record number (MRN) and Order Number are the primary keys.To prepare:Review the information in your course text, Database Systems: Design, Implementation, and Management on how to normalize data.What form of normalization would use (1NF, 2NF, 3NF)?Illustrate the normalized form for PATIENT ORDER.Reflect on the issues you encountered as you attempted to normalize the list.Consider the consequences of not normalizing data.By Day 3Post a brief description of how you would normalize the data from the scenario and your rationale. Describe the challenges that you encountered in determining how to normalize the data. Explain the possible consequences of failing to normalize data.References:Coronel, C. & Morris, S. (2017). Database systems: Design, implementation, and management (12th ed.). Boston, MA: Cengage Learning. Chapter 6, “Normalization of Database Tables” (pp. 201-234)Chute, C. G., Beck, S. A., Fisk, T. B., & Mohr, D. N. (2010). The Enterprise Data Trust at Mayo Clinic: A semantically integrated warehouse of biomedical data. Journal of American Medical Informatics Association, 17(2), 131–135. Westra, B. L., Subramanian, A., Hart, C. M., Matney, S. A., Wilsom, P. S., Huff, S., Huber, D. L., & Delaney, C. W. (2010). Achieving “meaningful use” of electronic health records through the integration of the nursing management minimum data set. The Journal of Nursing Administration, 40(7/8), 336–343.

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades