Database Management Systems
Enrolments for this year have closed. Keep exploring subjects.
Online and other materials
Subjects may require attendance
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.
QS RANKING 2020
Times Higher Education Ranking 2020
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 have successfully completed the following subject(s) before starting this subject:
COSC210 requires a knowledge of, and programming experience with, a high level programming language. AMTH140 is a recommended unit. Experience with the use of the Linux/UNIX operating system is highly recommended.
- EquipmentDetails - 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).
- SoftwareDetails - 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
- TravelDetails - Travel may be required to attend the Final Examination for this subject.
- OtherDetails -
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 almost every area of society produces vast amounts of data. Appropriate management of this data is essential for it to be effectively used for decision making processes and value-adding activities.
This subject provides an introduction to the concepts of database design from the conceptual level through to the physical level within database management systems. Students will study relational databases and learn how to model, create and efficiently query them using Structured Query Language (SQL). Further to this, relational algebra will be introduced to provide a more generalised definition of data and queries within relational database systems. The concepts of functional dependency, normalisation and relational decomposition will be introduced to promote sound database design to avoid redundancy. The subject will introduce approaches for connecting external applications to databases and provide awareness of security issues involved with data access. Further database topics including, query processing, transaction management and database security will be covered to provide students with a solid understanding of the techniques that underpin modern database management systems. Students will also gain experience in the design of object oriented and spatial databases.
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 (LOs) 1, 2, 4, 5, 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 (LOs) 1, 2, 4, 5, 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 (LOs) 1, 2, 4, 5 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 (LOs) 2, 3, 4, 5, 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 (LOs) 2, 3, 4, 5, 6 Final Examination: 2 hrs 15 mins. It is mandatory to pass this component in order to pass the unit. Relates to Learning Outcomes (LOs) 1, 2, 4, 5, 6 There is a supervised exam at the end of the teaching period in which you are enrolled. The paper-based exam will be held at an established exam venue, and coordinated by UNE Exams Unit. 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 (10%)
- Assessment 2 (10%)
- Assessment 3 (10%)
- Assessment 4 (10%)
- Final Examination (50%)