Skip to main content

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.

Details

Academic unit Computer Science
Unit code COMP9120
Unit name Database Management Systems
Session, year
? 
Semester 2, 2020
Attendance mode Normal evening
Location Camperdown/Darlington, Sydney
Credit points 6

Enrolment rules

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.
Prerequisites
? 
None
Corequisites
? 
None
Assumed knowledge
? 

Some exposure to programming and some familiarity with data model concepts

Available to study abroad and exchange students

No

Teaching staff and contact details

Coordinator Mohammad Masbaul Alam Polash, masbaul.polash@sydney.edu.au
Type Description Weight Due Length
Final exam (Open book) Type C final exam Written Final Exam
50% Formal exam period 2 hours
Outcomes assessed: LO1 LO2 LO3 LO4
Assignment group assignment Conceptual design assignment
10% Week 06 n/a
Outcomes assessed: LO1 LO3
Small test Quiz 1
5% Week 06 25 Minutes
Outcomes assessed: LO1 LO3
Assignment group assignment DB design assignment
15% Week 09 n/a
Outcomes assessed: LO1 LO4 LO3 LO2
Assignment group assignment DB application development assignment
15% Week 12 n/a
Outcomes assessed: LO1 LO4 LO3 LO2
Small test Quiz 2
5% Week 12 25 Minutes
Outcomes assessed: LO1 LO2 LO3 LO4
group assignment = group assignment ?
Type C final exam = Type C final exam ?
  • Assignment: There will be three assignments in total, due in Week 6, 9, and 12 respectively.
  • Quiz: There will be 2 quizzes due on week 6 and week 12. 
  • Final Exam: There will be a written Final Exam during the Final Exam period.

Detailed information for each assessment can be found on Canvas.

Assessment criteria

The University awards common result grades, set out in the Coursework Policy 2014 (Schedule 1).

As a general guide, a high distinction indicates work of an exceptional standard, a distinction a very high standard, a credit a good standard, and a pass an acceptable standard.

Result name

Mark range

Description

High distinction

85 - 100

 

Distinction

75 - 84

 

Credit

65 - 74

 

Pass

50 - 64

 

Fail

0 - 49

When you don’t meet the learning outcomes of the unit to a satisfactory standard.

It is a policy of the School of Computer Science that in order to pass this unit, a student must achieve at least 40% in the written examination. For subjects without a final exam, the 40% minimum requirement applies to the corresponding major assessment component specified by the lecturer. A student must also achieve an overall final mark of 50 or more. Any student not meeting these requirements may be given a maximum final mark of no more than 45 regardless of their average.

For more information see sydney.edu.au/students/guide-to-grades.

Late submission

In accordance with University policy, these penalties apply when written work is submitted after 11:59pm on the due date:

  • Deduction of 5% of the maximum mark for each calendar day after the due date.
  • After ten calendar days late, a mark of zero will be awarded.

This unit has an exception to the standard University policy or supplementary information has been provided by the unit coordinator. This information is displayed below:

Late penalty for any assessment is 20% per day: e.g. if your work would have scored 60% and is 1 hour late then you get 40%, if your work would have scored 70% and is 28 hours late then you get 30%.

Special consideration

If you experience short-term circumstances beyond your control, such as illness, injury or misadventure or if you have essential commitments which impact your preparation or performance in an assessment, you may be eligible for special consideration or special arrangements.

Academic integrity

The Current Student website provides information on academic honesty, academic dishonesty, and the resources available to all students.

The University expects students and staff to act ethically and honestly and will treat all allegations of academic dishonesty or plagiarism seriously.

We use similarity detection software to detect potential instances of plagiarism or other forms of academic dishonesty. If such matches indicate evidence of plagiarism or other forms of dishonesty, your teacher is required to report your work for further investigation.

WK Topic Learning activity Learning outcomes
Week 01 Introduction Online class (3 hr) LO1
Week 02 Conceptual database design Online class (3 hr) LO1
Week 03 Relational data model and logical database design Online class (3 hr) LO1 LO3
Week 04 Relational algebra and SQL Online class (3 hr) LO1 LO3
Week 05 Complex SQL Online class (3 hr) LO1 LO3
Week 06 Database integrity Online class (3 hr) LO1 LO3
Week 07 Introduction to database application development Online class (3 hr) LO1 LO3 LO4
Week 08 Transaction management Online class (3 hr) LO1 LO2 LO3 LO4
Week 09 Schema refinement and normalisation Online class (3 hr) LO1 LO2 LO3 LO4
Week 10 Storage and indexing Online class (3 hr) LO1 LO2 LO3 LO4
Week 11 Query evaluation and optimisation Online class (3 hr) LO1 LO2 LO3 LO4
Week 12 Review Online class (3 hr) LO1 LO2 LO3 LO4

Study commitment

Typically, there is a minimum expectation of 1.5-2 hours of student effort per week per credit point for units of study offered over a full semester. For a 6 credit point unit, this equates to roughly 120-150 hours of student effort in total.

Prescribed readings

All readings for this unit can be accessed through the Library eReserve, available on Canvas.

  • Database Management Systems
    • R. Ramakrishnan and I. Gehrke: 3rd Edition, McGraw-Hill, 2003

Learning outcomes are what students know, understand and are able to do on completion of a unit of study. They are aligned with the University’s graduate qualities and are assessed as part of the curriculum.

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.

Graduate qualities

The graduate qualities are the qualities and skills that all University of Sydney graduates must demonstrate on successful completion of an award course. As a future Sydney graduate, the set of qualities have been designed to equip you for the contemporary world.

GQ1 Depth of disciplinary expertise

Deep disciplinary expertise is the ability to integrate and rigorously apply knowledge, understanding and skills of a recognised discipline defined by scholarly activity, as well as familiarity with evolving practice of the discipline.

GQ2 Critical thinking and problem solving

Critical thinking and problem solving are the questioning of ideas, evidence and assumptions in order to propose and evaluate hypotheses or alternative arguments before formulating a conclusion or a solution to an identified problem.

GQ3 Oral and written communication

Effective communication, in both oral and written form, is the clear exchange of meaning in a manner that is appropriate to audience and context.

GQ4 Information and digital literacy

Information and digital literacy is the ability to locate, interpret, evaluate, manage, adapt, integrate, create and convey information using appropriate resources, tools and strategies.

GQ5 Inventiveness

Generating novel ideas and solutions.

GQ6 Cultural competence

Cultural Competence is the ability to actively, ethically, respectfully, and successfully engage across and between cultures. In the Australian context, this includes and celebrates Aboriginal and Torres Strait Islander cultures, knowledge systems, and a mature understanding of contemporary issues.

GQ7 Interdisciplinary effectiveness

Interdisciplinary effectiveness is the integration and synthesis of multiple viewpoints and practices, working effectively across disciplinary boundaries.

GQ8 Integrated professional, ethical, and personal identity

An integrated professional, ethical and personal identity is understanding the interaction between one’s personal and professional selves in an ethical context.

GQ9 Influence

Engaging others in a process, idea or vision.

Outcome map

Learning outcomes Graduate qualities
GQ1 GQ2 GQ3 GQ4 GQ5 GQ6 GQ7 GQ8 GQ9
No changes have been made since this unit was last offered

IMPORTANT: School policy relating to Academic Dishonesty and Plagiarism.

In assessing a piece of submitted work, the School of Computer Science may reproduce it entirely, may provide a copy to another member of faculty, and/or to an external plagiarism checking service or in-house computer program and may also maintain a copy of the assignment for future checking purposes and/or allow an external service to do so.

All written assignments submitted in this unit of study will be submitted to the similarity detecting software program known as Turnitin. Turnitin searches for matches between text in your written assessment task and text sourced from the Internet, published works and assignments that have previously been submitted to Turnitin for analysis.

There will always be some degree of text-matching when using Turnitin. Text-matching may occur in use of direct quotations, technical terms and phrases, or the listing of bibliographic material. This does not mean you will automatically be accused of academic dishonesty or plagiarism, although Turnitin reports may be used as evidence in academic dishonesty and plagiarism decision-making processes.

Disclaimer

The University reserves the right to amend units of study or no longer offer certain units, including where there are low enrolment numbers.

To help you understand common terms that we use at the University, we offer an online glossary.