Skip to main content
Till KTH:s startsida

IV1018 Models and Databases 7.5 credits

Administer About course

Information per course offering

Course offerings are missing for current or upcoming semesters.

Course syllabus as PDF

Please note: all information from the Course syllabus is available on this page in an accessible format.

Course syllabus IV1018 (Spring 2009–)
Headings with content from the Course syllabus IV1018 (Spring 2009–) are denoted with an asterisk ( )

Content and learning outcomes

Course contents

Introduction to databases and the relational model
Modeling and database terminology and theory
Conceptual modeling
Logical relational database design
Relational algebra
SQL
Transaction management
Relational database management systems:
# Recovery
# Parallelism
# Security
Brief introduction to embedded SQL in Java (JDBC)

Intended learning outcomes

After passing the course segment, the student shall:
- have insight in the area of databases
- have skills in modeling of information needs based on a business description
- have basic knowledge in information administration and database functionality
- be empowered to use relational databases and query languages

Literature and preparations

Specific prerequisites

For “single course” students:

  • Completed documented upper secondary education incl documented proficiency in English and Swedish.

Literature

Preliminary:

Connolly, Begg: Database Systems: A Practical Approach to Design, Implementation and Management (Upplaga: 4), Addison Wesley, 2005, 0-321-21025-5 

Course material:
- Course Information (including lesson exercises, project assignment, etc)
- Lecture slides
- Compendiums for Microsoft Access and MySQL

Examination and completion

Grading scale

A, B, C, D, E, FX, F

Examination

  • PRO1 - Project, 4.5 credits, grading scale: P, F
  • TEN1 - Examination, 3.0 credits, grading scale: A, B, C, D, E, FX, F

Based on recommendation from KTH’s coordinator for disabilities, the examiner will decide how to adapt an examination for students with documented disability.

The examiner may apply another examination format when re-examining individual students.

If the course is discontinued, students may request to be examined during the following two academic years.

Other requirements for final grade

The examination is divided into:
Written exam and project (including compulsory attendance for certain activities, completed quizes and labs).

For the written exam, the scale A/B/C/D/E/Fx/F is used, while for the rest, only pass or fail are used. Both parts are required for a pass grade on the course. The final course grade is based solely on the exam.

Examiner

No information inserted

Ethical approach

  • All members of a group are responsible for the group's work.
  • In any assessment, every student shall honestly disclose any help received and sources used.
  • In an oral assessment, every student shall be able to present and answer questions about the entire assignment and solution.

Further information

Course room in Canvas

Registered students find further information about the implementation of the course in the course room in Canvas. A link to the course room can be found under the tab Studies in the Personal menu at the start of the course.

Offered by

ICT/Systems Science (SU)

Main field of study

Technology

Education cycle

First cycle

Supplementary information

The course is included in the bachelor program "Affärssystem", 1st year.