The assignment submission is via ELEARN. Your answers must in the form of a screenshot that consists of both the SQL query and the result display/table.
computer science
Description
Instructions:
|
1. |
SCRIPT Please download hospital_db.txt
script from eLearn
(folder COURSEWORK). The downloaded version is currently not
working, and you are expected to fix it in order to create and populate TimTam Hospital database. The given
data in the script is a sample data for TimTam
Hospital database. |
|
2. |
SUBMISSION The assignment
submission is via ELEARN. Your answers must in the form of a screenshot that
consists of both the SQL query and the result display/table. Ensure that the
background of the screenshots is in white
colour. |
|
3. |
Each part of your assignment should be clearly labelled
to identify the question that is being answered. |
|
4. |
Queries should be written so that they would work with
all reasonable sets of test data, not just that which has been supplied (do
not, for example, assume that there are only two surgeons). |
|
5. |
When a question asks for information related to a
person or an operation type, a hospital ward or whatever by name, your SELECT
statement should contain that name. Do
not look up the corresponding PERSON_ID, etc and use that result in
your answer. SELECT birth_date FROM person WHERE surname
=’Smith’ AND first_name=’Buddy’; and not the
following, even it produces the same result. SELECT birth_date FROM person WHERE person_id
=’124’; 50% MARKS WILL BE DEDUCTED FOR SUCH VIOLATION |
|
6. |
Marks may be deducted if your SQL is excessively
complicated. |
