Definition of the relation model. Information structuring according to the "Entity Relationship"-model.
Simple rules for good database design. Query languages and a little about the mathematics behind them. Transaction management.
Assertion of security and integrity.
Laboratory assignments using experimental and commercial systems.
The students will, upon completion of the course, be able to model and implement a simple database. Further on, the students will be able to formulate queries, using SQL, to search information in such databases. Finally, the students will have basic knowledge in the use of decision support systems (data warehouses).
This implies that the students should be able to:
* understand the functions and architecture of a database system,
* be able to model and structure data according to actual constraints
* be able to use a query language to formulate queries
* use a simple decision support system.