Syllabus for Database Design I

Databasteknik I


  • 5 credits
  • Course code: 1DL301
  • Education cycle: First cycle
  • Main field(s) of study and in-depth level: Computer Science G2F, Technology G2F, Sociotechnical Systems G2F
  • Grading system: Fail (U), Pass (3), Pass with credit (4), Pass with distinction (5)
  • Established: 2015-03-12
  • Established by: The Faculty Board of Science and Technology
  • Applies from: week 20, 2015
  • Entry requirements: 60 credits of which at least 15 credits in mathematics and 15 credits in computer science including basic programming.
  • Responsible department: Department of Information Technology

Learning outcomes

For a pass mark, the student must be able to

  • design and use relational databases in both theory and practical application.
  • explain basic differences between database design and conventional programming.
  • present and discuss the course content orally and in writing with proficiency appropriate to the course level.


The course contains

  • an introduction to the database area and database terminology,
  • entitets-relations (ER) modelling and expanded entitets-relations (EER) modelling,
  • an overview of the relational data model and relational algebra and transformation of the data representation from the ER data model to the relational data model,
  • an introduction to physical database design with functional dependencies and normalisation,
  • an introduction to queries, updates and data definition with help of the query language SQL,
  • an introduction to transactions, basic techniques for transaction management and concurrency control and recovery,
  • an introduction to physical database design with file organisation, single level index and tree index,
  • an introduction to procedural SQL and the application interface, and
  • an orientation in advanced database applications and -techniques.


Lectures, problem solving sessions, laboratory work and assignments. Seminars and guest lectures may occur.


Written examination (3 credits) and oral and written assignments (2 credits).

Reading list

Reading list

Applies from: week 20, 2015

  • Padron-McCarthy, Thomas; Risch, Tore Databasteknik

    Lund: Studentlitteratur, 2005

    Find in the library

  • Elmasri, Ramez; Navathe, Sham Fundamentals of database systems

    6. ed.: Upper Saddle River, N.J.: Pearson Education, 2010

    Find in the library