Information on this page, including unit offerings, is from the 2020 academic year.
|Organisational Unit||Information Technology, Mathematics and Statistics|
|Availability||MURDOCH: S2-internal, S2-external
DUBAI-ISC: TJD-internal, TSD-internal
KAPLAN-SGP: TJA-internal, TSA-internal
|Teaching Timetables||Murdoch S2
|Description||This unit 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.|
|Unit Learning Outcomes||On successful completion of this unit you should be able to:
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
|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 a weekly online quiz which addresses the material covered in the current topic (collectively worth 10%). Feedback for the quizzes will be provided on the LMS at the completion of the topic. There are two assignments that will allow you to demonstrate proficiency in database theory, design and implementation. These are collectively weighted at 40%. Feedback for these assignments will be provided following submission. The final examination will focus on theory addressed in the unit and is worth 50%.|
|Prerequisites||ICT102 Introduction to Computer Science or 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
|Internet Access Requirements||Murdoch 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.|