Database Management Systems
QS RANKING 2021
Times Higher Education Ranking 2021
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
- Travel requirements - Travel may be required to attend the Final Examination for this subject.
- 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 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 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 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 - 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%)