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 2020 in Semester 1 and Semester 2 at Clayton. It has no prerequisites and unlocks 2 units, leading on to 3 units in all.
- Credit points
- 6
- Offered in 2020
- Semester 1, Semester 2
- Clayton
- Assessment
- Exam 50%
- and 1 other task
- Workload
- 144 hours
- per semester
This is the 2020 handbook entry. See the 2027 entry.
Reviews
No reviews yetNo reviews yet. Be the first to review FIT2094.
Requisites
Before FIT2094
No prerequisites or corequisites besides the enrolment rules below.
After FIT2094
2 units list FIT2094 as a prerequisite or corequisite.
Enrolment rules
Prerequisites: One of FIT1040, FIT1045, FIT1048, FIT1051, FIT1053 or equivalent introductory programming unit
Prohibition: FIT1004, FIT3171, FZA2094
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 2020
| Teaching period | Campus | Mode |
|---|---|---|
| First semester | Clayton | On campus |
| First semester (Fully flex) | Clayton | Flexible |
| Second semester | Clayton | On campus |
Assessment
- In-semester assessmentThreshold hurdle50%
- Examination (2 hours and 10 minutes)Threshold hurdle50%
Learning outcomes
When you finish this unit, you should be able to:
- 1
Explain the motivations behind the development of database management systems;
- 2
Describe the underlying theoretical basis of the relational database model and apply the theories into practice;
- 3
Develop a sound database design;
- 4
Develop a database based on a sound database design;
- 5
Construct queries that meet user requirements;
- 6
Develop a simple web-based interface for a database;
- 7
Use data modelling and database development tools effectively.
Workload and teaching
- Tutorials24 hours
- Workshops24 hours
- Teaching approachActive 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 activities. The unit requires on average three/four hours of scheduled activities per week. Scheduled activities may include a combination of teacher directed learning and online engagement.
Learning resources
Required resources
Coronel, C., & Morris, Steven (2019). Database systems: Design, implementation, and management (13th ed.).ISBN9781337627900
Coronel, C., & Morris, Steven (2017). Database systems: Design, implementation, and management. (12th ed.). ISBN: 9781305627482; ISBN: 9781305886841 (electronic bk.)
TEXTBOOK ("Coronel and Morris") 12th and 13th Edition are available as hard copies. There is also access to an online version of the 12th Edition via Monash Library.
Where it fits
FIT2094 is part of 11 areas of study in the 2020 handbook.
- BUSANLYT01Additional business analytics unitsBusiness analyticsNo reviews yet
- BUSANLYT02Additional business analytics unitsBusiness analyticsNo reviews yet
- ITBIS02CoreBusiness information systemsNo reviews yet
- COMPUSC05Sequence 2Computational scienceNo reviews yet
- COMPUSC07Additional computational science unitsComputational scienceNo reviews yet
- DATASCI01CoreData scienceNo reviews yet
- DATASCI02CoreData scienceNo reviews yet
- SFTWRDEV01Core unitsSoftware developmentNo reviews yet
- SFTWRDEV02Software development electivesSoftware developmentNo reviews yet
- SFTWRDEV03CoreSoftware developmentNo reviews yet
- WEBDEVT02Additional level 2 or 3 unitsWeb developmentNo reviews yet
Contacts
- Chief Examiners
- Dr Dwi Rahayu
Common questions
What are the prerequisites for FIT2094?
FIT2094 has no prerequisites, but enrolment rules apply.
What can I take after FIT2094?
FIT2094 is a prerequisite or corequisite for 2 units, including FIT3163 and FIT3182. Those lead on to 3 units in all.
When is FIT2094 offered?
In 2020, FIT2094 runs in Semester 1 and Semester 2 at Clayton.
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?
Yes. The exam is worth 50% of the final mark, alongside 1 other task.
Which majors and minors include FIT2094?
FIT2094 is part of Business analytics, Business information systems, Computational science, Data science and Software development, and 1 other area of study.