Your upfront cost: $0
Subjects may require attendance
- 31 Aug 2020
This research-based university in Perth has a strong interdisciplinary focus and a reputation for outstanding teaching and ground-breaking research. With more than 22,000 students and 2,000 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.
QS RANKING 2020
Times Higher Education Ranking 2020
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
- Conceptual database design
- Logical database design
- Physical database design
- Transaction management
- Database architectures
- Database security
- Data warehouses
- An introduction to non-relational databases
- Online assignment submission
- Podcasting/Lecture capture
- Resources and Links
- Printable format materials
You must have successfully completed the following subject(s) before starting this subject:
No special requirements
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%)
Check the learning management system (LMS) of your university for textbook details.