Handboksinformation

Kursbeskrivning

The aim of the course is to provide the students with the knowledge of planning and implementing database systems for the management of data and information in business applications. During the course we will learn both the theory and computerized applications of database systems. The main focus of the course is to get acquainted with the relational model and programming language SQL (Structured Query Language). In addition, we will also discuss the topics of Entity-Relationship modeling, normalization, Query-By-Example and various aspects of database design. During the course we will also design and implement a database system in practice.

Lärandemål

After having completed the course the students are expected to
• Have a comprehensive knowledge of theoretical Database concepts and of the Database life-cycle
• Know how to carry out important database planning routines like Normalization and EER-modelling
• To be able to handle advanced SQL commands
• Know how to build an extensive MS-Access based database

Undervisningsspråk

svenska

Förkunskaper

Informationsbehandlingens grunder

Undervisningstimmar

52 h

Undervisningsformer

Föreläsningar och övningar

Litteratur

Connolly, T., Begg, C. & Strachan, A. (2005): Database systems. A practical approach to design, implementation and management. Addison-Wesley. 4 upplagan.

Av examinator anvisad litteratur.

Bedömning och examination

Sluttentamen och övningsarbeten.

Examinator

Paetau, Patrik