A Hospital wants to create a database to store records of its patients. For each patient the existing hospital record information as given below:

Patient ID:	P101		Bill Date:	Smith
Patient Name:	Sean		Date admitted:	01/11/2020
Patient Address:	123 Bourke Street, Melbourne, VIC 3000		Discharge date:	2/11/2020
Charged for	Date	Item No.	Description	Charge
Room	1/11/2020	R001	Semi-Private Room	$145.00
	2/11/2020	R002	Semi-Private Room	$145.00
Laboratory	1/11/2020	M003	X-ray chest	$50.00
		M001	Glucose	$70.00
	2/11/2020	M003	X-ray chest	$50.00

The un-normalised table (called Patient) that corresponds to the above format is as follows:

Patient (Patient_ID, Patient_Name, Patient_Address, Bill_date, Patient_admitted_date, Patient_discharge_date, Charged_fro, Charged_date, Item_no, Desciption, Amount_Charged)

Where required, you may make assumptions. However, your assumptions should not contradict the above situation and all assumptions should be stated in your answer.