Handbook Public View

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

Unit (2019)

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

Databases (ICT218)

Organisational Unit Information Technology, Mathematics and Statistics
Credit Points 4
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 the unit you should be able to:
1. Demonstrate an understanding of database principles and theory, particularly those relating to the Relational Model
2. Construct database queries using the Relational Algebra and SQL
3. Design a database, demonstrating practical skills in normalisation and data modelling
4. Create a database using a DBMS from a given design and implement specified constraints using appropriate tools and approaches
5. Compare and evaluate various approaches to database security, the components involved in the implementation of various database security models, and plan and implement a simple database security model
6. Explain the issues associated with, and compare candidate solutions for, the processing of concurrent database transactions
7. Describe the common architectural approaches to the distribution of databases
8. Explain the role of databases in Business Intelligence
9. Compare and contrast contemporary approaches to the processing of very large datasets
Timetabled Learning Activities Lectures: 2 hours per week; tutorials: 1 hour per week; plus an optional clinic.
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 focus on the workshops which will allow you to demonstrate proficiency in database design and implementation. These are collectively weighted at 25%. A group research assignment (15%) will allow you to explore an aspect of databases that is not addressed in this unit. 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 or ICT107 Principles of Information Systems.
Appears in these Courses/Majors:
see individual structures for context
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.

Contacts

Unit Coordinator
No co-ordinators found for this unit.
Unit Contacts
No contacts found for this unit.
Fee Calculator
Handbook help
Information for Students

Cancellation

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.