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 focuses on database design, implementation and management. Topics include data modelling, the relational model, non-relational databases, SQL, logical and physical database design, transaction management, recovery, security, 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. Apply your knowledge of relational database principles and theory to create effective and efficient database designs
2. Define, create and manage relational database systems using SQL
3. Design and implement a database to a given specification using a DBMS
4. Explain the issues associated with, and compare candidate solutions for, the processing of concurrent database transactions
5. Formulate and implement constraints appropriate for a range of commonly encountered database security scenarios
6. Differentiate between non-relational and relational approaches to managing data
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 an online quiz for each topic which addresses the material covered in that topic (collectively worth 10%). Feedback for the quizzes will be provided on the LMS at the completion of the topic. These are two assignments that will allow you to demonstrate proficiency in various aspects of database theory, through the design and implementation of database. These are collectively weighted at 50%. Feedback for these assignments will be provided following submission. The final examination will focus on theory addressed in the unit and is worth 40%.
Prerequisites 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.

Contacts

Unit Coordinator
ICT285
Dr Danny Toohey
Senior Lecturer Information Technology

Murdoch Campus
t: 9360 2800
e: D.Toohey@murdoch.edu.au
o: 245.1.020 - Building 245, Murdoch Campus
Unit Contacts
ICT285

DUBAI-ISC: TJD-Internal
DUBAI-ISC: TSD-Internal
KAPLAN-SGP: TJA-Internal
KAPLAN-SGP: TSA-Internal
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 - Building 245, Murdoch Campus
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.