Data ManagementLaajuus (5 cr)

Objectives

The students know the basics of database systems, the standards and their basic functions. The students learn the basic skills of managing database servers and the basic server functions. The students can design and implement small-scale databases using SQL.

Content

Concepts, SQL standards and database software. Client-Server in practice. The basic functions of database servers: starting up as server, inquiries and turning off the server. Designing databases and database normalization techniques. Implementing a database by SQL.

Prerequisites

Prerequisites: A-OT01

Further information

Connolly T. & Begg C.: Database Systems - A Practical Approach to Design, Implementation, and Management. Addison-Wesley; Elmasri & Navathe: Fundamentals of Database Systems, 2000.; MySQL database instructions from <www.mysql.com>.