Normalization of DataDescriptionThe transition into digitized data storage and access systems in health care requires a general adjustment in data capturing techniques. In the days of paper records, redundancy was a standardinformation was written and rewritten with each patient visit. Digitized data storage and the normalization of data can help reduce this redundancy. Ideally, a patient can enter a facility and information previously submitted is readily available. The provider can simply apply updates and make adjustments to the information as necessary. This saves the health care provider time and the organizations information system space. Additionally, this decrease of data input can lead to improved quality and patient safety as fewer diagnostic errors associated with navigating a patients information are less likely to occur.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