UnitLevel 2Undergraduate

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 2022 in Semester 1 and Semester 2 at Clayton and Malaysia. It has no prerequisites and unlocks 3 units, leading on to 4 units in all.

Credit points: 6
Offered in 2022: Semester 1, Semester 2; Clayton, Malaysia
Assessment: Exam 40%; and 3 other tasks
Workload: 144 hours; per semester

This is the 2022 handbook entry. See the 2027 entry.

Reviews

No reviews yet. Be the first to review FIT2094.

Requisites

Before FIT2094

No prerequisites or corequisites besides the enrolment rules below.

After FIT2094

3 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 2022

Teaching period	Campus	Mode
First semester	Clayton	On campus
First semester	Malaysia	On campus
Second semester	Clayton	On campus
Second semester	Malaysia	On campus
November teaching period	Clayton	On campus

Assessment

Conceptual modelOtherThreshold hurdle
10%
Database designOtherThreshold hurdle
25%
SQL creationOtherThreshold hurdle
25%
Scheduled final assessment (2 hours and 10 minutes)ExamThreshold hurdle
40%

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

Applied sessions24 hours
Workshops24 hours
Teaching approachPeer assisted 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.

Peer-assisted learning In this unit, we plan to use a peer-assisted learning approach. To maximise the learning experience for students in this approach, students are expected to read the suggested sections from the textbook prior to attending the workshop sessions . The preparation prior to the workshop is CRUCIAL to the successful participation of students in peer-assisted learning during the workshop sessions.

The concepts and knowledge learnt through self-study prior to and during the workshop sessions will be emphasized and practised during the tutorial classes

Learning resources

Required resources

Students are required to have access to a copy of the textbook Coronel, C., & Morris, Steven, Database Systems: Design, Implementation, and Management (Version 12 or 13 is suitable).

The Library has 12th and 13th Editions available as hard copies for borrowing. There is also access to an online version of the 12th Edition via Monash Library * Coronel, C., & Morris, Steven (2017). Database systems: Design, implementation, and management. (12th ed.). ISBN: 9781305627482; ISBN: 9781305886841 (electronic bk.) * Coronel, C., & Morris, Steven (2019). Database systems: Design, implementation, and management (13th ed.).ISBN9781337627900 Note however there are a limited number of copies of both editions 12 and 13 available for borrowing.
Students are recommended to purchase the digital version of the textbook as an eBook from http://bit.ly/2NYK937 http://bit.ly/2NYK937 As an eBook, students will have immediate access (the text can be accessed online via the Cengage eReader using your desktop or mobile web browser.). A discount voucher for this purchase will be available from the Unit Moodle Website in week 0.

Recommended resources

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.

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.

Moodle

All students must regularly check Moodle for announcements. In addition, for assignment 1A and assignment 1B, Moodle forums will act as a 'client' to students allowing them to clarify any design/task issues - the responses posted to these forums by the moderator will be regarded as part of the assignment brief. Failure to note these postings and implement/integrate them as part of your solution will incur grade penalties.

Monash FIT PHP Server

All students will be required to use FIT PHP server http://fit-db.infotech.monash.edu to develop a web interface for a database. Students will be provided with an account on this server. Secure File Transfer Protocol Software is required for access to the PHP server.

Where it fits

FIT2094 is part of 10 areas of study in the 2022 handbook.

Contacts

Unit Coordinators: Dr Jin Zhe; Ms Golnoush Abaei
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 3 units, including FIT2104, FIT3163 and FIT3182. Those lead on to 4 units in all.

When is FIT2094 offered?

In 2022, FIT2094 runs in Semester 1 and Semester 2 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?

Yes. The exam is worth 40% of the final mark, alongside 3 other tasks.

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.

More details

Credit points: 6
Level: 2
Study level: Undergraduate
Faculty: Faculty of Information Technology

Type: Coursework
EFTSL: 0.125
Student contribution: SCA Band 2
Study abroad: Available
Handbook years: 2020 202120222023 2024 2025 2026 2027