Syllabus for Database Design II

Databasteknik II

A revised version of the syllabus is available.

Syllabus

  • 5 credits
  • Course code: 1DL400
  • Education cycle: Second cycle
  • Main field(s) of study and in-depth level: Computer Science A1N, Technology A1N
  • Grading system: Fail (U), Pass (3), Pass with credit (4), Pass with distinction (5)
  • Established: 2007-03-15
  • Established by: The Faculty Board of Science and Technology
  • Revised: 2007-03-15
  • Revised by: The Faculty Board of Science and Technology
  • Applies from: Autumn 2007
  • Entry requirements:

    Database design I. Computer Programming, second course, or equivalent.

  • Responsible department: Department of Information Technology

Learning outcomes

To pass the student must be able to use design, techniques and representation methods that are used in modern database management systems for advanced applications.

Content

The course contains a deeper treatment of the database area that comprises

  • introduction to safety and access control,
  • mechanisms for data integrity,
  • an overview of advanced design of database systems with procedural SQL and application interfaces,
  • functions of active databases with database rules or triggers,
  • an overview of the functions of object-oriented and object relational databases,
  • query processing of database queries including relational algebra, relational calculus and query optimisation
  • the structure and the functions of a data warehouse
  • handling of non-conventional data within multimedia and spatial databases,
  • the structure and the functions of distributed database systems,
  • handling of XML-based data,
  • the tuning of database parameters, and
  • an overview of requirements from, and design of, advanced database applications.

Instruction

Lectures, problem solving sessions, laboratory work and assignments. Also seminars and guest lectures can occur.

Assessment

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

When the course is given in a course block with Database Design I both courses are examined together.

Other directives

Courses can occur where Database Design I and Database Design II are given integrated in a course block.

Reading list

Reading list

Applies from: Autumn 2007

Some titles may be available electronically through the University library.

  • Padron-McCarthy, Thomas; Risch, Tore Databasteknik

    Lund: Studentlitteratur, 2005

    Find in the library

  • Elmasri, Ramez; Navathe, Shamkant B. Fundamentals of database systems.

    4. ed. International ed.: Boston, Mass: Pearson/Addison-Wesley,

    Find in the library

Last modified: 2022-04-26