Database Systems: Design and Online

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

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET AN AMAZING DISCOUNT 🙂