Derive a set of relations in third normal form (3NF), using the data shown in Figure 1 below.

Clearly show each step of normalisation 1NF, 2NF and 3NF in your answer. Show all primary keys in each relation with a solid underline and foreign keys with a dashed underline or with clear labels. You may add attributes as needed before starting the process if you explain them clearly. State your assumptions in your answer if needed.

Bill number 34687421 Bill date 2/28/16 Date admitted 2/14/16 Discharge date 2/17/16 Patient # 8624 Patient Name Joanna Doe Patient Address 3200 Oak Avenue Boulder, NC 28223 Cost Date Cost Center Item Code Description Balance Name Charge Charged Due Room & 100 200.00 2/14/16 Board 10000 Semi-private room 2/14/16 10050 Television 25.00 2/15/16 10000 Semi-private room 260.00 2/16/16 10000 Semi-private room 270.00 Subtotal 755.00 110 Laboratory 2/14/16 11080 Glucose 75.00 2/15/16 11055 Culture 78.00 Subtotal 153.00 125 Radiology 2/15/16 12530 X-ray chest 130.00 Subtotal 130.00 Balance due1038.00 Bill number 34687421 Bill date 2/28/16 Date admitted 2/14/16 Discharge date 2/17/16 Patient # 8624 Patient Name Joanna Doe Patient Address 3200 Oak Avenue Boulder, NC 28223 Cost Date Cost Center Item Code Description Balance Name Charge Charged Due Room & 100 200.00 2/14/16 Board 10000 Semi-private room 2/14/16 10050 Television 25.00 2/15/16 10000 Semi-private room 260.00 2/16/16 10000 Semi-private room 270.00 Subtotal 755.00 110 Laboratory 2/14/16 11080 Glucose 75.00 2/15/16 11055 Culture 78.00 Subtotal 153.00 125 Radiology 2/15/16 12530 X-ray chest 130.00 Subtotal 130.00 Balance due1038.00