Database Systems 1 (INFO2120)

UNIT OF STUDY

The ubiquitous use of information technology leaves us facing a tsunami of data produced by users, IT systems and mobile devices. The proper management of data is hence essential for all applications and for effective decision making within organisations. This unit of study will introduce the basic concepts of database designs at the conceptual, logical and physical levels. We will place particular emphasis on introducing integrity constraints and the concept of data normalisation 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 OLAP, and the use of XML as a data integration language.

Usage disclaimer

The course information on this website applies only to
future
students.
Current
students should refer to faculty handbooks for current or past course information.

Print disclaimer

The information provided here was as accurate as possible at the time of printing. The University reserves the right to make changes to the information as appropriate. Future students must ensure to check online at http://sydney.edu.au/courses for the most up to date course information.