This course provides you with advanced database concepts including advanced SQL and industrial database application domains. The course expands on topics in ICT211, adds advanced SQL concepts and develops practical database programming skills. It begins with a review of the database environment, adding indexes and optimisation. The second part of the course focuses on applying the skills to real world applications including integrating databases with applications, big data, and graphing and geo-spatial databases.
|Learning materials – Pre-recorded concept videos and associated activity||1hr||Week 1||12 times|
|Tutorial/Workshop 1 – In-class tutorial||2hrs||Week 1||13 times|
|Online – Pre-recorded concept videos and associated activity||1hr||Week 1||12 times|
|Tutorial/Workshop 1 – Interactive zoom tutorial||2hrs||Week 2||11 times|
Review – Data models and ER modeling
Advanced SQL – procedures, functions, triggers, views
Advanced SQL – performance tuning and query optimisation
Distributed database management systems
Introduction to Big data and NoSQL
Key-value databases – Redis
Graphing databases – Neo4j
Document databases – MongoDB
300 Level (Graduate)
|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||Creation of systems.||Creative and critical thinker|
|2||Apply initiative to solving problems competently in the discipline.||
Creative and critical thinker
|3||Apply written communication skills to specific problems.||
|4||Apply discipline specific knowledge and skills to problems.||
Creative and critical thinker
|5||Understand sustainability issues within the discipline.||Sustainability-focussed|
Refer to the USC Glossary of terms for definitions of “pre-requisites, co-requisites and anti-requisites”.
ICT211 and ICT112
Standard Grading (GRD)
|High Distinction (HD), Distinction (DN), Credit (CR), Pass (PS), Fail (FL).|
Early feedback will be provided in the weekly workshops.
|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||20%||
|Week 5||Online Assignment Submission with plagiarism check|
|All||2||Examination - not Centrally Scheduled||Individual||40%||
|Week 12||Online Test (Quiz)|
|All||3||Artefact - Technical and Scientific, and Written Piece||Individual||40%||
|Exam Period||Online Assignment Submission with plagiarism check|
|All - Assessment Task 1:Database Programming|
Demonstrate understanding of database programming
|Product:||Examination - not Centrally Scheduled|
An examination will be held in week 5. This is an individual assessment in which you will demonstrate knowledge of database programming.
|All - Assessment Task 2:Database Exam|
Demonstrate knowledge of databases and database programming.
|Product:||Examination - not Centrally Scheduled|
This is an individual assessment in which you will demonstrate knowledge of databases.
|All - Assessment Task 3:Written report and database code/file.|
Insightful analysis of the given problem Design completeness and accuracy Correctness and completeness of the implementation of code Effective written communication and report presentation
|Product:||Artefact - Technical and Scientific, and Written Piece|
Written report and database code/file.
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. Directed study hours may vary by location. 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.
Please note that you need to have regular access to the resource(s) listed below. Resources may be required or recommended.
|Required||Carlos Coronel,Steven Morris||2018||Database Systems: Design, Implementation, & Management||n/a||Cengage Learning|
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: The final mark is in the percentage range 47% to 49.4% The course is graded using the Standard Grading scale You have not failed an assessment task in the course due to academic misconduct
Late submission of assessment tasks may be penalised at the following maximum rate: - 5% (of the assessment task's identified value) per day for the first two days from the date identified as the due date for the assessment task. - 10% (of the assessment task's identified value) for the third day - 20% (of the assessment task's identified value) for the fourth day and subsequent days up to and including seven days from the date identified as the due date for the assessment task. - A result of zero is awarded for an assessment task submitted after seven days from the date identified as the due date for the assessment task. Weekdays and weekends are included in the calculation of days late. To request an extension you must contact your course coordinator to negotiate an outcome.
USC is committed to a culture of respect and providing a safe and supportive environment for all members of our community. For immediate assistance on campus contact SafeUSC by phone: 07 5430 1168 or using the SafeZone app. For general enquires contact the SafeUSC team by phone 07 5456 3864 or email firstname.lastname@example.org.
For help with course-specific advice, for example what information to include in your assessment, you should first contact your tutor, then your course coordinator, if needed.
If you require additional assistance, the Learning Advisers are trained professionals who are ready to help you develop a wide range of academic skills. Visit the Learning Advisers web page for more information, or contact Student Central for further assistance: +61 7 5430 2890 or email@example.com.
Student Wellbeing provide free and confidential counselling on a wide range of personal, academic, social and psychological matters, to foster positive mental health and wellbeing for your academic success.
Ability Advisers ensure equal access to all aspects of university life. If your studies are affected by a disability, learning disorder mental health issue, injury or illness, or you are a primary carer for someone with a disability or who is considered frail and aged, AccessAbility Services can provide access to appropriate reasonable adjustments and practical advice about the support and facilities available to you throughout the University.
For more information on Academic Learning & Teaching categories including:
Visit the USC website: https://www.usc.edu.au/explore/policies-and-procedures#academic-learning-and-teaching
USC 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.