Data Modelling and Database Systems

- Databases and database management systems
- Database application development and testing
- Introduction to conceptual data modelling
- The relational model, relational algebra, and SQL
- Database design
- Database normalisation
- Query processing
- Data integrity
- Transaction management
- File organisations and indexes
- Database administration and security
- NOSQL databases
- XML data, XML DOM, XPath og XML Schema
- Data transformation

After successful completion, the student is capable of describing:
- database tasks and purpose in applications and computer systems
- database management systems; their role and tasks
- relational databases; their foundation and characteristics
- other types of database management systems (NOSQL)
- structuring and management of semi-structured data (such as XML)

After successful completion, the student possesses the skills to:
- assess the use of relational database, NOSQL database, and XML in actual applications and computer systems
- develop and evaluate functional and effective conceptual data models - and corresponding logical, relational models - for real applications
- construct relational database solutions - and select appropriate physical structure - based on the conceptual and logical models designed for the system
- make use of SQL for inserting, querying, and modifying database data
- develop and test applications that retrieves and stores data in databases
- utilize XML technologies for storing and processing semi-structured data

The student has acquired general competency in:
- developing abstract models and solutions for practical problems
- assessing alternatives for storing and managing digital data
- using computer tools for developing software systems

- Lectures
- Lab work
- Obligatory coursework

Coursework requirements:
- 5 out of 6 assignments must be passed.