Useful links
We are aiming for an incremental return to campus in accordance with guidelines provided by NSW Health and the Australian Government. Until this time, learning activities and assessments will be planned and scheduled for online delivery where possible, and unit-specific details about face-to-face teaching will be provided on Canvas as the opportunities for face-to-face learning become clear.
Unit of study_
COMP9120: Database Management Systems
This unit of study provides a conceptual and practical introduction to the use of common platforms that manage large relational databases. Students will understand the foundations of database management and enhance their theoretical and practical knowledge of the widespread relational database systems, as these are used for both operational (OLTP) and decision-support (OLAP) purposes. The unit covers the main aspects of SQL, the industry-standard database query language. Students will further develop the ability to create robust relational database designs by studying conceptual modelling, relational design and normalization theory. This unit also covers aspects of relational database management systems which are important for database administration. Topics covered include storage structures, indexing and its impact on query plans, transaction management and data warehousing. In this unit students will develop the ability to: Understand the foundations of database management; Strengthen their theoretical knowledge of database systems in general and relational data model and systems in particular; Create robust relational database designs; Understand the theory and applications of relational query processing and optimisation; Study the critical issues in data and database administration; Explore the key emerging topics in database management.
| Code | COMP9120 |
|---|---|
| Academic unit | Computer Science |
| Credit points | 6 |
|
Prerequisites:
?
|
None |
|---|---|
|
Corequisites:
?
|
None |
| Prohibitions:
?
|
INFO2120 OR INFO2820 OR INFO2005 OR INFO2905 OR COMP5138 OR ISYS2120. Students who have previously studied an introductory database subject as part of their undergraduate degree should not enrol in this foundational unit, as it covers the same foundational content. |
| Assumed knowledge:
?
|
Some exposure to programming and some familiarity with data model concepts |
At the completion of this unit, you should be able to:
- LO1. demonstrate a basic understanding of the design of database solutions to data management problems
- LO2. understand the transaction concept and its role in transaction processing systems
- LO3. demonstrate competence in the use of SQL
- LO4. index databases and query optimisation.
Unit outlines
Unit outlines will be available 2 weeks before the first day of teaching for 1000-level and 5000-level units, or one week before the first day of teaching for all other units.
There are no unit outlines available online for previous years.
- Key dates
Key dates through the academic year, including teaching periods, census, payment deadlines and exams.
- Student administration
Enrolment, course planning, fees, graduation, support services, student IT
- Expectations of student conduct
Code of Conduct for Students, Conditions of Enrollment, University Privacy Statement, Academic Integrity
- Academic appeals
Academic appeals process, special consideration, rules and guidelines, advice and support
- Learning and teaching policy
Policy register, policy search
- Financial support
Scholarships, interest free loans, bursaries, money management
- Study resources
Learning Centre, faculty and school programs, Library, online resources
- Health and support
Student Centre, counselling & psychological services, University Health Service, general health and wellbeing
