Level/category

Professional studies

Teaching language

English

Type of course

Compulsory

Recommended year of study

2

Total number of ECTS

3 cr

Competency aims

This subject will give the students the expertise needed to model, design, implement and manage a relational database. Hands-on computer training is mixed with in-class theory. Database programs MySQL and/or MS SQL Server will be used to demonstrate all database concepts. The student will also establish a general understanding of the theory behind relational databases. Fundamentals of SQL language and multi-user databases are also introduced. Upon completion of this course the student will realize the importance of databases and the basic skills necessary to complete primary database tasks.

Learning outcomes

Upon completeion of this course the student has the necessary skills to:

  • correctly use common terminology used in database environment
  • outline and describe components in a client-server database environment
  • understand the basics of relational algebra and how this relates to theory of relational databases
    the relational data model
  • knows basics of SQL (Data manipulation and Data Definition)
  • understands the concepts of data base design methodology, which inludes conceptual design (ER modeling), logic design (normalization) and physical design (how a data base is implemented in a computer environment)

Course contents

Database theory

  • definitions, concepts and terminology
  • relational database model
  • introduction to data base management systems and query language
  • data integrity
    Working with databases in a client-server environment using SQL:
  • select queries
  • creation of tables and other database objects
  • file sharing and locking principles, security aspects.
    Introduction to database design methodology.

Recommended or required reading

Course textbook
Thomas Connolly etc. : Database Systems, Third Edition

Study activities

  • Lectures
  • Assignments
  • Project work
  • Written report
  • Exercises
  • Individual work

Workload

  • Total workload of the course: 0 hours
  • Of which autonomous studies: 0 hours
  • Of which scheduled studies: 0 hours

Mode of Delivery

Participation in tuition

Assessment methods

Written tests

Examiner

Karlsson Hanne

Group size

No limit

Assignments valid until

The end of the academic year

Course and curriculum search