Undergraduate MUR-ICT285-2023

Databases

From

$1,037 $0

Your upfront cost: $0

International student?

Duration

13 weeks

Study method

100% Online

Available loans

HECS-HELP

Assessments

100% online

Prior study

Required

Start dates

28 Aug 2023

This research-based university in Perth has a strong interdisciplinary focus and a reputation for outstanding teaching and ground-breaking research. With more than 25,000 students and 2,400 staff from over 90 countries, and campuses in Dubai and Singapore, Murdoch embraces free thinking, shared ideas and knowledge to make a difference, and Open Universities Australia is certainly part of that.

Learn more about Murdoch.

Explore Murdoch courses.

QS Ranking 2023

Times Higher Education Ranking 2023

Need help?

Our student advisors are here to guide you with:

Enrolling and eligibility
Fee and loan information
Credit and recognition for prior learning

2023

Subject details

What you'll learn

On successful completion of this subject you will be able to:

apply your knowledge of relational database principles and theory to create effective and efficient database designs
define, create and manage relational database systems using SQL
design and implement a database to a given specification using a DBMS
explain the issues associated with, and compare candidate solutions for, the processing of concurrent database transactions
formulate and implement constraints appropriate for a range of commonly encountered database security scenarios
differentiate between non-relational and relational approaches to managing data

Topics covered

- Introduction to databases and the relational model
- Database query languages
- Normalisation
- Conceptual database design
- Logical database design
- Physical database design
- Transaction management
- Database architectures
- Database security
- Data warehouses
- An introduction to non-relational databases

Entry requirements

You must have successfully completed the following subject(s) before starting this subject:

MUR-ICT159-Foundations of Programming

Others

This subject is CSP only and cannot be taken as open access. The correct CSP fee will be displayed once you begin the enrolment process.

Additional requirements

No additional requirements

Description

This subject provides an introduction to database design, implementation and management. Topics include 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.

Please Note: All students studying at Murdoch University will need to complete the compulsory unit, Murdoch Academic Passport (MAP100), which only takes 2-3 hours to complete online. Find out more: http://goto.murdoch.edu.au/MurdochAcademicPassport.

Assessments

Problem Solving task (20%)
Problem Solving task (20%)
Timed Online Exam (50%)
Weekly quizzes (10%)

Textbooks

For textbook details check your university's handbook, website or learning management system (LMS).

Related degrees

Undergraduate MUR-BIT-DEG-2023

Bachelor of Information Technology BIT in Games Design and Development

2 available majors

Core Subjects
Major Subjects