This unit discusses the specialised skills for designing and using relational databases. It is a core unit in this advanced and applied IT course. The unit provides students with an in depth knowledge of the daily administration of the relational database. SQL is the standard language used in industry for storing information such as websites and business applications.

Unit details

Study level:
Postgraduate
Credit points:
12
Unit code:
NIT5130

Learning Outcomes

On successful completion of this unit, students will be able to:
  1. Abstract data requirements into data models using entity-relationship model and design relational databases;  
  2. Design proper queries with SQL language to adapt and translate data into useful information to users;  
  3. Assess and rationalise database design with functional dependencies and normal forms;  
  4. Propose and devise query optimisation, transaction and security management for relational database management systems; and  
  5. Exhibit mastery of theoretical knowledge and ability of creative application relating to the Relational Data Model and Relational Database Management Systems.  

Assessment

Assessment type Description Grade
Test Lab Test (2 hours) 20%
Assignment Term assignment (3000 words) 20%
Examination Final Examination (3 hours) 60%

Required reading

Fundamentals of Database Systems 7th ed.
Elmasri, R. and Navathe, S.B., (2015)
Pearson

Where to next?

As part of a course

This unit is studied as part of the following courses. Refer to the course page for information on how to apply for the course.

Study a single unit

This unit may be available as a single unit of study.

Find out more about how to apply for single units of study at VU.

VU takes care to ensure the accuracy of this unit information, but reserves the right to change or withdraw courses offered at any time. Please check that unit information is current with the Student Contact Centre.