Handbook Public View

This page displays current curriculum information. For staff view, please login

Unit (2020)

Information on this page, including unit offerings, is from the 2020 academic year.

Databases (ICT285)

Organisational Unit Information Technology, Mathematics and Statistics
Credit Points 3
Availability MURDOCH: S2-internal, S2-external
DUBAI-ISC: TJD-internal, TSD-internal
KAPLAN-SGP: TJA-internal, TSA-internal
OUA: OUA3-external
Teaching Timetables Murdoch S2
Description This unit provides an introduction to database design, implementation and management. Topics: data modelling, the relational model, SQL, logical and physical database design, database application design, transaction management, concurrency, recovery, security, database architectures and database administration. The theory material is complemented by practical work using common database management systems.
Unit Learning Outcomes On successful completion of this unit you should be able to:
1. Explain the importance of databases in information management
2. Demonstrate an understanding of relational database principles and theory
3. Demonstrate practical skills in using SQL
4. Demonstrate practical skills in data modelling using entity-relationship modelling
5. Demonstrate practical skills in normalisation and convert a conceptual database design to a logical design in 3NF
6. Create a database from a given design using a DBMS and implement specified constraints using appropriate tools and approaches
7. Explain and implement security as it applies in the database environment.
8. Explain the issues and approaches involved in the processing of concurrent database transactions
9. Describe common architectural approaches to database distribution
10. Explain the role of databases in Business Intelligence
11. Describe some non-relational database approaches, and likely future trends in database technologies and applications
Timetabled Learning Activities Lectures: 1 x 2 hours per week; computer laboratories: 1 hour per week; optional clinics: 1 hour per week.
All offerings of this unit include the equivalent of 30 hours of structured learning.
Unit Learning Experiences The approach to learning in this unit is focused on developing competencies in database design, implementation and management through bringing together theory and practice. You will learn in lectures and workshops; the lectures will discuss theory in the context of practical examples; the workshops will further develop understanding of the theory through weekly practical exercises. Self- study exercises will encourage you to go beyond the material presented in the unit and to explore the important role of databases in everyday life.
Assessment You will have several assessment tasks to complete. There is a weekly online quiz which addresses the material covered in the current topic (collectively worth 10%). Feedback for the quizzes will be provided on the LMS at the completion of the topic. There are two assignments that will allow you to demonstrate proficiency in database theory, design and implementation. These are collectively weighted at 40%. Feedback for these assignments will be provided following submission. The final examination will focus on theory addressed in the unit and is worth 50%.
Prerequisites ICT102 Introduction to Computer Science or ICT159 Foundations of Programming or ICT170 Foundations of Computer Systems.
Exclusions Students who have successfully completed ICT218 Databases cannot enrol in this unit for credit.
Appears in these Courses/Majors:
see individual structures for context
Business Information Systems (BSc) [New in 2014]
Computer Science (BSc) [New in 2014]
Cyber Security and Forensics (BSc) [New in 2014]
Games Software Design and Production (BSc) [New in 2014]
Information Technology and Business (BIT&B)
Internetworking and Network Security (BSc) [New in 2014]
Mobile and Web Application Development (BSc) [New in 2014]
Internet Access RequirementsMurdoch units normally include an online component comprising materials, discussions, lecture recordings and assessment activities. All students, regardless of their location or mode of study, need to have access to and be able to use computing devices with browsing capability and a connection to the Internet via Broadband (Cable, ADSL or Mobile) or Wireless. The Internet connection should be readily available and allow large amounts of data to be streamed or downloaded (approximately 100MB per lecture recording). Students also need to be able to enter into online discussions and submit assignments online.


Unit Coordinator
Dr Danny Toohey
Senior Lecturer Information Technology

Murdoch Campus
t: 9360 2800
e: D.Toohey@murdoch.edu.au
o: 245.1.020 - Science and Computing, Murdoch Campus
Unit Contacts

MURDOCH: S2-External
MURDOCH: S2-Internal
OUA: OUA3-External
Dr Danny Toohey
Senior Lecturer Information Technology

Murdoch Campus
t: 9360 2800
e: D.Toohey@murdoch.edu.au
o: 245.1.020 - Science and Computing, Murdoch Campus
Fee Calculator
Handbook help
Information for Students


The University reserves the right to cancel, without notice, any course, major, minor or unit if the number of students enrolled falls below limits set by the University.

Regulations and Rules

Students should ensure they are familiar with the University's internal legislation, including provisions specifically relevant to their studies. See the University Regulation overview and view legislation online.