Course Coordinator:Judith Watson (jwatson@usc.edu.au) School:School of Science, Technology and Engineering
UniSC Sunshine CoastUniSC Moreton Bay |
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. |
Please go to usc.edu.au for up to date information on the
teaching sessions and campuses where this course is usually offered.
This course introduces you to the major concepts, methodologies, tools and techniques that are required to analyse, design, and develop well-structured databases for modern organisations. Data modelling using entity-relationship diagrams is taught and applied. You will then use a DBMS to gain an appreciation of the concepts and practical application of database management systems. SQL is covered to complete the cycle of professional practice.
Activity | Hours | Beginning Week | Frequency |
Blended learning | |||
Learning materials – Pre-recorded concept videos and associated activity | 1hr | Week 1 | 13 times |
Tutorial/Workshop 1 – In-class tutorial | 2hrs | Week 1 | 13 times |
Seminar – On campus Seminar | 1hr | Week 2 | 3 times |
Online | |||
Learning materials – Pre-recorded concept videos and associated activity | 1hr | Week 1 | 13 times |
Tutorial/Workshop 1 – Interactive zoom tutorial | 2hrs | Week 1 | 13 times |
Seminar – Online seminar | 1hr | Week 2 | 3 times |
Introduction to databases and database modelling
Entity Relationship Modelling - concepts and application
Relational Schema methodology
Normalisation
Introduction to SQL and translating Relational Schema to SQL
SQL – DDL
SQL – DML
SQL – Joins, Views & Transactions
SQL Stored Procedures – Procedures and functions
SQL Stored Procedures – Triggers & Cursors
Distributed databases
Client/server systems
200 Level (Developing)
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 | Creation of systems. | Creative and critical thinker |
2 | Apply initiative to solving problems competently in the discipline. | Empowered |
3 | Apply communication skills to specific problems. | Engaged |
4 | Apply discipline specific knowledge and skills to problems. | Knowledgeable |
5 | Understand sustainability issues within the discipline. | Sustainability-focussed |
Refer to the UniSC Glossary of terms for definitions of “pre-requisites, co-requisites and anti-requisites”.
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 in weekly workshop exercises and in class discussions.
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% | 1 hour |
Week 5 | Online Test (Quiz) |
All | 2 | Examination - not Centrally Scheduled | Individual | 30% | 2 hours |
Week 10 | Online Submission |
All | 3a | Artefact - Creative, and Written Piece | Individual | 30% | 1000 words |
Week 7 | Online Assignment Submission with plagiarism check |
All | 3b | Artefact - Creative, and Written Piece | Individual | 20% | 1000 Words |
Week 13 | Online Assignment Submission with plagiarism check |
All - Assessment Task 1:Mid Semester Exam | ||||||||||
Goal: | Demonstrate course content understanding. |
|||||||||
Product: | Examination - not Centrally Scheduled | |||||||||
Format: | This is an individual assessment. See Canvas for more detailed information about this assessment. |
|||||||||
Criteria: |
|
|||||||||
Generic Skills: |
All - Assessment Task 2:Database Exam | |||||||
Goal: | Demonstrate course content understanding. |
||||||
Product: | Examination - not Centrally Scheduled | ||||||
Format: | This is an individual exam. See Canvas for more detailed information about this assessment. |
||||||
Criteria: |
|
||||||
Generic Skills: |
All - Assessment Task 3a:Database design | |||||||||||||
Goal: | Evaluate and solve a business data problem. |
||||||||||||
Product: | Artefact - Creative, and Written Piece | ||||||||||||
Format: | Report |
||||||||||||
Criteria: |
|
||||||||||||
Generic Skills: |
All - Assessment Task 3b:Database Creation | |||||||||||||
Goal: | Demonstrate ability to create and manipulate a database using SQL. |
||||||||||||
Product: | Artefact - Creative, and Written Piece | ||||||||||||
Format: | This is an individual assessment. |
||||||||||||
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.
Please note that you need to have regular access to the resource(s) listed below. Resources may be required or recommended.
Required? | Author | Year | Title | Edition | Publisher |
Required | Carlos Coronel,Steven Morris | 2018 | Database Systems: Design, Implementation, & Management | 13th ed | Cengage Learning |
Not applicable
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.
UniSC 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 SafeUniSC by phone: 07 5430 1168 or using the SafeZone app. For general enquires contact the SafeUniSC team by phone 07 5456 3864 or email safe@usc.edu.au.
The SafeUniSC Specialist Service is a Student Wellbeing service that provides free and confidential support to students who may have experienced or observed behaviour that could cause fear, offence or trauma. To contact the service call 07 5430 1226 or email studentwellbeing@usc.edu.au.
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 studentcentral@usc.edu.au.
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.
To book a confidential appointment go to Student Hub, email studentwellbeing@usc.edu.au or call 07 5430 1226.
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.
To book a confidential appointment go to Student Hub, email AccessAbility@usc.edu.au or call 07 5430 2890.
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.