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 focuses on database design, implementation and management. Topics include data modelling, the relational model, non-relational databases, SQL, logical and physical database design, transaction management, recovery, security, 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. Apply your knowledge of relational database principles and theory to create effective and efficient database designs
2. Define, create and manage relational database systems using SQL
3. Design and implement a database to a given specification using a DBMS
4. Explain the issues associated with, and compare candidate solutions for, the processing of concurrent database transactions
5. Formulate and implement constraints appropriate for a range of commonly encountered database security scenarios
6. Differentiate between non-relational and relational approaches to managing data
|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 an online quiz for each topic which addresses the material covered in that topic (collectively worth 10%). Feedback for the quizzes will be provided on the LMS at the completion of the topic. These are two assignments that will allow you to demonstrate proficiency in various aspects of database theory, through the design and implementation of database. These are collectively weighted at 50%. Feedback for these assignments will be provided following submission. The final examination will focus on theory addressed in the unit and is worth 40%.|
|Prerequisites||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.|