[an error occurred while processing this directive] [an error occurred while processing this directive]
[an error occurred while processing this directive]
[an error occurred while processing this directive]
Monash University

FIT5137 Database analysis and processing - Summer semester, 2014

This unit looks at the design and implementation issues of database management systems. Advanced database design using multi-dimensional database design and semi-structured database design are explored. Online analytical query language will be explored in the context of multi-dimensional database design. Query optimisation and tuning will be explored, as well as semi-structure database design and query processing.

Workload Requirements

Minimum total expected workload equals 12 hours per week comprising:

(a.) Contact hours for on-campus students:

  • 2 hours of lectures
  • One 2-hour laboratory

(b.) Study schedule for off-campus students:

  • Off-campus students generally do not attend lecture and tutorial sessions, however should plan to spend equivalent time working through the relevant resources and participating in discussion groups each week.

(c.) Additional requirements (all students):

  • A minimum of 8 hours independent study per week for completing lab and project work, private study and revision.

Unit Relationships




(FIT5132 or FIT9003 or FIT9019) or equivalent
Knowledge of relational database principles, including SQL.

Chief Examiner

Campus Lecturer


Associate Professor David Taniar

Jessica Sin



Jessica Sin

Your feedback to Us

Monash is committed to excellence in education and regularly seeks feedback from students, employers and staff. One of the key formal ways students have to provide feedback is through the Student Evaluation of Teaching and Units (SETU) survey. The University’s student evaluation policy requires that every unit is evaluated each year. Students are strongly encouraged to complete the surveys. The feedback is anonymous and provides the Faculty with evidence of aspects that students are satisfied and areas for improvement.

For more information on Monash’s educational strategy, see:

www.monash.edu.au/about/monash-directions/ and on student evaluations, see: www.policy.monash.edu/policy-bank/academic/education/quality/student-evaluation-policy.html

Previous Student Evaluations of this Unit

In response to the students' comments last semester, particularly the misalignment of the last topic on XML to data warehousing, the sub-topic of XML has now been replaced by advanced topics of data warehousing.

If you wish to view how previous students rated this unit, please go to

Academic Overview

Learning Outcomes

On successful completion of this unit students should be able to:
  • design multi-dimensional databases;
  • use fact and dimensional modelling;
  • implement online analytical query language;
  • explain query optimisation and its impact on multi-dimensional design.

Unit Schedule

Week Activities Assessment
0   No formal assessment or activities are undertaken in week 0
1 Multidimensional Database Design: An Overview  
2 Multidimensional Database Design: Modelling  
3 Multidimensional Database Design: Modelling (Advanced)  
4 Multidimensional Database Design: Bridge Tables  
5 Multidimensional Database Design: Bridge Tables and Temporal Class Test: Monday 1-Dec-2014
6 Multidimensional Database Design: Temporal  
7 Physical Database Design: Queries  
8 Physical Database Design: Query Processing  
9 Physical Database Design: Query Tuning  
10 Physical Database Design: Query Tuning  
11 Multidimensional Database Design: Advanced Topics  
12 Multidimensional Database Design: Advanced Topics Assignment due date: Friday 12-Dec-2014, 3pm
  SWOT VAC No formal assessment is undertaken in SWOT VAC
  Examination period LINK to Assessment Policy: http://policy.monash.edu.au/policy-bank/

*Unit Schedule details will be maintained and communicated to you via your learning system.

Teaching Approach

Lecture and tutorials or problem classes
This teaching and learning approach helps students to initially encounter information at lectures, discuss and explore the information during tutorials, and practice in a hands-on lab environment.

Assessment Summary

Examination (3 hours): 60%; In-semester assessment: 40%

Assessment Task Value Due Date
Class Test 10% Monday, 1-Dec-2014
Assignment 30% Friday, 12-Dec-2014, 3pm
Examination 1 60% To be advised

Assessment Requirements

Assessment Policy

Assessment Tasks


  • Assessment task 1
    Class Test
    Multidimensional database design test.
    Criteria for assessment:

    Students will be assessed on their understanding of multidimensional design, object-relational design, and physical database design. 

    Due date:
    Monday, 1-Dec-2014
  • Assessment task 2
    Students will develop a database design incorporating multidimensional design, temporal design, and query optimization. A case study will be given as well. 
    Criteria for assessment:

    Students will be assessed on their understanding of multidimensional design, and physical database design. 

    Due date:
    Friday, 12-Dec-2014, 3pm


  • Examination 1
    3 hours
    Type (open/closed book):
    Closed book
    Electronic devices allowed in the exam:

Learning resources

Reading list

Database Systems: Design, Implementation and Management, Rob, and Coronel, 8th Edition, Course Technology, 2007, chapter on Data Warehousing 

Fundamentals of Database Systems, Elmasri, and Navathe, 5th Edition, Addison Wesley, 2007, chapter on Indexing 

Monash Library Unit Reading List (if applicable to the unit)

Faculty of Information Technology Style Guide

Feedback to you

Examination/other end-of-semester assessment feedback may take the form of feedback classes, provision of sample answers or other group feedback after official results have been published. Please check with your lecturer on the feedback provided and take advantage of this prior to requesting individual consultations with staff. If your unit has an examination, you may request to view your examination script booklet, see http://intranet.monash.edu.au/infotech/resources/students/procedures/request-to-view-exam-scripts.html

Types of feedback you can expect to receive in this unit are:

  • Informal feedback on progress in labs/tutes
  • Graded assignments with comments
  • Solutions to tutes, labs and assignments

Extensions and penalties

Returning assignments

Assignment submission

It is a University requirement (http://www.policy.monash.edu/policy-bank/academic/education/conduct/student-academic-integrity-managing-plagiarism-collusion-procedures.html) for students to submit an assignment coversheet for each assessment item. Faculty Assignment coversheets can be found at http://www.infotech.monash.edu.au/resources/student/forms/. Please check with your Lecturer on the submission method for your assignment coversheet (e.g. attach a file to the online assignment submission, hand-in a hard copy, or use an online quiz). Please note that it is your responsibility to retain copies of your assessments.

Online submission

If Electronic Submission has been approved for your unit, please submit your work via the learning system for this unit, which you can access via links in the my.monash portal.

Other Information


Monash has educational policies, procedures and guidelines, which are designed to ensure that staff and students are aware of the University’s academic standards, and to provide advice on how they might uphold them. You can find Monash’s Education Policies at: www.policy.monash.edu.au/policy-bank/academic/education/index.html

Key educational policies include:

Faculty resources and policies

Important student resources including Faculty policies are located at http://intranet.monash.edu.au/infotech/resources/students/

Graduate Attributes Policy

Student Charter

Student services

Monash University Library

Disability Liaison Unit

Students who have a disability or medical condition are welcome to contact the Disability Liaison Unit to discuss academic support services. Disability Liaison Officers (DLOs) visit all Victorian campuses on a regular basis.

[an error occurred while processing this directive]