Future students

Course search

print
 

Unit details

Return to previous page

SIT103 - Database and Information Retrieval

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

Jingyu Hou

Prerequisite:

Nil

Corequisite:

Nil

Incompatible with:

Nil

Contact hours:

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

Note: You will need to access substantial learning resources and experiences in CloudDeakin (Deakin’s online learning environment). Compliance with the Standards in computing, connectivity and student capability are a condition on your enrolment.

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, and database backup and recovery will be investigated. The impact of new technologies on database design, particularly the Internet, will be covered briefly.

Assessment

Examination 60%, two assignments (20% each) 40%

Unit Fee Information

Unit fee information available soon

Return to previous page

Deakin University acknowledges the traditional land owners of present campus sites.

8th June 2007