Enrolments for 2020 have closed.
Databases
Undergraduate | MUR-ICT285 | 2020
Course information for 2020 intake View information for 2024 course intake
- Study method
- 100% online
- Assessments
- Subject may require attendance
- Entry requirements
- Part of a degree
- Duration
- 13 weeks
HECS-HELP and FEE-HELP available
Databases
About this subject
On successful completion of this subject you should be able to:
- explain the importance of databases in information management
- demonstrate an understanding of relational database principles and theory
- demonstrate practical skills in using SQL
- demonstrate practical skills in data modelling using entity-relationship modelling
- demonstrate practical skills in normalisation and convert a conceptual database design to a logical design in 3NF
- create a database from a given design using a DBMS and implement specified constraints using appropriate tools and approaches
- explain and implement security as it applies to the database environment.
- explain the issues and approaches involved in the processing of concurrent database transactions
- describe common architectural approaches to database distribution
- explain the role of databases in Business Intelligence
- describe some non-relational database approaches, and likely future trends in database technologies and applications.
- 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
This subject 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.
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.
- Problem Solving task (20%)
- Problem Solving task (20%)
- Invigilated Exam (50%)
- Weekly quizzes (10%)
For textbook details check your university's handbook, website or learning management system (LMS).
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 University.
Explore Murdoch courses.
- QS Ranking 2024:
- 27
- Times Higher Education Ranking 2024:
- 26
Entry requirements
To enrol in this subject, you must be admitted into a degree.
Prior study
You must have successfully completed the following subject(s) before starting this subject:
Additional requirements
No additional requirements
Study load
- 0.125 EFTSL
- This is in the range of 10 to 12 hours of study each week.
Equivalent full time study load (EFTSL) is one way to calculate your study load. One (1.0) EFTSL is equivalent to a full-time study load for one year.
Find out more information on Commonwealth Loans to understand what this means to your eligibility for financial support.