Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started