Databases and modelling
Level of Study
Objectives and Content
Objectives and Content
The course provides an introduction to methods for organizing, structuring, representing and storing large amounts of information.
The main emphasis lies on techniques for data modeling, as well as the theory for relational databases. Other important topics are relational algebra, query language, storage media and storage methods. The privacy aspects are addressed in the context of collecting and processing data.
On completion of the course, the student:
- has knowledge of the query language SQL,
- has knowledge of data modeling and ER diagrams,
- can explain important principles of database design,
- can explain the most important parts of relational algebra,
- has knowledge of database administration and database applications,
- has knowledge of the Personal Data law and can discuss ethical aspects of data handling and privacy.
- can use the query language SQL,
- can use data modeling to propose sensible data structures based on unstructured information about a given problem area,
- can use such data structures using a database tool,
- can design relational databases,
- can create simple web applications.
- has insight into relevant professional and ethical issues,
- can plan and carry out database projects in teams and in line with ethical requirements and guidelines,
- can convey key subject matter both in writing, orally and through other relevant forms of expression, and
- can exchange views and experiences with others with a background within the subject area and through this contribute to good practice.
Required Previous Knowledge
Credit Reduction due to Course Overlap
INFO122: 5 ECTS
INFO125: 5 ECTS
Access to the Course
Access to the course requires admission to a programme of study at The Faculty of Mathematics and Natural Sciences.
Teaching and learning methods
Up to 6 hours each week for 13 weeks alternating between lectures and time for software projects, in addition 2 hours per week for exercises and team supervision. Expect a total workload in excess of 270 study hours including assignments and self-study.
Compulsory Assignments and Attendance
Project team work and presentations must be passed. Presence at compulsory lectures.
Compulsory assignments are valid for two subsequent semesters.
Forms of Assessment
Written exam (3 hours).
Results from project work and presentations may be taken into account.
Examination Support Material
Legal exam aids will be announced at the start of every semester.
The grading scale used is A to F. Grade A is the highest passing grade in the grading scale, grade F is a fail.
Examination both spring semester and autumn semester. In semesters without teaching the examination will be arranged at the beginning of the semester.
The reading list will be available within June 1st for the autumn semester and December 1st for the spring semester.
The course will be evaluated by the students in accordance with the quality assurance system at UiB and the department.
Programstyret har ansvar for fagleg innhald og oppbygging av studiet og for kvaliteten på studieprogrammet og alle emna der.
Course coordinator and administrative contact person can be found on Mitt UiB, or contact
The Faculty of Mathematics and Natural Sciences represented by the Department of Informatics is the course administrator for the course and study programme.
T: 55 58 42 00
For written exams, please note that the start time may change from 09:00 to 15:00 or vice versa until 14 days prior to the exam.
Type of assessment: Written examination
- 23.05.2023, 15:00
- 3 hours
- Withdrawal deadline
- Examination result announcement
- Examination system
- Digital exam
- Damsgårdsveien 125, DAM 1. etg., DAM 2. etg.