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 2024 in Summer A, Semester 1 and Semester 2 at Clayton and Malaysia. It has no prerequisites and unlocks 2 units.
- Credit points
- 6
- Offered in 2024
- Summer A, Semester 1, Semester 2
- Clayton, Malaysia
- Assessment
- No exam
- 4 tasks
- Workload
- 144 hours
- per semester
This is the 2024 handbook entry. See the 2027 entry.
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
2 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 2024
| Teaching period | Campus | Mode |
|---|---|---|
| Summer semester A | Clayton | On campus |
| First semester | Clayton | On campus |
| First semester | Malaysia | Evening |
| Second semester | Clayton | On campus |
Assessment
- In-Class test 1Other10%
- Assignment 1Assignment40%
- In-Class test 2Assignment10%
- Assignment 2Assignment40%
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. 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
FIT9132 is part of 3 areas of study in the 2024 handbook.
Contacts
- Chief Examiners
- Dr Dwi Rahayu
- Unit Coordinators
- Mr Lindsay Smith
- Ms Natalia Ahmed
- 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 2 units, including FIT5137 and FIT5171.
When is FIT9132 offered?
In 2024, FIT9132 runs in Summer A, 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.
Which majors and minors include FIT9132?
FIT9132 is part of Atmospheric science, Data analytics for business and Earth science.