Database Management Systems
Your upfront cost: $0
- 27 Feb 2023
The University of New England is the only Australian public university to be awarded the maximum 5 stars for Overall Experience by the Good Universities Guide, 13 years in a row. UNE has delivered distance education since 1955—that’s longer than any other Australian university. Perhaps that’s why students continue to rate UNE so highly for student satisfaction and teaching quality. With over 170 degrees offered online, and more than 20,000 online students, UNE is the expert in online education.
Learn more about UNE.
QS Ranking 2022
Times Higher Education Ranking 2022
Our student advisors are here to guide you with:
- Enrolling and eligibility
- Fee and loan information
- Credit and recognition for prior learning
Upon completion of this subject, students will be able to:
describe the essential components of database management systems (DBMS) and apply data modelling approaches to design databases for real-world scenarios;
explain the principles of the relational model, implement databases using a relational DBMS and understand the architectures that allow application software to use data stored within a database schema;
work with data stored in a relational DBMS by applying SQL to create database tables, extract, present and modify data, and implement integrity that reflect business logic;
understand and apply the principles of normalisation and functional dependencies to assess and optimise a relational schema;
explain the concepts of transaction management, query processing, physical storage and database indexing; and
explain the societal issues around information privacy, as they relate to the storage and dissemination of data, and apply views and permissions to implement security constraints.
- Topics will be available to enrolled students in the subjects Learning Management System site approximately one week prior to the commencement of the teaching period.
You must either have successfully completed the following subject(s) before starting this subject, or currently be enrolled in the following subject(s) in a prior study period; or enrol in the following subject(s) to study prior to this subject:
- UNE-COSC110-Introduction to Programming and the UNIX Environment
- UNE-SCI210-Introduction to Scientific Programming
Please note that your enrolment in this subject is conditional on successful completion of these prerequisite subject(s). If you study the prerequisite subject(s) in the study period immediately prior to studying this subject, your result for the prerequisite subject(s) will not be finalised prior to the close of enrolment. In this situation, should you not complete your prerequisite subject(s) successfully you should not continue with your enrolment in this subject. If you are currently enrolled in the prerequisite subject(s) and believe you may not complete these all successfully, it is your responsibility to reschedule your study of this subject to give you time to re-attempt the prerequisite subject(s)
Candidature in Diploma in Information Technology or Diploma in Science. To enrol in this subject you will need to pass the Prerequisite/s. Please note as UNE results are released after the close of enrolment date, your enrolment into this subject will be withdrawn if you do not pass the prerequisite subject/s. UNE-COSC210 requires a knowledge of, and programming experience with, a high level programming language. UNE-AMTH140 is a recommended unit. Experience with the use of the Linux/UNIX operating system is highly recommended.
- Equipment requirements - Headphones or speakers (required to listen to lectures and other media) Headset, including microphone (highly recommended) Webcam (may be required for participation in virtual classrooms and/or media presentations).
- Software requirements - It is essential for students to have reliable internet access in order to participate in and complete your units, regardless of whether they contain an on campus attendance or intensive school component. For additional information please visit UNE Hardware Requirements: https://www.une.edu.au/current-students/support/it-services/hardware
- Other requirements -
Textbook information is not available until approximately 8 weeks prior to the commencement of the Teaching period.
Students are expected to purchase prescribed material.
Textbook requirements may vary from one teaching period to the next.
The widespread application of digital information systems in society today produces vast amounts of data. Appropriate management of this data is essential for it to be an effective tool for decision making and value adding. Introducing you to the concepts of database design, this subject takes you from the conceptual level through to the physical level of database management systems, developing your understanding of the techniques underpinning these systems. You will study relational databases and learn how to model, create and efficiently query them using Structured Query Language (SQL), using relational algebra to provide more generalised data and query definitions within relational database systems. Design strategies to avoid redundancy, concepts of functional dependency, normalisation and relational decomposition are examined. Exploring approaches for connecting external applications to databases, you will also gain an awareness of security issues involved with data access.
Online Quizzes: 5 online quizzes worth 2% each. An overall mark of 50% across all assessment tasks is required to pass the unit. Relates to Learning Outcomes 1-2, 4-6 Assessment 1: Theory assignment 1. All assessment tasks must be attempted. An overall mark of 50% across all assessment tasks is required to pass the unit. 500 words. Relates to Learning Outcomes 1-2, 4-6 Assessment 2: Theory assignment 2. All assessment tasks must be attempted. An overall mark of 50% across all assessment tasks is required to pass the unit. 500 words. Relates to Learning Outcomes 1-2, 4-6 Assessment 3: Practical assignment 1. All assessment tasks must be attempted. An overall mark of 50% across all assessment tasks is required to pass the unit. Relates to Learning Outcomes 2-6 Assessment 4: Practical assignment 2. All assessment tasks must be attempted. An overall mark of 50% across all assessment tasks is required to pass the unit. Relates to Learning Outcomes 2-6 Final Examination: 2 hrs 15 mins. It is mandatory to pass this component in order to pass the unit. Relates to Learning Outcomes 1-2, 4-6 UNE manages supervised exams associated with your UNE subjects. Prior to census date, UNE releases exam timetables. They’ll email important exam information directly to your UNE email address.
- Online Quizzes (10%)
- Assessment 1 - Theory assignment (10%)
- Assessment 2 - Theory assignment (10%)
- Assessment 3 - Practical assignment (10%)
- Assessment 4 - Practical assignment (10%)
- Final Examination - 2 hrs 15 mins (50%)
Current study term: 26 Feb 23 to 09 Jun 23
Check the learning management system (LMS) of your university for textbook details.