Database Techniques
7.5 ECTS creditsThe 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.
- 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
Admission requirements:
Computer Science 30 ECTS cr. and MAGA43 Mathematics for Computer Scientists, 7,5 ECTS cr., or equivalent.
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)
- Master of Science in Computer Engineering (studied during year 3)
- Study Programme in Engineering - Computer Science (studied during year 2)
- Geographic Information Systems Engineering (studied during year 1)
- Bachelor Programme in Computer Science (studied during year 2)