Assignment 2
? To perform queries on a relational database system using SQL;
? To demonstrate an advanced knowledge of stored procedures, stored functions and triggers.
This is an individual assignment. You are not permitted to work as a group when writing
this assignment.
Copying, Plagiarism: Plagiarism is the submission of somebody else’s work in a manner that
gives the impression that the work is your own. The Department of Computer Science and
Computer Engineering treats plagiarism very seriously. When it is detected, penalties are strictly
imposed.
No extensions will be given: Penalties are applied to late assignments (5% of total assignment
mark given is deducted per day, accepted up to 5 days after the due date only). If there are
circumstances that prevent the assignment being submitted on time, an application for special
consideration may be made. See the departmental Student Handbook for details. Note that delays
caused by computer downtime cannot be accepted as a valid reason for a late submission without
penalty. Students must plan their work to allow for both scheduled and unscheduled downtime.
SUBMISSION GUIDELINES:
Task 1 should be saved to a file named task1.txt using the SPOOL command.
Task 2 should be saved to a file named task2.txt using the SPOOL command.
Task 3 should be saved to a file named task3.txt using the SPOOL command.
Note an example of using the SPOOL command is given in the lab book. In the SPOOL file, you
need to provide the query/procedure/function/trigger execution and the sample output. For the
trigger, you need to show a sample test that demonstrates the successful execution of the trigger.
All the tasks above are to be submitted in hard-copy format to the relevant submission box
on the first floor of the Beth Gleeson Building by 9.30am Tuesday, June 4
th
, 2013. The same
tasks above are also required to be submitted online via the Assignment Submission on the
LMS by 9.30am Tuesday, June 4

Writer to Work on this Paper and Give you an A+ 100 % Original Paper?