UnitLevel 2Undergraduate

FIT2094 Databases

Faculty of Information Technology

FIT2094 Databases is a level 2, 6-credit-point, undergraduate unit from the Faculty of Information Technology, offered in 2025 in Semester 1, Semester 2 and Summer B at Clayton and Malaysia. It needs FIT1045, FIT1048, FIT1051 or FIT1053 and unlocks 6 units, leading on to 7 units in all.

Credit points
6
Offered in 2025
Semester 1, Semester 2, Summer B
Clayton, Malaysia
Assessment
No exam
8 tasks
Workload
144 hours
per semester

This is the 2025 handbook entry. See the 2027 entry.

Reviews

No reviews yet

No reviews yet. Be the first to review FIT2094.

Requisites

Overview

This unit will provide an introduction to the concepts of database design and usage and the related issues of data management. You will develop skills in planning, designing, and implementing a data model using an enterprise-scale relational database system (Oracle). Methods and techniques will also be presented to populate, retrieve, update and implement integrity features on data in the implemented database system.

Offerings in 2025

Teaching periodCampusMode
First semesterClaytonOn campus
First semesterMalaysiaOn campus
Second semesterClaytonOn campus
Summer semester BClaytonOn campus

Assessment

  • In-Class Test 1Quiz / Test
    15%
  • Assignment 1 - Database DesignArtefact
    35%
  • In-Class Test 2,Quiz / Test
    15%
  • Assignment 2 - Creating, Populating and Manipulating DatabasesArtefact
    35%
  • In-Class test 1Quiz / Test
    10%
  • Assignment 1Artefact
    40%
  • In-Class test 2Quiz / Test
    10%
  • Assignment 2Artefact
    40%

Learning outcomes

When you finish this unit, you should be able to:

  1. 1

    Apply the theories of the relational database model;

  2. 2

    Develop a sound relational database design;

  3. 3

     Implement a relational database based on a sound database design;

  4. 4

    Manage data that meets user requirements, including queries and transactions;

  5. 5

    Contrast the differences between non-relational database models and the relational database model.

Workload and teaching

  • Applied sessions24 hours
  • Workshops24 hours
  • Teaching approachActive learning

This unit has a requirement of 1-2 hours per week of asynchronous learning.

Minimum total expected workload to achieve the learning outcomes for this unit is 144 hours per semester typically comprising a mixture of scheduled online and face to face learning activities and independent study. Independent study may include associated reading and preparation for scheduled teaching activities.

Learning resources

Required resources

Coronel, C., & Morris, Steven (2023). Database systems: Design, implementation, and management (14th ed.).​ ISBN 9780357673034.

Technology resources

Monash FIT GitLab Server
All students must maintain their unit work on the FIT GitLab server (https://git.infotech.monash.edu/) to provide a secure repository for completed work and demonstrate a clear development history. Students will be provided with an account on this server.

Monash Oracle and MongoDB Servers
This unit uses the Oracle 12 and MongoDB databases running on Monash servers. All students will have an account on this server, which will suffice for all database work this semester. To access this server, students must install and run the Monash VPN software (details are available on the Moodle/Ed Lesson site).

VSCode
This unit uses VSCode as a client to access Oracle, MongoDB and FIT GitLab servers. Students must install the latest version of this software.

Data Modeler
The client software for data modelling will be available for download from the unit Moodle/Ed Lesson site. Students must ONLY use the prescribed version provided by the teaching team. You must not download and use Data Modeler from any other site

Where it fits

FIT2094 is part of 3 areas of study in the 2025 handbook.

Contacts

Chief Examiners
Dr Dwi Rahayu
Unit Coordinators
Mr Lindsay Smith
Ms Natalia Ahmed

Common questions

What are the prerequisites for FIT2094?

You need FIT1045, FIT1048, FIT1051 or FIT1053 before you enrol.

What can I take after FIT2094?

FIT2094 is a prerequisite or corequisite for 6 units, including FIT2104, FIT3003, FIT3152, FIT3163, FIT3176 and FIT3182. Those lead on to 7 units in all.

When is FIT2094 offered?

In 2025, FIT2094 runs in Semester 1, Semester 2 and Summer B at Clayton and Malaysia.

How much work is FIT2094?

The handbook expects about 144 hours of study across the semester. No students have rated its difficulty yet.

Does FIT2094 have an exam?

No. FIT2094 has 8 assessment tasks and no exam.

Which majors and minors include FIT2094?

FIT2094 is part of Business analytics and Web development.

More details

Credit points
6
Level
2
Study level
Undergraduate
Faculty
Faculty of Information Technology
Type
Coursework
EFTSL
0.125
Student contribution
SCA Band 2
Study abroad
Available