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

Clearly show each step of normalisation 1NF, 2NF and 3NF in the answer.

Remember to show all primary keys in each relationship with a solid underline and foreign keys with a dashed underline or with clear labels. May add attributes as needed before starting the process if explain them clearly. State assumptions if needed.

Charge 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 Name Charged Room & 100 2/14/16 10000 Semi-private room Board 2/14/16 10050 Television 2/15/16 10000 Semi-private room 2/16/16 10000 Semi-private room Balance Due 200.00 25.00 260.00 110 Laboratory 2/14/16 2/15/16 11080 11055 Glucose Culture 270.00 Subtotal 755.00 75.00 78.00 Subtotal 153.00 130.00 Subtotal 130.00 Balance due 1038.00 125 Radiology 2/15/16 12530 X-ray chest Charge 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 Name Charged Room & 100 2/14/16 10000 Semi-private room Board 2/14/16 10050 Television 2/15/16 10000 Semi-private room 2/16/16 10000 Semi-private room Balance Due 200.00 25.00 260.00 110 Laboratory 2/14/16 2/15/16 11080 11055 Glucose Culture 270.00 Subtotal 755.00 75.00 78.00 Subtotal 153.00 130.00 Subtotal 130.00 Balance due 1038.00 125 Radiology 2/15/16 12530 X-ray chest