Question

CASE 3-18 O Normalization of Data Fields You have recently been hired at Black Hills Hospice to help with report generation. On your first day, you start investigating the databases that you will be working with. You see room for improvement in the first database that you look at-human resources. This database does not include payroll. Normalize the data fields to allow for more flexibility in reporting. Identify gaps in the human resources data between what is collected and what is needed by the HIM director. Complete Table 3-6 with the recommended normalized fields. This table is also available on the student companion website for your use. Normalized Data Fields TABLE 3-6 Normalization of Data Fields Original Data Fields Full name Address City, state, zip Phone Social Security number Race Gender Degree/major Date of last evaluation Department Start date Credentials

Answer 1

Answer:

Original data fields	Normalized data fields
Full name	Full name
Address	place of residence city
City,state,zip	state,zip city.
Phone	postal code phone contact number
Social security number	socail security number
Race	nationality
Gender	either of two sexes
Degree/major	degree
Date of last evaluation	last evaluated date
Department	courses
Start date	joining date
Credentials	scores