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 2023 in Semester 1 and Semester 2 at Clayton and Malaysia. It has no prerequisites and unlocks 3 units.
- Credit points
- 6
- Offered in 2023
- Semester 1, Semester 2
- Clayton, Malaysia
- Assessment
- No exam
- 4 tasks
- Workload
- 144 hours
- per semester
This is the 2023 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
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 2023
| Teaching period | Campus | Mode |
|---|---|---|
| First semester | Clayton | On campus |
| First semester | Malaysia | Evening |
| Second semester | Clayton | On campus |
Assessment
- Assignment 1AAssignment10%
- Assignment 1BAssignment30%
- Assignment 2AAssignment25%
- Assignment 2BAssignment35%
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 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 (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
FIT9132 is part of 2 areas of study in the 2023 handbook.
Contacts
- Unit Coordinators
- Mr Lindsay Smith
- Dr Samini Subramaniam
- Chief Examiners
- Dr Dwi Rahayu
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 FIT5137, FIT5171 and FIT5195.
When is FIT9132 offered?
In 2023, 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.
Which majors and minors include FIT9132?
FIT9132 is part of Atmospheric science and Earth science.