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 2021 in Semester 1 and Semester 2 at Clayton, Malaysia and Monash Online. It has no prerequisites and unlocks 5 units.
- Credit points
- 6
- Offered in 2021
- Semester 1, Semester 2
- Clayton, Malaysia, Monash Online
- Assessment
- Exam 50%
- and 10 other tasks
- Workload
- 144 hours
- per semester
This is the 2021 handbook entry. See the 2027 entry.
Reviews
No reviews yetNo reviews yet. Be the first to review FIT9132.
Requisites
Before FIT9132
No prerequisites or corequisites besides the enrolment rules below.
After FIT9132
5 units list FIT9132 as a prerequisite or corequisite.
Enrolment rules
Prohibition: FIT9003, FIT9019, FIT5132
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 2021
| Teaching period | Campus | Mode |
|---|---|---|
| First semester | Clayton | On campus |
| First semester | Malaysia | Evening |
| Second semester | Clayton | On campus |
| Second semester | Malaysia | Evening |
| October 12 week teaching period | Clayton | On campus |
| Teaching period 3 | Monash Online | Mo |
| Teaching period 6 | Monash Online | Mo |
Assessment
- Workshop ExercisesOtherThreshold hurdle5%
- Assignment 1A: Conceptual ModelOtherThreshold hurdle5%
- Assignment 1B: Normalisation and Logical Database DesignThreshold hurdle15%
- Assignment 2A: SQL Database Creation/ModificationAssignmentThreshold hurdle10%
- Assignment 2B: SQL QueriesAssignmentThreshold hurdle15%
- Scheduled final assessment (2 hours and 10 minutes)ExamThreshold hurdle50%
- Workshop ExercisesOther10%
- Assignment 1A Conceptual ModelAssignment10%
- Assignment 1B Normalisation and Logical Database DesignAssignment20%
- Assignment 2 SQLAssignment30%
- Unit testOther30%
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
Evaluate several design options and construct a database design;
- 4
Develop a database based on a sound database design;
- 5
Construct queries that meet user requirements;
- 6
Contrast the differences between non-relational database models and the relational database model.
Workload and teaching
- Workshops24 hours
- Workshops12 hours
- Tutorials24 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
Technology resources
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.
Where it fits
FIT9132 is part of 2 areas of study in the 2021 handbook.
Contacts
- Chief Examiners
- Mr Lindsay Smith
- Unit Coordinators
- Ms Golnoush Abaei
- Dr Jin Zhe
Common questions
What are the prerequisites for FIT9132?
FIT9132 has no prerequisites, but enrolment rules apply.
What can I take after FIT9132?
FIT9132 is a prerequisite or corequisite for 5 units, including FIT5137, FIT5171, FIT5195, FIT5202 and FIT5206.
When is FIT9132 offered?
In 2021, FIT9132 runs in Semester 1 and Semester 2 at Clayton, Malaysia and Monash Online.
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?
Yes. The exam is worth 50% of the final mark, alongside 10 other tasks.
Which majors and minors include FIT9132?
FIT9132 is part of Atmospheric science and Earth science.