Overview
To view overview information, please select an offering from the drop-down menu above.
Academic contacts
To view unit coordinator information, please select an offering from the drop-down menu above.
Offerings
DUBAI-ISC-TMD-INT-2019-ONGOING
KAPLAN-SGP-TMA-INT-2019-ONGOING
MURDOCH-S2-EXT-2019-ONGOING
MURDOCH-S2-INT-2019-ONGOING
Enrolment rules
ICT102 Introduction to Computer Science or ICT159 Foundations of Programming or ICT170 Foundations of Computer Systems.
Students who have successfully completed ICT218 Databases cannot enrol in this unit for credit.
Other learning activities
To view other learning activity information, please select an offering from the drop-down menu above.
Learning activities
To view learning activity information, please select an offering from the drop-down menu above.
Learning outcomes
1.
Explain the importance of databases in information management
2.
Demonstrate an understanding of relational database principles and theory
3.
Demonstrate practical skills in using SQL
4.
Demonstrate practical skills in data modelling using entity-relationship modelling
5.
Demonstrate practical skills in normalisation and convert a conceptual database design to a logical design in 3NF
6.
Create a database from a given design using a DBMS and implement specified constraints using appropriate tools and approaches
7.
Explain and implement security as it applies in the database environment.
8.
Explain the issues and approaches involved in the processing of concurrent database transactions
9.
Describe common architectural approaches to database distribution
10.
Explain the role of databases in Business Intelligence
11.
Describe some non-relational database approaches, and likely future trends in database technologies and applications
Assessments
To view assessment information, please select an offering from the drop-down menu above.
Additional information
Unit content:The unit material is divided into a number of topics approximately corresponding to teaching weeks.
The following topics will be 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