Course Coordinator:Judith Watson (jwatson@usc.edu.au) School:School of Science, Technology and Engineering
UniSC Sunshine CoastUniSC Adelaide |
Blended learning | Most of your course is on campus but you may be able to do some components of this course online. |
Online |
Online | You can do this course without coming onto campus, unless your program has specified a mandatory onsite requirement. |
Please go to unisc.edu.au for up to date information on the
teaching sessions and campuses where this course is usually offered.
Modern day computer systems capture, store and manipulate very large amounts of data, which cannot be adequately stored in traditional relational databases. This course covers the different types of databases available, the type of data that is stored and manipulated by them and which database technology is best to suited to different real-world data problems.
| Activity | Hours | Beginning Week | Frequency |
| Blended learning | |||
| Learning materials – Asynchronous learning material | 2hrs | Week 1 | 12 times |
| Tutorial/Workshop 1 – Synchronous on campus workshop | 2hrs | Week 1 | 12 times |
| Seminar – On campus seminar | 1hr | Week 2 | 2 times |
| Online | |||
| Learning materials – Asynchronous learning material | 2hrs | Week 1 | 12 times |
| Tutorial/Workshop 1 – Synchronous Zoom workshop | 2hrs | Week 1 | 12 times |
| Seminar – Online seminar | 1hr | Week 2 | 2 times |
Database systems
Data modelling
SQL
Big data and NoSQL
700 Level (Specialised)
12 units
| Course Learning Outcomes On successful completion of this course, you should be able to... | Graduate Qualities Completing these tasks successfully will contribute to you becoming... | |
| 1 | Design and implement a database system in a real-world context. |
Knowledgeable Creative and critical thinker |
| 2 | Reflect critically on the ethical and sustainability impact of appropriate data storage and manipulation. |
Ethical Sustainability-focussed |
| 3 | Demonstrate mastery of the theory and practice of database systems. |
Knowledgeable Engaged |
| 4 | Collaborate in a team to design and implement a non-relational database system in real-world data storage context | Engaged |
Refer to the UniSC Glossary of terms for definitions of “pre-requisites, co-requisites and anti-requisites”.
ICT701
Not applicable
Not applicable
Not applicable
Not applicable
Standard Grading (GRD)
| High Distinction (HD), Distinction (DN), Credit (CR), Pass (PS), Fail (FL). |
Formative feedback provided on weekly tutorial exercises. Each week's task builds on skills which are used in all assessment pieces.
| Delivery mode | Task No. | Assessment Product | Individual or Group | Weighting % | What is the duration / length? | When should I submit? | Where should I submit it? |
| All | 1 | Examination - not Centrally Scheduled | Individual | 10% | 1 hour |
Week 4 | Online Test (Quiz) |
| All | 2 | Examination - not Centrally Scheduled | Individual | 40% | 1.5 hours |
Week 8 | Online Assignment Submission with plagiarism check |
| All | 3 | Artefact - Technical and Scientific, and Written Piece | Group | 50% | 1500 words plus code |
Week 12 | Online Assignment Submission with plagiarism check |
| All - Assessment Task 1:Database Management Test | ||||||||||
| Goal: | To demonstrate mastery of core data management concepts, data services, and demonstrating proficiency in implementing and managing data solutions. |
|||||||||
| Product: | Examination - not Centrally Scheduled | |||||||||
| Authorship Statement: | ||||||||||
| Format: | A 1 hour online proctored exam held during your regular week 4 workshop |
|||||||||
| Criteria: |
|
|||||||||
| Generic Skills: | ||||||||||
| All - Assessment Task 2:Relational Database Exam | ||||||||||
| Goal: | To demonstrate the mastery the theory and practice of relational databases |
|||||||||
| Product: | Examination - not Centrally Scheduled | |||||||||
| Authorship Statement: | ||||||||||
| Format: | Individual exam held during your regular week 8 workshop. Submitted via Canvas |
|||||||||
| Criteria: |
|
|||||||||
| Generic Skills: | ||||||||||
| All - Assessment Task 3:Non-Relational Database Group Project | ||||||||||||||||
| Goal: | To collaboratively design and implement a non-relational database system that effectively addresses a real-world data storage and manipulation challenge, ensuring scalability, flexibility, and efficiency. |
|||||||||||||||
| Product: | Artefact - Technical and Scientific, and Written Piece | |||||||||||||||
| Authorship Statement: | ||||||||||||||||
| Format: | A functional database and comprehensive report analysing and providing solutions to the prescribed real-world situation. Additional documentation should include all relevant coding, group meeting minutes and contract. Further specifications will be provided on Canvas. |
|||||||||||||||
| Criteria: |
|
|||||||||||||||
| Generic Skills: | ||||||||||||||||
A 12-unit course will have total of 150 learning hours which will include directed study hours (including online if required), self-directed learning and completion of assessable tasks. Student workload is calculated at 12.5 learning hours per one unit.
Please note: Course information, including specific information of recommended readings, learning activities, resources, weekly readings, etc. are available on the course Canvas site– Please log in as soon as possible.
You need regular access to the resource(s) below. Many texts are available as ebooks through the Library at no additional cost.
| Required? | Author | Year | Title | Edition | Publisher |
| Required | CARLOS. MORRIS CORONEL (STEVEN. CROCKETT, KEELEY.) | 0 | DATABASE PRINCIPLES | 3rd Edition | Cengage |
You must have a computer (Desktop or Laptop) that you can install/access software applications on, in order to be able to practice the skills outside lecture and workshop times.
Academic integrity is the ethical standard of university participation. It ensures that students graduate as a result of proving they are competent in their discipline. This is integral in maintaining the value of academic qualifications. Each industry has expectations and standards of the skills and knowledge within that discipline and these are reflected in assessment.
Academic integrity means that you do not engage in any activity that is considered to be academic fraud; including plagiarism, collusion or outsourcing any part of any assessment item to any other person. You are expected to be honest and ethical by completing all work yourself and indicating in your work which ideas and information were developed by you and which were taken from others. You cannot provide your assessment work to others. You are also expected to provide evidence of wide and critical reading, usually by using appropriate academic references.
In order to minimise incidents of academic fraud, this course may require that some of its assessment tasks, when submitted to Canvas, are electronically checked through Turnitin. This software allows for text comparisons to be made between your submitted assessment item and all other work to which Turnitin has access.
Eligibility for Supplementary Assessment
Your eligibility for supplementary assessment in a course is dependent of the following conditions applying:
(a) The final mark is in the percentage range 47% to 49.4%; and
(b) The course is graded using the Standard Grading scale
Late submissions may be penalised up to and including the following maximum percentage of the assessment task’s identified value, with weekdays and weekends included in the calculation of days late:
(a) One day: deduct 5%;
(b) Two days: deduct 10%;
(c) Three days: deduct 20%;
(d) Four days: deduct 40%;
(e) Five days: deduct 60%;
(f) Six days: deduct 80%;
(g) Seven days: A result of zero is awarded for the assessment task.
The following penalties will apply for a late submission for an online examination:
Less than 15 minutes: No penalty
From 15 minutes to 30 minutes: 20% penalty
More than 30 minutes: 100% penalty
For more information on Academic Learning & Teaching categories including:
For more information, visit https://www.usc.edu.au/explore/policies-and-procedures#academic-learning-and-teaching
UniSC is committed to excellence in teaching, research and engagement in an environment that is inclusive, inspiring, safe and respectful. The Student Charter sets out what students can expect from the University, and what in turn is expected of students, to achieve these outcomes.
For course-specific questions, contact your teaching staff or Course Coordinator.
For other enquiries or to access support, please contact Student Central: