Project description
Your submission should consist of an Oracle SQL print-out of the SQL code which is your solution to the problems above. All code must be visible to receive the marks. Note that marks will be awarded for SQL and PLSQL code which is easy to read and hence easy to debug. Each answer should consist of the following:
o For SQL coding, indication of the question a particular solution refers to, written as a comment e.g. /* Question 1 List the borrowers……*/
o For PLSQL coding the question number is required only.
o The SQL and PLSQL code in its entirety, formatted with indentations so it is easy to read (see code in text book). Please use a reasonable size of font. All code must be present to receive the marks.
o SQL*Plus Screen print to verify that you have executed the code
o The resulting table created from the SQL execution or results from your PLSQL execution. You should copy the results from SQL*Plus. If the output is very long, hand in the first page only. Note that the correct solutions generate small tables. Do not print/hand in unnecessary paper- save trees!
o No cds or similar to be handed in