Databases and modelling
2010-2011 - GEO1261 - 10 ECTS

Expected learning outcomes

The course will give the students basic understanding of the theory and the practical modelling and use of modern databases. Further it will give the students knowledge and understanding of the use of XML and XML-related technologies.

Topic(s)

The principles of Relational Databases
The structure of data, and SQL used to Define, Manipulate and Query
Database Design, Database Modeling with ER and EER-diagrams and 1. 2. og 3. Normal form
Client-Server, Security, Transactions and Concurrency Control
Document modelling with XML, DTD and Schema
Communication of data through XML
Using XSLT to transform XML documents

Teaching Methods

E-learning
Mandatory assignments
Exercises

Teaching Methods (additional text)

e-learning

Mandatory exercises

Form(s) of Assessment

Multiple Choice Test(s)
Home exam, see textarea

Form(s) of Assessment (additional text)

Multiple Choice Test(s)

Hjemmeeksamen

Grading Scale

Alphabetical Scale, A(best) – F (fail)

External/internal examiner

Internal examiner

Coursework Requirements

3-5 mandatory exercises

Teaching Materials

To be published in Study Guide at startup

Replacement course for

GEO1171

Additional information

GEO1171 Introduksjon til databaser har overlapp med databasedelen i emnet slik at studenter med fullført GEO1171 kan få fritak fra databasedelen i emnet.