Database Systems

Subject INFO20003 (2012)

Note: This is an archived Handbook entry from 2012.

Credit Points: 12.50
Level: 2 (Undergraduate)
Dates & Locations:

This subject has the following teaching availabilities in 2012:

Semester 2, Parkville - Taught on campus.
Pre-teaching Period Start not applicable
Teaching Period not applicable
Assessment Period End not applicable
Last date to Self-Enrol not applicable
Census Date not applicable
Last date to Withdraw without fail not applicable


Timetable can be viewed here. For information about these dates, click here.
Time Commitment: Contact Hours: 24 one-hour lectures (two per week) and 12 two-hour workshops (one per week)
Total Time Commitment:

120 hours

Prerequisites:

One of the following

Subject
Study Period Commencement:
Credit Points:
Semester 1, Semester 2
12.50

Achieving 75% in the programming competency test.

Corequisites:

None

Recommended Background Knowledge: None
Non Allowed Subjects:
Subject

433-351 Database Systems

615-230 Database Concepts

Core Participation Requirements:

For the purposes of considering request for Reasonable Adjustments under the Disability Standards for Education (Cwth 2005), and Student Support and Engagement Policy, academic requirements for this subject are articulated in the Subject Overview, Learning Outcomes, Assessment and Generic Skills sections of this entry.

It is University policy to take all reasonable steps to minimise the impact of disability upon academic study, and reasonable adjustments will be made to enhance a student's participation in the University's programs. Students who feel their disability may impact on meeting the requirements of this subject are encouraged to discuss this matter with a Faculty Student Adviser and Student Equity and Disability Support: http://services.unimelb.edu.au/disability

Coordinator

Dr Sean Maynard

Contact

Tim Baldwin

email:tbaldwin@unimelb.edu.au

Subject Overview:

Contemporary online services such as social networking and multimedia-sharing sites, massively multiplayer online games and commerce services are built on content management and database systems. In this subject, students will learn how to build their own domain-specific content management system, combining web technologies with database technologies. Topics covered include: collection, modelling and retrieval of information in databases; query languages such as SQL; integration of databases with websites; web interfaces; transactions; and a selection of advanced topics in data management.

Objectives:

On completion of this subject students should be able to:

  • Demonstrate proficiency in solving practical data-modelling tasks
  • Design content-management systems using relational database techniques
  • Use SQL to interact with a relational database
  • Develop a web-based database application
  • Use database transactions.
Assessment:
  • Project work during semester, expected to take about 36 hours (30%)
  • A mid-semester test (10%)
  • A 2-hour end-of-semester written examination (60%)

To pass the subject, students must obtain at least 50% overall

  • 15/30 in project work
  • And 35/70 in the mid-semester test
  • And end-of-semester written examination combined
Prescribed Texts:

None

Breadth Options:

This subject potentially can be taken as a breadth subject component for the following courses:

You should visit learn more about breadth subjects and read the breadth requirements for your degree, and should discuss your choice with your student adviser, before deciding on your subjects.

Fees Information: Subject EFTSL, Level, Discipline & Census Date
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 ability to work effectively as a member of a project team
  • 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
Related Majors/Minors/Specialisations: Science credit subjects* for pre-2008 BSc, BASc and combined degree science courses
Science-credited subjects - new generation B-SCI and B-ENG. Core selective subjects for B-BMED.
Related Breadth Track(s): Working with Information
Computing

Download PDF version.