Database Systems (academic course)

From Christoph's Personal Wiki
Jump to: navigation, search

Content is archived here for educational purposes only.

Overview

Aim/objectives

The amount of data met in our daily life makes demands on how data are structured and stored asking for more powerful tools than the use of files and file systems. On the other hand database systems offer basic mechanisms to structure large amounts of data allowing storing and retrieving data using general principles based on a general data model and query language as e.g. SQL.

The course goal is to give a general understanding of databases, their use and foundations. More specific the participants should:

  • gain knowledge on how database systems are constructed,
  • be familiar to the conceptual design of databases,
  • be acquainted with different data models and the corresponding query-languages

Content

Introduction to fundamental database concepts and database management. The relational data model. Relational algebra and calculus; Structured Query Language (SQL): Data Definition, data queries, data manipulation and data integrity. Design of databases using Entity-Relationship diagrams Transformation from ER-diagrams to relational database schemas. Normalization of relational databases. Databases and query languages based on other data models: Object oriented and object-relational databases. Semistructured and XML databases. XML for data representation and data interchange.

Several exercises using different database system are given during the course period.

Textbook

Contact

  • Professor: Hans Bruun, build. 325, room 211, (+45) 4525 3709, hab@imm.dtu.dk
  • Department: 02 Informatics and Mathematical Modelling
  • Home Page: http://www.imm.dtu.dk/courses/02170
  • Semester: Spring 2006 (2 February 2006 — May 2006; Thu; 10:00 - 12:00)