Return to previous page

SIT103 - Database and Information Retrieval

Unit details

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

Robert Dew

Prerequisite:

Nil

Corequisite:

Nil

Incompatible with:

Nil

Contact hours:

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

Cloud (online): Learning experiences are via CloudDeakin. Students will have the opportunity to participate in online consultation sessions.

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%, survey report 20%, project documentation and data base 20%

Unit Fee Information

If you are:

Domestic

  • in a Commonwealth Supported Place (CSP) - refer to Unit based calculation below.
  • an undergraduate full fee paying student - refer to Unit based calculation below.
  • postgraduate full fee paying students commenced before 2016 - refer to Unit based calculation below.
  • postgraduate full fee paying students commencing in 2016 - refer to Course based calculation below.
  • a non-award student - refer to Unit based calculation below.

International

  • an undergraduate, postgraduate or Higher Degree by Research student commenced before 2016 - refer to Unit based calculation below.
  • an undergraduate, postgraduate or Higher Degree by Research student commencing in 2016 - refer to Course based calculation below.
  • a non-award student - refer to Unit based calculation below.

Course based calculation

Your unit tuition fees are based on the course you are enrolled in. Please refer to the current year's course entry to estimate the unit cost.


Unit based calculation

Your tuition fees are calculated on the units you enrol in. This means your fees are based on the units you choose to study and not a fixed course price. The tuition fees for this unit are displayed in the table below:


Student Contribution Rate*Student Contribution Rate**Fee rate - Domestic Students Fee rate - International students
$1114$1114$2985$3141

* Rate for all CSP students, except for those who commenced Education and Nursing units pre 2010
** Rate for CSP students who commenced Education and Nursing units pre 2010
Please note: Unit fees listed do not apply to Deakin Prime students.

Return to previous page