Database Systems & Information Modelling (INFO90002)

Find the subject in the handbook here Semester 1 / 2

Subject Description

The subject introduces key topics in modern information organisation, particularly with regard to structured databases. The well-founded relational theory behind modern structured query language (SQL) engines, has given them as much a place behind the web site of an organisation and on the desktop, as they traditionally enjoyed on corporate mainframes. Topics covered may include: the managerial view of data, information and knowledge; conceptual, logical and physical data modelling; normalisation and de-normalisation; the SQL language; data integrity; transaction processing, data warehousing, web services and organisational memory technologies. This is a core foundation subject for both the Master of Information Systems and Master of Information Technology.

Assignments

Group Assignment - 3000 words (20%)

Written Assignment - 1000 words (10%)

Quiz - 1 hour (20%)

Examination - 2hours (50%)