Database Technology
Databasteknik

EDAF75, 7.5 credits, G2 (First Cycle)

Valid for: 2024/25
Faculty: Faculty of Engineering LTH
Decided by: PLED C/D
Date of Decision: 2024-04-16
Effective: 2024-05-08

General Information

Main field: Technology Depth of study relative to the degree requirements: First cycle, in-depth level of the course cannot be classified
Mandatory for: C3
Elective for: BME4, D4-pv, D4-se, E4-pv, E4-ae, F4, F4-pv, I4-pvs, L4-gi, Pi4-pv
Language of instruction: The course will be given in Swedish

Aim

The course gives basic theoretical and practical knowledge about database systems and their organisation. The emphasis is on relational databases.

Learning outcomes

Knowledge and understanding
For a passing grade the student must

• be able to describe information systems with E/R models and UML notation, and translate such models into relational form
• be able to normalise database schemas
• be able to use the query language SQL to create and update a database, and to retrieve information from the database
• know about alternative ways to organise data in databases and about the design of database management systems

Competences and skills
For a passing grade the student must

• be able to use tools to implement a database
• be able to develop application programming interfaces to databases

Judgement and approach
For a passing grade the student must

Contents

• Introduction to database systems. Basics of the relational model, the query language SQL. Methods for data modelling and database design, E/R diagrams and UML diagrams. Theory for the relational model: functional dependencies, normalisation, relational algebra. Stored procedures, triggers. Program and web interfaces to databases.
• Other data models: NoSQL-databases, semistructured data (JSON).
• Security and integrity in databases, concurrency, transactions. Implementation of database management systems and query languages.

Examination details

Grading scale: TH - (U, 3, 4, 5) - (Fail, Three, Four, Five)
Assessment:

For a final grade, approved laboratory work, approved assignment and an approved written exam, are required. The final grade is based on the result of the written exam.

The examiner, in consultation with Disability Support Services, may deviate from the regular form of examination in order to provide a permanently disabled student with a form of examination equivalent to that of a student without a disability.

Modules
Code: 0117. Name: Laboratory Work and Assignment.
Credits: 3.0. Grading scale: UG - (U, G). Assessment: To qualify for a passing grade the laboratory exercises and the assignment must be completed. The module includes: Laboratory work and assignment.
Code: 0217. Name: Written Examination.
Credits: 4.5. Grading scale: TH - (U, 3, 4, 5). Assessment: The final grade of the course is based on the exam. The module includes: Written exam.

Admission

Admission requirements:

• EDA011 Programming, First Course or EDA016 Programming, First Course or EDA017 Programming, First Course or EDAA10 Computer Programming in Java or EDAA20 Programming and Databases or EDAA45 Introduction to Programming or EDAA50 Programming, First Course or EDAA55 Programming, First Course or EDAA65 Programming, First Course

Reading list

Contact

Course coordinator: Christian Söderberg, christian.soderberg@cs.lth.se
Course administrator: Birger Swahn, Birger.Swahn@cs.lth.se
Course administrator: Ulrika Templing, ulrika.templing@cs.lth.se
Course homepage: https://cs.lth.se/edaf75