guide - COS326 - Database Systems 2011 Study Guide...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
COS326 — Database Systems 2011 Study Guide Department of Computer Science School of Information Technology University of Pretoria
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1. Overview 1.1. Description. This module builds on a prior introductory module on database technology and provides more advanced theoretical and practi- cal study material. 1.2. Prerequisites. INF 214 (Databases and database design) or per- mission from the Head of Department (PHOD) 1.3. Related modules. INF 214, Databases and database design SPE 781, Special topic — Spatial databases 1.4. Study units. Refer to the study units under Section 2.2. 2. Outcomes 2.1. Career. This course reviews relational database technology and then introduces the student to other database paradigms such as object- oriented databases, object-relational databases, semi-structured databases and geospatial databases. The course also covers advanced database topics such as database security, online analytical processing, transaction manage- ment and query processing. (Not all of these advanced topics will necessar- ily be addressed in any given year — see the schedule below for the current year.) The course is an introduction to more advanced database topics that are relevant to most IT-related careers.
Background image of page 2
2. OUTCOMES 3 2.2. Course. Note that the course contents as listed below are subject to change based on the needs and wishes of the students in the particular class (as well as those of the lecturers). Also note that the listing below does not necessarily reflect the order in which the material will be covered. The list does, however, describe the flavour of the course in some detail. Context / Introduction History and motivation for database systems: List the ba- sic goals, functions, models, components and applications of database systems. Database architecture and data independence: Explain the char- acteristics that distinguish the database approach from the tra- ditional approach of programming with data files. Describe the components of a database system and give ex- amples of their use. Identify major DBMS functions and describe their role in a database system. Differentiate between databases and persistent objects Object-oriented model Describe the main concepts of the OO model such as object identity, type constructors, encapsulation, inheritance, poly- morphism and versioning. Data modelling Relational data model: Categorise the data models based on the types of concepts that they provide to describe the data- base structure — that is, conceptual data model, physical data model, and representational data model. Describe ANSI SPARC model(s). Explain the concept of data independence and its importance
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/27/2012 for the course IT 101 taught by Professor Unsure during the Spring '11 term at University of South Africa.

Page1 / 7

guide - COS326 - Database Systems 2011 Study Guide...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online