1. Handbook
  2. Subjects
  3. Database Systems
  4. Print

Database Systems (INFO20003)

Undergraduate level 2Points: 12.5On Campus (Parkville)

You’re viewing the 2019 Handbook:
Or view archived Handbooks

Overview

Year of offer2019
Subject levelUndergraduate Level 2
Subject codeINFO20003
Campus
Parkville
Availability
Semester 1
Semester 2
FeesSubject EFTSL, Level, Discipline & Census Date

AIMS

Contemporary online services such as social networking and multimedia-sharing sites, massive multiplayer online games and commerce services have database management systems at their back-end. In this subject, students will obtain a deep understanding of the concepts behind database management systems. In particular, the students will become familiar with the database system architecture, and will exercise the concepts such as query processing and optimisation, database tuning and transactions, which are the foundation of any modern data processing application. This subject is core within the Bachelor of Science for the Major of Computing and Software Systems and the Major of Informatics. Students completing the Diploma of Informatics are also required to undertake this subject.

INDICATIVE CONTENT

This subject serves as an introduction to data modelling and databases from a technical and data management perspective. The subject will include Entity Relationship modelling (from conceptual design to physical modelling), normalisation, de-normalisation, relational model and relational algebra, SQL, query processing and query optimisation, transactions, storage organisation, database administration, data warehousing and big data analytics. Other topics in data management and DBMS technology with an overview of modern NoSQL systems may also be included.

Intended learning outcomes

  • 1. Demonstrate proficiency in solving practical data-modelling tasks
  • 2. Use SQL to interact with a relational database
  • 3. Understand internal mechanisms and policies behind database systems
  • 4. Understand the need for database transactions, and use them
  • 5. Profile and tune business analytics queries, and administer database systems. Through the combination of lectures, workshops and assignments, students will gain considerable hands-on experience in: i) modelling a number of diverse informational situations, useful to both organisations and individuals, ii) writing efficient SQL queries to analyse data.

Generic skills

On completion of this subject students, should have developed the following generic skills:

  • The ability to analyse and solve problems involving large amounts of real-world data
  • The ability to synthesise information and communicate results effectively
  • The capacity for critical and independent thought and reflection
  • The ability to apply knowledge of basic science and engineering fundamentals
  • The ability to undertake problem identification, formulation and solution

Eligibility and requirements

Prerequisites

One of the following:

INFO10002 Informatics 2: Programming on the Web

Code Name Teaching period Credit Points
COMP10001 Foundations of Computing
Semester 1
Semester 2
12.5
COMP20005 Engineering Computation
Semester 1
Semester 2
12.5
COMP10002 Foundations of Algorithms
Semester 1
Semester 2
12.5
COMP10003 Media Computation
Semester 1
12.5

VCE Algorithmics units 3/4

OR

Achieving 75% in the programming competency test.

or Admission to the Me-(Software) OR ME-(Software/business) program.

Corequisites

None

Non-allowed subjects

Students cannot enrol in and gain credit for this subject and:

INFO20001 Informatics 3: Content Management

SINF90001 Database Systems & Information Modelling

Code Name Teaching period Credit Points
INFO90002 Database Systems & Information Modelling
Semester 1
Semester 2
12.5

Core participation requirements

The University of Melbourne is committed to providing students with reasonable adjustments to assessment and participation under the Disability Standards for Education (2005), and the Assessment and Results Policy (MPF1326). Students are expected to meet the core participation requirements for their course. These can be viewed under Entry and Participation Requirements for the course outlines in the Handbook.

Further details on how to seek academic adjustments can be found on the Student Equity and Disability Support website: http://services.unimelb.edu.au/student-equity/home

Assessment

Description

  • Three small, practical, database-related assignments (10% each) completed individually, requiring approximately 30-35 hours of work per student, equivalent 4000 words, due in weeks 5, 7 and 11. Intended Learning Outcomes (ILOs) 1 to 3 are addressed in the assignments.
  • One mid-semester test (10%). ILOs 1 to 2 are addressed in the mid-semester test.
  • One written 2 hour closed book end of semester examination (60%). ILOs 1 to 5 are addressed in the examination.

Hurdle requirement: To pass the subject, students must obtain:

  • at least 50% (15/30) in assignments
  • at least 50% (35/70) in the mid-semester test and end of semester written examination combined.

Dates & times

  • Semester 1
    Principal coordinatorRenata Borovica-Gajic
    Mode of deliveryOn Campus — Parkville
    Contact hours48 hours, comprising of two 1 hour lectures and one 2 hour workshop per week
    Total time commitment170 hours
    Teaching period 4 March 2019 to 2 June 2019
    Last self-enrol date15 March 2019
    Census date31 March 2019
    Last date to withdraw without fail10 May 2019
    Assessment period ends28 June 2019
  • Semester 2
    Principal coordinatorRenata Borovica-Gajic
    Mode of deliveryOn Campus — Parkville
    Contact hours48 hours, comprising of two 1 hour lectures and one 2 hour workshop per week
    Total time commitment170 hours
    Teaching period29 July 2019 to 27 October 2019
    Last self-enrol date 9 August 2019
    Census date31 August 2019
    Last date to withdraw without fail27 September 2019
    Assessment period ends22 November 2019

Time commitment details

170 hours

Further information

  • Texts

    Prescribed texts

    None

  • Subject notes

    Learning and Teaching Methods

    The subject will be delivered through a combination of lectures and workshops. Students will also complete an assignment which will reinforce the material covered in class.

    Indicative Key Learning Resources

    Whilst there is no single text for this subject, students would be encouraged to utilize one of the many Database textbooks available, there are a number of these in the Library. Additional readings will be made available as necessary via the LMS.

    Careers/Industry Links

    This subject is one of the building blocks for most careers in IT. A database makes the management of information possible and is one of the most prominently used technologies within all organisations.

  • Breadth options
  • Available through the Community Access Program

    About the Community Access Program (CAP)

    This subject is available through the Community Access Program (also called Single Subject Studies) which allows you to enrol in single subjects offered by the University of Melbourne, without the commitment required to complete a whole degree.

    Entry requirements including prerequisites may apply. Please refer to the CAP applications page for further information.

    Additional information for this subject

    Subject coordinator approval required

  • Available to Study Abroad and/or Study Exchange Students

    This subject is available to students studying at the University from eligible overseas institutions on exchange and study abroad. Students are required to satisfy any listed requirements, such as pre- and co-requisites, for enrolment in the subject.

Last updated: 10 April 2019