2. year GIS students
AD 10195, TB 10397 or equivalent
The student shall:
have theoretical knowledge about different database types
be able to make a requirement specification based on a conceptual datamodel
be able to define and construct a relation database based on a datamodel
be able to make queries and maintenance rutines against a relation database with the help of a database tool
The classical types of databases: relational databases, network databases and hierarchical databases.
Basic techniques for data modelling. E-R diagram.
SQL to define, manipulate and secure databases.
Use of proper modelling and database tools
Lectures and practical sessions in laboratory.
A mandatory project must be delivered before the candidate can attend the written exam.
5 hours written examination. The mandatory project counts for 50 % and the individual written exam counts for 50 % of the total grade.
Both the written exam and the project have to be passed.
