I am having trouble with this lab and can't figure it out, please help!

Lab #5: Hospital Database CSCI 2153

Design a database that will take care of the following requirements for a hospital database. You will design using DDL and also draw the DBSD.

The hospital is organized into wards. Each ward has a code, a name, number of beds and nightly cost. The hospital staff is assigned to work a specific ward. We store each staff members employee number, name, shift and salary. The doctors arent assigned to a single ward, theyre assigned to patients. Doctors have a specialty, which we track as well as their name and doctors license number.

Patients have a single attending physician but can have multiple consulting physicians. We need to store each patients registration number, name, address, birth date, sex, social security number. We also need to track the test run on each patient. Each test has a test code, type, date ordered, time ordered, specimen number, status, result and cost.

The total cost for the patient needs to be itemized by room and test charges. This information will be used to create an invoice for the patient. In addition to the line item charges, the total bill also needs to be stored.

Additional Notes: A room is in a single ward and all rooms within a ward have the same cost. A patient can be admitted to the hospital more than once (i.e. appendectomy in July 2019, stoke in October 2019). For each stay the patient has an admitted date, a discharge date and a total cost. The total cost is a combination of the room and test charges. The room and test charges do not necessarily need to be stored because they can be calculated. However, you may want to include them if theyd be needed often in reports or in an application for speed considerations.

There should be at minimum 10 tables!