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 2024 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 2024
- Semester 1, Semester 2, Summer B
- 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 FIT2094.
Requisites
Before FIT2094
Prerequisites
Pass these before you enrol.
Prohibitions
You can't enrol if you have passed any of these.
After FIT2094
6 units list FIT2094 as a prerequisite or corequisite.
Equivalent units
The same content under another code. Only one of them counts.
Overview
This unit will provide an introduction to the concepts of database design and usage and the related issues of data management. Students 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 2024
| Teaching period | Campus | Mode |
|---|---|---|
| First semester | Clayton | On campus |
| First semester | Malaysia | On campus |
| Second semester | Clayton | On campus |
| Summer semester B | Clayton | On campus |
Assessment
- Class test 1Other10%
- Assignment 1Assignment40%
- Class test 2Other10%
- 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
- Workshops24 hours
- Applied sessions24 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 (2019). Database systems: Design, implementation, and management (13th ed.). ISBN 9781337627900.
OR
Coronel, C., & Morris, Steven (2023). Database systems: Design, implementation, and management (14th ed.). ISBN 9780357673034.
Technology resources
Monash FIT GitLab Server
All students will be required to maintain their unit work on the FIT GitLab server https://git.infotech.monash.edu/ to both provide a secure repository for work completed and to demonstrate a clear development history. Students will be provided with an account on this server.
MS Teams
All students will be required to maintain their group communication on the MS Teams private channel. Students will be provided with an account to access MS Teams and their private group channel.
SQL Developer
This unit will make use of the Oracle 12 database running on a Monash server. All students will have an account on this server which will suffice for all database work this semester. To access this server students will need to install and run the Monash VPN software (details available from the Moodle site). The client software for accessing Oracle (SQL Developer) will be available via a download from the Unit Moodle site - students must ONLY use the prescribed version available from Moodle, you must not download and use SQL Developer from any other site.
Where it fits
FIT2094 is part of 8 areas of study in the 2024 handbook.
- COMPSCI05Core unitsAdvanced computer scienceNo reviews yet
- BUSANLMJ01Additional business analytics unitsBusiness analyticsNo reviews yet
- BUSANLYT08Additional business analytics unitsBusiness analyticsNo reviews yet
- COMPUSC05Sequence 2Computational scienceNo reviews yet
- COMPUSC07Option 2Computational scienceNo reviews yet
- DATASCI02Level 1 and 2 unitsData scienceNo reviews yet
- DATASCI03Core unitsData scienceNo reviews yet
- WEBDEVT03Level 2 and 3 unitsWeb developmentNo reviews yet
Contacts
- Chief Examiners
- Dr Dwi Rahayu
- Unit Coordinators
- 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 2024, 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 4 assessment tasks and no exam.
Which majors and minors include FIT2094?
FIT2094 is part of Advanced computer science, Business analytics, Computational science, Data science and Web development.