[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 - Semester 2, 2015

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.

Mode of Delivery

  • Caulfield (Day)
  • Caulfield (Online)

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.

See also Unit timetable information

Unit Relationships




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

Chief Examiner

Campus Lecturer


Associate Professor David Taniar



Duy Doan

Zhou Shao

Say Ying Lim

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 Data Analysis and Processing: 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  
6 Multidimensional Database Design: Temporal  
7 Physical Database Design: Queries Class Test: Thursday 10-Sep-2015, 2-4pm
8 Physical Database Design: Query Processing  
9 Physical Database Design: Query Tuning  
10 Physical Database Design: Query Tuning  
11 Multidimensional Database Design: Advanced Topics Assignment due date: Friday 16-Oct-2015 5pm
12 Multidimensional Database Design: Advanced Topics  
  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% Thursday 10-Sep-2015, 2-4pm
Assignment 30% Friday 16-Oct-2015 5 pm
Examination 1 60% To be advised

Assessment Requirements

Assessment Policy

Assessment Tasks


  • Assessment task 1
    Class Test
    Multidimensional database design test. This assessment relates to Learning Outcomes: 1 and 2.
    Criteria for assessment:

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

    Due date:
    Thursday 10-Sep-2015, 2-4pm
  • 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. This assessment relates to Learning Outcomes: 1, 2, 3, and 4.
    Criteria for assessment:

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

    Due date:
    Friday 16-Oct-2015 5 pm


  • 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)

Feedback to you

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

  • Informal feedback on progress in labs/tutes
  • Graded assignments with comments
  • Test results and feedback
  • 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 electronic submission). 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.

Required Resources

Please check with your lecturer before purchasing any Required Resources. Limited copies of prescribed texts are available for you to borrow in the library, and prescribed software is available in student labs.

The required software is available in the Labs.

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

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]