Community Hospital Database
2 pages (500 words)
Secondly, we have the patient treatment table. Notably, it contains information about the patient’s admission and discharge dates. In addition, it contains five fields, that is, patient#, patient name, patient address, date admitted and discharged and the id of the physician. However, in this case, no primary key is needed.