INN210.1
Assignment Name:
SQL Assignment
Weighting:
20%.
Each of the tasks of this assignment is worth an equal amount. In general, part marks will be given for a partly correct answer, for each of the tasks.
Due Date:
Sunday, 14th September 2014
Rather than leaving it to the last minute, you are strongly encouraged to start working on this assignment at a much earlier stage. The relevant material is covered in Lectures 2 through 6, and in the corresponding practicals.
Students who have little or no Web access at home, and who are not normally on campus on the day the assignment is due, are encouraged to submit their work when they attend classes during the preceding 7 days. (There will …show more content…
But do not resubmit after the due date. Doing so would give you a late penalty, as well as making it likely that the earlier version of your assignment would have marked.
NB: if you resubmit, you must resubmit the whole assignment, not just the bits that have changed. Whenever you resubmit, your entire earlier submission is deleted from the system. For example, if you resubmit only the file
3.sql, it will appear that this is the only part of the assignment you’ve done, so you’ll get no marks for the other parts of the assignment.
(d) General information about submitting assignments using Blackboard is available here. http://www.els.qut.edu.au/blendedlearning/blackboard/students/tipsheets/assignments.jsp (e) A general announcement that the marking has been completed will be placed on Blackboard after about two weeks of the assignment due date.
3 of 6
The Database for this Assignment
It is recommended that you use SqlFire to do this assignment. An SqlFire database for the swimming finals in the
2012 Olympics – named Oly2012.sfdb – is available on Blackboard. Note that you need version 2013.2.0 of SqlFire to open this