Syllabus for Database Design I

Databasteknik I

Syllabus

  • 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

    Explanation of codes

    The code indicates the education cycle and in-depth level of the course in relation to other courses within the same main field of study according to the requirements for general degrees:

    First cycle

    • G1N: has only upper-secondary level entry requirements
    • G1F: has less than 60 credits in first-cycle course/s as entry requirements
    • G1E: contains specially designed degree project for Higher Education Diploma
    • G2F: has at least 60 credits in first-cycle course/s as entry requirements
    • G2E: has at least 60 credits in first-cycle course/s as entry requirements, contains degree project for Bachelor of Arts/Bachelor of Science
    • GXX: in-depth level of the course cannot be classified

    Second cycle

    • A1N: has only first-cycle course/s as entry requirements
    • A1F: has second-cycle course/s as entry requirements
    • A1E: contains degree project for Master of Arts/Master of Science (60 credits)
    • A2E: contains degree project for Master of Arts/Master of Science (120 credits)
    • AXX: in-depth level of the course cannot be classified

  • Grading system: Fail (U), Pass (3), Pass with credit (4), Pass with distinction (5)
  • Established: 2015-03-12
  • Established by:
  • Revised: 2019-02-19
  • Revised by: The Faculty Board of Science and Technology
  • Applies from: week 27, 2019
  • Entry requirements: 60 credits of which 15 credits in mathematics and 15 credits in computer science including basic programming
  • Responsible department: Department of Information Technology

Learning outcomes

On completion of the course the student shall be able to:

  • create conceptual models of relational databases based on requirement specification documents;
  • translate a conceptual model to the relational model;
  • create, modify and query relational databases using the SQL language;
  • apply normalization techniques to reduce data redundancy and improve data integrity;
  • create computer programs which store, modify and query data stored in databases;
  • set up indexes and use other techniques to improve the performance of databases;
  • set up users and their privileges;
  • explain principles of security in database systems and apply protection mechanisms.
  • present and discuss the course content orally and in writing with proficiency appropriate to the course level.

Content

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.

Instruction

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

Assessment

Written examination and oral and written assignments.

If there are special reasons for doing so, an examiner may make an exception from the method of assessment indicated and allow a student to be assessed by another method. An example of special reasons might be a certificate regarding special pedagogical support from the disability coordinator of the university.

Reading list

Reading list

Applies from: week 27, 2019

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, Sham Fundamentals of database systems

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

    Find in the library