In this Task you will build a database to support the needs of Wolverhampton General Hospital, England who are working with local doctors’ surgeries to keep accurate data about the Coronavirus pandemic. The National Health Service (NHS)
Budget: $30 – $250 USD
1. Create a database using Oracle SQL. Populate the tables with appropriate test data, bearing in mind the following:
a. There may be some patients that have yet to be tested for Coronavirus.
b. There may be some patients who have yet to see a doctor.
c. All patients are uniquely identified by a primary key column
d. Records of patients seeing a doctor (known as a surgery consultation) are identified by a combination of foreign keys (not by a single column surrogate key)
e. There may be some patients that are yet to be given medication called naproxen.
Hint: In order to keep the amount of test data to a minimum, we will assume that the company is unlikely to run with more than seven different surgeries and that the number of patients about which they have details is less than
a. There may be some patients that have yet to be tested for Coronavirus.
b. There may be some patients who have yet to see a doctor.
c. All patients are uniquely identified by a primary key column
d. Records of patients seeing a doctor (known as a surgery consultation) are identified by a combination of foreign keys (not by a single column surrogate key)
e. There may be some patients that are yet to be given medication called naproxen.
Hint: In order to keep the amount of test data to a minimum, we will assume that the company is unlikely to run with more than seven different surgeries and that the number of patients about which they have details is less than
Related categories:
Database Programming