Unit search

Search results

SIT103 - Data and Information Management

Year:

2020 unit information

Important Update:

Classes and seminars in Trimester 2/Semester 2, 2020 will be online. Physical distancing for coronavirus (COVID-19) will affect delivery of other learning experiences in this unit. Please check your unit sites for announcements and updates one week prior to the start of your trimester or semester.

Last updated: 2 June 2020

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

Nil

Corequisite:

Nil

Incompatible with:

Nil

Typical 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 classes per week, 1 x 2 hour practical per week.

Scheduled learning activities - cloud:

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.

 

These are the Learning Outcomes (ULO) for this Unit

At the completion of this Unit
successful students can:

Deakin Graduate Learning Outcomes

ULO1

 Describe the techniques used in storing and retrieving data. GLO1: Discipline-specific knowledge and capabilities

ULO2

Evaluate data models and apply data modelling techniques to capture the data aspects of real-world situations. GLO1: Discipline-specific knowledge and capabilities
GLO3: Digital literacy

ULO3

Design and develop relational databases by using SQL and a database management system GLO1: Discipline-specific knowledge and capabilities
GLO4: Critical thinking
GLO5: Problem solving

These Unit Learning Outcomes are applicable for all teaching periods throughout the year

Assessment

Assessment Description Student output Weighting (% total mark for unit) Indicative due week
Survey report 1,000-word report 20% Week 7
Project documentation and database Database development and documentation 20% Week 11
Examination 2-hour written examination 60% Examination period

The assessment due weeks provided may change. The Unit Chair will clarify the exact assessment requirements, including the due date, at the start of the teaching period.

Learning Resource

Prescribed text(s): Coronel, 2018, Database Systems Design Implementation Management, 13th edition, Cengage Learning.

The texts and reading list for the unit can be found on the University Library via the link below: SIT103 Note: Select the relevant trimester reading list. Please note that a future teaching period's reading list may not be available until a month prior to the start of that teaching period so you may wish to use the relevant trimester's prior year reading list as a guide only.

Unit Fee Information

Click on the fee link below which describes you: