Database Techniques

The course comprises:
- principles and use of general database systems (DBMS)
- the structure of database systems
- relational database model (computer structure, relational algebra, computer integrity)
- the programming language SQL
- methods of database design (E(R model, functional dependency, normalisation)
- storage structure for databases (indexing, B-trees)
- transaction and database security
- presentation of other types of databases, for instance, distributed and web based databases.


Instruction is mainly in the form of lectures, individual reading with study guides and study material, and hand-in assignments. There are also exercises and laboratory work in which different relational database systems and programming language are used.

Progressive specialisation: G1F (has less than 60 credits in first‐cycle course/s as entry requirements)

Education level: Undergraduate level

Selection:

Selection is usually based on your grade point average from upper secondary school or the number of credit points from previous university studies, or both.

This course is included in the following programme

• Study Programme in IT-Design: Software Design (studied during year 2)