SIT103 - Data and Information Management

Year:

2021 unit information

Enrolment modes: Trimester 2: Burwood (Melbourne), Waurn Ponds (Geelong), Cloud (online)
Credit point(s): 1
EFTSL value: 0.125
Prerequisite:

Nil

Corequisite:

Nil

Incompatible with:

Nil

Study commitment

Students will on average spend 150 hours over the teaching period undertaking the teaching, learning and assessment activities for this unit.

Scheduled learning activities - campus

2 x 1 hour class per week, 1 x 2 hour practical per week.

Scheduled learning activities - cloud (online)

1 x 1 hour scheduled online workshop per week.

Content

This unit will provide a solid foundation for the design, implementation and management of database systems. Data modelling is introduced, focusing on entity-relationship (ER) modelling. The skills required to construct such ER diagrams will be explored, with a focus on ensuring that the semantics of the model match those of the real-world it is representing. The relational data model will be presented and the functionality it affords will be explored. The process of constructing, maintaining and retrieving information from the database using SQL will be a focus of this unit. Key implementation and management concepts, including transaction management and concurrency control, database backup and recovery, and security will be investigated.

Unit Fee Information

Click on the fee link below which describes you: