This course is replaced by IN2090 - Databaser og datamodellering.

Schedule, syllabus and examination date

Choose semester

Course content

What databases are, and what distinguishes them from ordinary files.
A method for designing a database for a given application area (the result is called a data model).
To use SQL to realize a data model as a physical database and to insert, update, and delete data in such databases.
Thorough training in using SQL as a query language.
How to use SQL in the Java programming language.
A simple introduction to the theory for relational databases.

Learning outcome

After the course the students will learn:

-to design data models and realize these in terms of relational databases
-advanced use of SQL as a query language towards relational databases
-how to embed relational database queries in programming languages like Java
-how to decide if a relational database has insertion or update anomalie

Admission

Students who are admitted to study programmes at UiO must each semester register which courses and exams they wish to sign up for in Studentweb.

If you are not already enrolled as a student at UiO, please see our information about admission requirements and procedures.

Prerequisites

Formal prerequisite knowledge

In addition to fulfilling the Higher Education Entrance Qualification, applicants have to meet the following special admission requirements:

  • Mathematics R1 or Mathematics (S1+S2)

The special admission requirements may also be covered by equivalent studies from Norwegian upper secondary school or by other equivalent studies. Read more about special admission requirements (in Norwegian).

INF1000 - Introduction to object-oriented programming (continued) or HUMIT1700 - Grunnkurs i programmering for humanister (discontinued) or INF1100 - Introduction to programming with scientific applications (continued)

Recommended previous knowledge

Overlapping courses

  • 10 credits overlap with IN114
  • 10 credits overlap with IN114A

Teaching

2 hours lecture and 2 hours group work per week. Mandatory assignments must be completed during the course. Rules for mandatory assignments.

Examination

Written digital exam (6 hours) at the end of the semester. The mandatory assignments must be approved prior to the exam. 

Examination support material

Halpin & Morgan: Information Modelling and Relational Databases. Second Edition.

Grading scale

Grades are awarded on a scale from A to F, where A is the best grade and F is a fail. Read more about the grading system.

Explanations and appeals

Resit an examination

This course offers both postponed and resit of examination. Read more:

Withdrawal from an examination

It is possible to take the exam up to 3 times. If you withdraw from the exam after the deadline or during the exam, this will be counted as an examination attempt.

It will also be counted as one of your three attempts to sit the exam for this course, if you sit the exam for one of the following courses: IN112, IN113, IN114, and IN114A

Other

The first lecture is mandatory.

Facts about this course

Credits

10

Level

Bachelor

Teaching

Every autumn

This course is taught for the last time autumn 2017.

Examination

Every autumn

Exams can be retaken for the last time during autumn 2018 and 2019 for those who have mandatory assignments approved.

Teaching language

Norwegian