Study Guide

Objective

The student:
- knows basic concepts about database programming
- can perform practical database modeling and database programming
- understands why and how to use a framework for database programming
- masters the programming of applications in a multi-user environment that read and write relational databases.

Content

Rehearsal of SQL
Libraries for database programming
Reading and writing databases
Transaction Management
Object Relational Mapping (ORM)
Introduction to frameworks
xml and json data

Qualifications

Courses: Object Oriented Programming, Database Technology

Assessment criteria, satisfactory (1)

The student understands the basic theories of the relational model and can realize a relational model as a physical database.
The student can program simple database applications that read and write a database, and can use parameterized commands.
The student knows a framework for reading and writing databases.

Assessment criteria, good (3)

The student can create simpler conceptual, logical and physical database models.
The student can program database applications using Object Relational Mapping.
The student can implement transaction management in his code.
The student knows about security risks and knows how the risks are handled in program code.
The student can use a framework to read and write databases.

Assessment criteria, excellent (5)

The student can create advanced conceptual, logical and physical database models.
The student can encode different types of applications that reuse code for data management.
The student can use a framework for versatile reading and writing of databases.

Materials

Material on Moodle.