norsk norsk&engelsk / norwegian&english

Course Description GEO8001 - Data Base Modelling (2003/2004)

LevelUndergraduate
ECTS Credits5
Duration1 semester (Autumn)
LanguageNorwegian
Prerequisite(s) 
Aim

The students should have achieved the following knowledge:
- knowing the different database models (weight on the relational database model)
- using ER-modelling in building databases
- designing databases and manageing information in local and external networks

Content

- Basic theory
- The relational model, ER-modeling, normalization, Three Level Architecture, stuctures and indexes
- Designing and using SQL servers, SQL language
- Data exchange in networks, security

Study MethodsLectures, Mandatory Assignments, Exercises in the computer laboratory
AssessmentWritten Exam, 3 hours (counts 70%)
Assignment(s) (counts 30%)
Grading SystemAlphabetical Scale, A (best) - F (fail)
Course RequirementsAssignments
Compulsory exercises must be accepted before the exam
Supplementary Information