Databases

The goals of the course are that the student should develop knowledge with regards to the principles and methods for the design and use of relational database systems. An additional aim is that the student should learn how to evaluate how alternative design solutions affect the functionality of relational databases. Through the course the student should develop an understanding of database concepts and acquire skills in solving basic problems concerning data storage in relational database systems. Upon completion of the course, the student shall be able to - use basic concepts within the database subject area sufficiently well to be able to discuss the design of databases in for example supervisory sessions and course seminars - apply basic principles for relational databases in accordance with the relational model - use object-orientated modelling in addition to graphic descriptive techniques as a tool for the design of relational databases which are the equivalent at the lowest to the third normal form - use normalization sufficiently well to be able to analyze and verify (together with modifying if the need arises) that a design solution fulfils at the lowest the third normal form - manipulate (searching, adding, changing and deleting) of data and the modification and deletion of database objects (tables, keys, indexes, queries) at a basic level with the aid of the standardized database language SQL - relate to the Personal Data Protection Act (abbreviation PuL in Swedish) and be able to present what considerations have been made in terms of database design in order not to be in conflict with this Act