FIT9132 Introduction to databases
Faculty of Information Technology
FIT9132 Introduction to databases is a level 9, 6-credit-point, postgraduate unit from the Faculty of Information Technology, offered in 2027 in Semester 1 and Semester 2 at Clayton and Malaysia. It has no prerequisites and unlocks 3 units, leading on to 4 units in all.
- Credit points
- 6
- Offered in 2027
- Semester 1, Semester 2
- Clayton, Malaysia
- Assessment
- No exam
- 4 tasks
- Workload
- 144 hours
- per semester
Reviews
No reviews yetNo reviews yet. Be the first to review FIT9132.
Requisites
Before FIT9132
Prohibitions
You can't enrol if you have passed any of these.
After FIT9132
3 units list FIT9132 as a prerequisite or corequisite.
Equivalent units
The same content under another code. Only one of them counts.
Overview
This unit will introduce the concept of data management in an organisation through relational database technology. Theoretical foundation of relational model, analysis and design, implementation of relational database using SQL will be covered.
Offerings in 2027
| Teaching period | Campus | Mode |
|---|---|---|
| First semester | Clayton | On campus |
| First semester | Malaysia | Evening |
| Second semester | Clayton | On campus |
Assessment
- Class test 1Quiz / Test15%
- Assignment 1 - Database DesignArtefact35%
- Class test 2Quiz / Test15%
- Assignment 2 - Creating, Populating and Manipulating DatabasesArtefact35%
Assessment details may change. Please refer to the assessment information in Moodle closer to the start of the teaching period.
Learning outcomes
When you finish this unit, you should be able to:
- 1
Apply the theories of the relational database model;
- 2
Develop a sound relational database design;
- 3
Implement a relational database based on a sound database design;
- 4
Manage data that meets user requirements, including queries and transactions;
- 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 online and face to face learning activities and independent study. Independent study includes associated reading and self-directed online study in preparation for scheduled activities. The unit requires on average three/four hours of scheduled activities per week.
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. You 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, you 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. You 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. You must ONLY use the prescribed version provided by the teaching team. You must not download and use Data Modeler from any other site.
Contacts
- Chief Examiners
- Dr Dwi Rahayu
- Unit Coordinators
- Associate Professor Wai Peng Wong
Common questions
What are the prerequisites for FIT9132?
FIT9132 has no prerequisites.
What can I take after FIT9132?
FIT9132 is a prerequisite or corequisite for 3 units, including EAE5051, FIT5137 and FIT5171. Those lead on to 4 units in all.
When is FIT9132 offered?
In 2027, FIT9132 runs in Semester 1 and Semester 2 at Clayton and Malaysia.
How much work is FIT9132?
The handbook expects about 144 hours of study across the semester. No students have rated its difficulty yet.
Does FIT9132 have an exam?
No. FIT9132 has 4 assessment tasks and no exam.