Page 1 of 4
RMIT Classification: Protected
Database Concepts
ISYS3412 Practical Database Concepts/ISYS1055 Database Concepts
Assignment 2 – SQL
Assessme
nt Type
Individual assignment; no group work. Submit online via Canvas → Assignments →
Assignment 2. Clarifications/updates may be made via announcements/relevant discussion
forums.
Due Date Week 8 in-class exercise.
Please attend your respective practical session to work on this assignment, such that you have
an opportunity to seek clarification on questions (if any) from the tutors. Alternatively, if you
really cannot attend your own practical session, you can still start answering the questions
yourself, any time from Monday 00:00 to Friday 23:59 of Week 8, AEST time.
You are given two hours to finish this assignment and submit your answer. Specifically, once you
open the assignment question, the two-hours countdown starts automatically; you cannot
pause/stop and restart again in the two hours.
Marks 30
1. Overview
Database systems are a key technology for the storage, management, manipulation, and retrieval of
structured data. They have an impact on the use of information technology in applications ranging from
banking, to travel bookings, to online shopping. In this assignment you will apply the skills and concepts
that you have learned about database systems in the course so far.
2. Assessment Criteria
This assessment will determine your ability to:
• Follow coding, convention and behavioural requirements provided in this document and in the
lessons.
• Independently solve problems by using database concepts taught over the first several weeks of
the course.
• Understand the relational model.
• Write and understand SQL queries correctly, in both syntax and semantics.
• Meet deadlines.
Seek clarification from your instructor, when needed, via discussion forums.
This assignment is worth 30 marks in total which accounts for 30% of the overall assessment for the course.
The assessment components and weights for the course are:
Assessment 1 Assessment 2 Assessment 3 Assessment 4
10% 30% 20% 40%
3. Learning Outcomes
This assessment is relevant to the following Course Learning Outcomes:
• CLO 5: Apply SQL as programming language to extract data from databases for specific users’
information needs.
Page 2 of 4
RMIT Classification: Protected
It also supports the following Graduate Learning Outcomes:
• Enabling Knowledge: You will gain skills as you apply data modelling knowledge effectively in
diverse contexts.
• Critical Analysis: Analyse and model requirements and constraints for the purpose of designing
and implementing software artefacts and IT systems.
• Problem solving: Design and implement database solutions that accommodate specified
requirements and constraints, based on analysis or modelling or requirements specification.
4. Submission format
Submit your assignment via Canvas→Assignments→Assignment 2.
● Each student should get eight questions to answer (Q1-Q8). Write one SQL query to answer every
question and save your SQL query in Sxxxxxxx_Qy.sql (where Sxxxxxxx is your student number and y is
the question label). For example, when writing the answer of Q1, it should be Sxxxxxxx_Q1.sql.
● It is your responsibility to correctly name and upload your SQL file. Zero mark is given if not
following the file naming instruction.
● Never leave submission to the last minute -- you may have difficulty uploading files.
● You have one attempt only.
● If unexpected circumstances affect your ability to complete the assignment, you can apply for
Special Consideration. Special Consideration will automatically result in an equivalent assessment in the
form of an online test and interview (time to be arranged by the course coordinator).
● More information on special consideration is available at
https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/special-
consideration
5. Assessment declaration
When you submit work electronically, you agree to the assessment declaration:
6. Academic integrity and plagiarism (standard warning)
Academic integrity is about honest presentation of your academic work. It means acknowledging the work
of others while developing your own insights, knowledge and ideas. You should take extreme care that you
have:
• Acknowledged words, data, diagrams, models, frameworks and/or ideas of others you have quoted
(i.e., directly copied), summarised, paraphrased, discussed or mentioned in your assessment
through the appropriate referencing methods,
• Provided a reference list of the publication details so your reader can locate the source if necessary.
This includes material taken from Internet sites.
If you do not acknowledge the sources of your material, you may be accused of plagiarism because you have
passed off the work and ideas of another person without appropriate referencing, as if they were your own.
RMIT University treats plagiarism as a very serious offence constituting misconduct. Plagiarism covers a
variety of inappropriate behaviours, including:
• Failure to properly document a source
• Copyright material from the internet or databases
• Collusion between students
For further information on our policies and procedures, please refer to the University website.
Page 3 of 4
RMIT Classification: Protected
6. Rubric and marking guidelines
• Failure to submit files in the required format results in zero mark.
• Each student should get eight questions to answer. Q1-Q4: 3.5 marks per question; Q5-Q8: 4 marks
per question. Total Mark: 30.
• We use SQLite to test your answer. SQLite is used throughout this course.
• Syntactically incorrect answer (e.g., SQLite could not even parse your query) results in zero mark.
• Semantically incorrect answer results in zero mark. In other words, each question is either granted a
full mark (if it returns the correct answer) or zero mark otherwise; there is no partial mark given.
Note: your program is either correct or has bug, no matter how many (minor) bugs your program has.
• You are given 2-hours countdown once opening the assignment. Failure to submit your answers in
the given 2 hours result in zero marks. We have set a reasonable grace period (which is slightly more
than 2 hours) to help avoid the cases of ‘last-minute’ submission, but students should take
responsibility to get it submitted within 2 hours.
• If unexpected circumstances affect your ability to complete the assignment, you can apply for special
consideration.
o Requests for special consideration of within 7*24 hours please can be via emailing the course
coordinator directly with supporting evidence.
o Request for special consideration of more than 7*24 hours must be via the University Special
consideration: https://www.rmit.edu.au/students/student-essentials/assessment-and-
exams/assessment/special-consideration.
o Special Consideration that extends beyond the release of solutions (typically 1—2 weeks)
will automatically result in an equivalent assessment in the form of an online test and
interview on the same topics (time to be arranged by the course coordinator).
o More information on special consideration is available at
https://www.rmit.edu.au/students/student-essentials/assessment-and-
exams/assessment/special-consideration
Page 4 of 4
RMIT Classification: Protected
7. Database used for Testing Your Answers to this Assignment’s questions
We use the Academics database for this assignment.
Schema for the Academics database is as follows. Primary keys are underlined and foreign keys are marked
with *.
DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode)
ACADEMIC(acnum, deptnum*, famname, givename, initials, title)
PAPER(panum, title)
AUTHOR(panum*, acnum*)
FIELD(fieldnum, id, title)
INTEREST(fieldnum*, acnum*, descrip)
Some notes on the Academic database:
● An academic department belongs to one institution (instname) and often has many academics. An
academic only works for one department.
● Research papers (PAPER) is often authored by several academics, and of course an academic often
writes several papers (AUTHOR).
● A research field (FIELD) often attracts many academics and an academic can have interests in several
research fields (INTEREST).
Important Advice (before you start doing this assignment):
1. Before you do this assignment, we strongly suggest you getting your academics database created at your
end, via the following way: Download the academics.db file, and then choose “Add a database” in SQLite.
2. This .db file will only be available from Week 8 Monday 00:00 to Week 8 Friday 23:59.
3. We use this .db file to test your answers later.
What will happen in Week 7 practical session?
The practical session of Week 7 will be used to help you prepare doing this assignment, where we will provide
you a small database, some exercise questions. The tutors will go through the instructions mentioned in this
specification, and feel free to ask questions during Week 7 practical sessions if any.
学霸联盟