FIT3176 Advanced database design
Faculty of Information Technology
FIT3176 Advanced database design is a level 3, 6-credit-point, undergraduate unit from the Faculty of Information Technology, offered in 2022 in Semester 2 at Clayton. It has no prerequisites.
- Credit points
- 6
- Offered in 2022
- Semester 2
- Clayton
- Assessment
- Exam 60%
- and 4 other tasks
- Workload
- 144 hours
- per semester
This is the 2022 handbook entry. See the 2026 entry.
Reviews
No reviews yetNo reviews yet. Be the first to review FIT3176.
Requisites
Before FIT3176
No prerequisites or corequisites besides the enrolment rules below.
After FIT3176
No unit lists FIT3176 as a prerequisite in the 2022 handbook.
Enrolment rules
Prerequisites: FIT1004 or FIT2094 or FIT3171
Prohibition: FIT2077, FIT3118, FIT4038
Overview
This unit will introduce advanced concepts in the areas of database design, including document-store, column-store, and graph database design; implementations in non-relational database systems.
Offerings in 2022
| Teaching period | Campus | Mode |
|---|---|---|
| Second semester | Clayton | On campus |
Assessment
- Assignment 1 - MongoDB and CassandraAssignmentThreshold hurdle20%
- Assignment 2 - Neo4jAssignmentThreshold hurdle10%
- FLUX ParticipationParticipationThreshold hurdle5%
- Tutorial WorkOtherThreshold hurdle5%
- Scheduled final assessment (2 hours and 10 minutes)ExamThreshold hurdle60%
Learning outcomes
When you finish this unit, you should be able to:
- 1
Describe various non-relational database systems, including NoSQL;
- 2
Compare and contrast between relational and non-relational database design and model;
- 3
Design database systems using document-store and column-store design techniques;
- 4
Explain transactions systems in non-relational systems;
- 5
Implement and manipulate document-store and column-store database systems;
- 6
Investigate graph model in database systems;
- 7
Demonstrate graph query processing.
Workload and teaching
- Laboratories24 hours
- Lectures24 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 and Morris, S. (2017). Database Systems: Design, Implementation, and Management. (12th Edition) Cengage Learning (ISBN: 1305627482).
Recommended resources
Elmasri, R and Navathe, S. (2017). Fundamentals of Database Systems. (7th Edition), Pearson.
Carey, P. and Vodnik, S. (2014). New Perspectives on XML, Comprehensive. (3rd Edition), Course Technology.
Smith, B. (2015). Beginning JSON. Apress. Bassett, L. (2015). Introduction to JavaScript Object Notation A To-the-Point Guide to JSON. O'Reilly Media.
Technology resources
Oracle SQL Developer.
Where it fits
FIT3176 is part of 3 areas of study in the 2022 handbook.
Contacts
- Chief Examiners
- Associate Professor David Taniar
- Unit Coordinators
- Farah Kabir
Common questions
What are the prerequisites for FIT3176?
FIT3176 has no prerequisites, but enrolment rules apply.
When is FIT3176 offered?
In 2022, FIT3176 runs in Semester 2 at Clayton.
How much work is FIT3176?
The handbook expects about 144 hours of study across the semester. No students have rated its difficulty yet.
Does FIT3176 have an exam?
Yes. The exam is worth 60% of the final mark, alongside 4 other tasks.
Which majors and minors include FIT3176?
FIT3176 is part of Computational science, Software development and Software engineering.