(1) This is an individual assignment. The minimum penalty for plagiarism is loss of marks for this
assignment. If this means that a hurdle requirement is not met, the student fails the course. Please read
http://www.cs.rmit.edu.au/students/integrity/ for further information.
(2) For SQL; In the course of marking, queries may be tested on the database. Queries that do not
execute without producing errors will receive very low marks (ie <50%). Please test your queries before
(3) For SQL; It is frequently possible to write two queries that will produce the same result, however one
is logically correct but the other is logically incorrect. Just getting the correct output will not get full
marks. It is important that the logic of your query is also correct. Incorrect logic will result in a poor
(4) For SQL; It is also possible to write two queries that produce the correct result and are also logically
correct but one is significantly more complex and convoluted. Excessive/un-necessary complexity results
in reduced marks.
Late Submission Penalty: WebLearn will remain open for 5 days after the Due Date for late
submissions. A late submission incurs a penalty of 10% the total marks available for the assignment per
day or part day late. As an Example, an assignment submitted at 2AM on Tuesday morning will incur a
20% penalty. Submission more than 5 days late will not be accepted.Briefly explain each of the following database terms. Use no more than 2-3 lines for
1. Deletion Anomaly
2. Domain Constraint
The Join operation in SQL joins the data for from two table to make one intermediate table. Join
expressions can be complex with multiple conditions to control the joining of tupples.
In addition to standard joins, there are also specialiased Joins available.
For this task, you have to find out what a “Right Join” is.
There are two parts requires in your answer.
• First describe what a Right Join does and what output it produces.
• Second is to given an example of when a right join woud be useful.
Note that you do not need to write any SQL to answer this question.
In most cases, you should be able to complete this question in a couple of paragraphs. Any
answer over half a page long will attract a deduction.
There is no requirement to supply references for this question.
( This space has been intentionally left blank.)
Database Concepts Study Period 2 Assignment 2 Page 3 of 8 Due : 11:59, Sunday 10th August 2014Question 2. ER (25 Marks)
Members of a charity club raise money for projects by running fund raising events. To help run
these events, corporations get involved and help with sponsorship. This database helps track all
the information required.
• The club runs different types of events and each event is given an event id and and name.
• All projects have unique titles. A description for each project will be kept in the database.
• Each event is sponsored by one corporation and raises money for one project.
• A corporation can sponsor many events.
• Corporations involved with the club give their name, Australian Business Number and
• Many events will be run in support of each project.
• Members of the club volunteer to work on events. Typically, each member will work on
several events at the same time. Of course, each event needs many members to run
• For tax purposes, the amount of sponsorship a corporation supplies for each event for
each project must be recorded.
• Each event must be managed. One member will be allocated to this task, for each event.
Once a member has been allocated to manage an event, that member cannot manage
any other events.
• All members are in the database. Their membership number, first name, last name and
date of birth are recorded.
Draw an ER Diagram that reflects these requirements. You must only use the symbols used in that reflects these requirements. You must only use the symbols used in