Database Systems & Information Modelling

Subject INFO90002 (2015)

Note: This is an archived Handbook entry from 2015.

Credit Points: 12.5
Level: 9 (Graduate/Postgraduate)
Dates & Locations:

This subject has the following teaching availabilities in 2015:

Semester 1, Parkville - Taught on campus.
Pre-teaching Period Start not applicable
Teaching Period 02-Mar-2015 to 31-May-2015
Assessment Period End 26-Jun-2015
Last date to Self-Enrol 13-Mar-2015
Census Date 31-Mar-2015
Last date to Withdraw without fail 08-May-2015

Semester 2, Parkville - Taught on campus.
Pre-teaching Period Start not applicable
Teaching Period 27-Jul-2015 to 25-Oct-2015
Assessment Period End 20-Nov-2015
Last date to Self-Enrol 07-Aug-2015
Census Date 31-Aug-2015
Last date to Withdraw without fail 25-Sep-2015

Timetable can be viewed here. For information about these dates, click here.
Time Commitment: Contact Hours: 36 hours, comprising of 28 hours of seminars (3 hours weeks 1, 9-12, 2 hours weeks 2-8) and 7 hours of labs (1 hour in weeks 2-8)
Total Time Commitment:

200 hours





Recommended Background Knowledge:


Non Allowed Subjects:
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:


Dr Sean Maynard



Subject Overview:


The subject introduces key topics in modern information organization, particularly with regard to structured databases. The well-founded relational theory behind modern structured query language (SQL) engines, has given them as much a place behind the web site of an organization and on the desktop, as they traditionally enjoyed on corporate mainframes. Topics covered may include: the managerial view of data, information and knowledge; conceptual, logical and physical data modelling; normalization and de-normalization; the SQL language; data integrity; transaction processing, data warehousing, web services and organizational memory technologies. This is a foundation subject is a core subject for both the Master of Information Systems and Master of Information Technology.


This subject serves as an introduction to databases and data modelling from a data management perspective. Database design, from conceptual design through to physical implementation will be covered. This will include Entity Relationship modelling, normalisation and de-normalisation and SQL. Additionally the use of databases in various contexts will be explored (web based databases, connecting programs to databases, data warehousing, health contexts, geospatial databases).

Learning Outcomes:


Having completed this unit the student is expected to:

  1. Understand the different technologies available to manage structured data, and the evolutionary process that led to them
  2. Be able to construct data models at the conceptual, logical and physical level from real-world, natural language requirements documents and apply data normalisation to these models
  3. Be able to competently use a CASE tool (computer-aided software engineering)
  4. Be competent in basic SQL and familiar with the usage of advanced SQL commands
  5. Understand the need and mechanism for database transactions, including the so-called ACID properties
  6. Be familiar with technologies and techniques connecting databases to web browser-based interfaces (eg JavaScript, ASP and JSP), and connecting to web services
  7. Understand the relationship of database systems to a variety of fields including data warehousing, health informatics and Geospatial applications

Through the combination of seminars, labs and assignments, students gain expertise and confidence to make informed decisions about database systems and appropriate modelling techniques for the structured informational needs of modern organisations. They will gain considerable hands-on experience in modelling a number of diverse informational situations, drawing upon the first principles and techniques taught, useful to both organisations and individuals.

  • A database design for a real-world problem completed in teams of two or three students (30%), requiring approximately 40-45 hours of work per student. This project consists of a database design, along with a data dictionary, equivalent to about 4000 words, and is due about halfway through semester. Addresses Intended Learning Outcomes (ILOs) 1-3.
  • A set of answers completed individually using SQL to a series of questions run against a known database with fixed data content (10%), requiring approximately 13-15 hours of work (about 1000 words). This assignment is due approximately in week 10 of semester. Addresses ILO 4.
  • A two-hour closed book examination in the examination period (60%). Addresses ILOs 1,2,4-7.

Hurdle requirement: To pass the subject students must obtain at least:

  • 50% of the marks available for the non-examination based assessment
  • 50% of the marks available for the examination
Prescribed Texts:

There are no prescribed texts for this subject.

Breadth Options:

This subject is not available as a breadth subject.

Fees Information: Subject EFTSL, Level, Discipline & Census Date
Generic Skills:

The student will acquire skills in Information Modelling - a generic skill that will serve the student well throughout a career in Information Systems. Scoping within analysis is also a valuable cross-discipline skill honed during this subject.



The subject is delivered in 3 hour classes. Each class will be made up of a combination of lectures, discussions and computer laboratory based learning. Outside class, students will study the practice of database implementation and usage and are encouraged to install and use a DBMS on their own computer as part of the course.


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


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.

Related Course(s): Master of Information Systems
Master of Philosophy - Engineering
Master of Science (Information Systems)
Ph.D.- Engineering
Related Majors/Minors/Specialisations: MIS Professional Specialisation
MIT Computing Specialisation
MIT Distributed Computing Specialisation
MIT Health Specialisation
MIT Spatial Specialisation

Download PDF version.