Data modeling and database applications

- The subject's history
- Terminology
- Relational Database Systems: data modeling, design, realization
- Normalization
- Structured Query Language
- Table definition and data manipulation
- Advanced query techniques 
- Database Server: components, architecture, installation, configuration and administration
- Database Security
- Software interfaces to relational databases
- Object-relational mapping
- Basic interaction design

Learning outcomes - Knowledge:

the subject's history
central concepts of database systems development
planning of a good database structure
normalization
relational database management systems: data modeling, design, realization
SQL scripting
database server; components, architecture, installation, configuration and administration
authorization and authentication
software interfaces to relational databases
object-relational mapping
 

Learning outcomes - Skills:

data modeling
SQL scripting
database management
 

Learning outcomes - Competance:

Plan and execute a project in accordance with good practice
Communicate orally and in writing about topics of the course, with both an academic and a non-academic audience
Reflect on legislation relating to data storage
Discuss and reflect on the subject's topics and share knowledge with others

Pedagogical methods:
Lectures, exercises and project work. The subject requires a high personal effort.   

Mandatory requirements:
Project application and project reporting in accordance with established deadlines. Further provision on minimum content, requirements and deadlines regarding the project is given by the lecturer at study start. The project shall be submitted and approved before an exam may be taken.