You are here: Home / Future students / Course search

Database Systems 1

INFO2120

The proper management of data is essential for all data-centric applications and for effective decision making within organizations. This unit of study will introduce the basic concepts of database designs at the conceptual, logical and physical levels. Particular emphasis will be placed on introducing integrity constraints and the concept of data normalization which prevents data from being corrupted or duplicated in different parts of the database. This in turn helps in the data remaining consistent during its lifetime. Once a database design is in place, the emphasis shifts towards querying the data in order to extract useful information. The unit will introduce different query languages with a particular emphasis on SQL, which is industry standard. Other topics covered will include the important concept of transaction management, application development with a backend database, an overview of data warehousing and online analytic processing, and the use of XML as a data integration language.

Unit of study details

Unit of study level: Intermediate

Credit points: 6

Commencing semesters: 1

Further unit of study information

Unit of study handbook: INFO2120

Costs and scholarships information: Costs and Scholarships

Final dates to withdraw from units of study: Census Dates

Available for study abroad and exchange: Yes

Our courses that offer this unit of study