norsk norsk&engelsk / norwegian&english

Course Description IMT2031 - Database Modelling (2003/2004)

LevelUndergraduate
ECTS Credits6
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, structures 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
all mandatory assignments must be accepted before the exam
Supplementary Information