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

Info icon This 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
Image of page 1

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

View Full Document Right 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.
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).
Image of page 3

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern