INF1300 – Introduction to Databases
Course description
Schedule, syllabus and examination date
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.