Faculty of Information Technology
FIT3171 Databases is a level 3, 6-credit-point, undergraduate unit from the Faculty of Information Technology, offered in 2021 in Semester 1, Semester 2 and Summer B at Clayton and Malaysia. It needs ENG1003, FIT1048, FIT1051, FIT1045 or FIT1053 and unlocks 3 units, leading on to 4 units in all. Students rate it 5.0 out of 5 from 1 review and call it easy.
This is the 2021 handbook entry. See the 2027 entry.
One of the most practical units in the degree. SQL, normalisation and transactions are things you will use in every job. Clear assignments, fair marking and well organised labs. Highly recommend even if you are not doing a data major.
Pass these before you enrol.
3 units list FIT3171 as a prerequisite or corequisite.
Prohibition: FIT1004, FIT2094
This unit will provide an introduction to the concepts of database design and usage and the related issues of data management. You 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.
| Teaching period | Campus | Mode |
|---|---|---|
| First semester | Clayton | On campus |
| First semester | Malaysia | On campus |
| Second semester | Clayton | On campus |
| Second semester | Malaysia | On campus |
| Summer semester B | Clayton | On campus |
When you finish this unit, you should be able to:
Explain the motivations behind the development of database management systems;
Describe the underlying theoretical basis of the relational database model and apply the theories into practice;
Critically compared the design constructs of object oriented model and relational model design;
Develop a sound database design;
Implement a database based on a sound database design;
Construct queries that meet user requirements;
Develop an application with a database backend;
Use data modelling and database development tools effectively.
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.
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.
You 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
You are recommended to purchase the digital version of the textbook as an eBook from http://bit.ly/2NYK937. As an eBook, you 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.
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 you 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 - you must ONLY use the prescribed version available from Moodle, you must not download and use SQL Developer from any other site.
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.
FIT3171 is part of 2 areas of study in the 2021 handbook.
You need ENG1003, FIT1048, FIT1051, FIT1045 or FIT1053 before you enrol. Enrolment rules also apply.
FIT3171 is a prerequisite or corequisite for 3 units, including FIT2104, FIT3182 and FIT4002. Those lead on to 4 units in all.
In 2021, FIT3171 runs in Semester 1, Semester 2 and Summer B at Clayton and Malaysia.
Students who took it rate it easy to do well in and moderate on workload (1 rating). The handbook expects about 144 hours of study across the semester.
Yes. The exam is worth 50% of the final mark, alongside 5 other tasks.
FIT3171 is part of Advanced computer science and Software engineering.
It is rated 5.0 out of 5 from 1 review. Read the reviews above or add your own.