Units / FIT3171
FIT3171 · Databases
2026 Handbook6 credit pointsLevel 3Faculty of Information Technology
Last checked: 22 Aug 2026 UTCOverview
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.
Areas of study: Advanced computer science Software engineering
Offerings
| Campus | Teaching period | Mode |
|---|---|---|
| Clayton | First semester | Teaching activities are on-campus (ON-CAMPUS) |
| Malaysia | First semester | Teaching activities are on-campus (ON-CAMPUS) |
| Clayton | Second semester | Teaching activities are on-campus (ON-CAMPUS) |
| Clayton | Summer semester B | Teaching activities are on-campus (ON-CAMPUS) |
Assessment
The Handbook does not list a final examination among the assessment items. That is not a guarantee there is none.
| # | Assessment | Type | Weight | Hurdle |
|---|---|---|---|---|
| 1 | In-Class Test 1 | Quiz / Test | 15% | — |
| 2 | Assignment 1 - Database Design | Artefact | 35% | — |
| 3 | In-Class test 2 | Quiz / Test | 15% | — |
| 4 | Assignment 2 - Creating, Populating and Manipulating Databases | Artefact | 35% | — |
Assessment details may change. Please refer to the assessment information in Moodle closer to the start of the teaching period.
Requisites
prohibitions
- FIT2094 — Databases
Learning outcomes
- Apply the theories of the relational database model;
- Develop a sound relational database design;
- Implement a relational database based on a sound database design;
- Manage data that meets user requirements, including queries and transactions;
- Differentiate non-relational database model and the relational database model;
- Develop programming structures within a database backend.
Workload
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.
| Activity | Duration |
|---|---|
| Workshops | 24 hours |
| Applied sessions | 24 hours |
Ask about FIT3171
Answered from the Handbook fields above - no AI, no guessing. Every answer links back to the source.
Community discussions about FIT3171
CommunityStudent experience, not official rules. Nothing here changes what the Handbook says.