Database Technology
Databasteknik

EDAF20, 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

Depth of study relative to the degree requirements: First cycle, in-depth level of the course cannot be classified
Mandatory for: IDA2, IEA2
Language of instruction: The course will be given in English

Aim

The course gives basic theoretical and practical knowledge about database systems and their organization. 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 normalize 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 organize 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 management systems. The basics of the relational model, the query language SQL. Methods for data modelling and database design, E/R and UML diagrams. Theory of relational databases: functional dependencies, normalization, relational algebra. Programmable SQL, triggers. Programing interfaces to databases
• An orientation about other data models, for example, NoSQL databases, semi structured data (JSON, XML)
• Security and integrity in databases, concurrency, transactions. An orientation about implementation of database managers and of query languages.

Examination details

Grading scale: TH - (U, 3, 4, 5) - (Fail, Three, Four, Five)
Assessment: Written examination. For a passing grade the laboratory exercises and the project must also be completed. The final grade of the course is based on the result of the written examination, which takes place after the first study period of the course.

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: 0124. Name: Laboratory Work.
Credits: 1.5. Grading scale: UG - (U, G). Assessment: For a passing grade the laboratory work must have been completed. The module includes: Compulsory laboratory work.
Code: 0224. Name: Project.
Credits: 1.5. Grading scale: UG - (U, G). Assessment: For a passing grade the project must be completed. The module includes: Compulsory project.
Code: 0324. Name: Examination.
Credits: 4.5. Grading scale: TH - (U, 3, 4, 5). Assessment: Written examination. The final grade of the course is based on the result of this exam.

Admission

Admission requirements:

• EDAA10 Computer Programming in Java

Reading list

• Databasteknik: Databasteknik - Thomas Padron-McCarthy, Tore Risch. Studentlitteratur, 2018, ISBN: 9789144069197. The first edition of this book can also be used.
• or.
• Garcia-Molina, H & Ullman, J D & Widom, J: Database systems - The Complete Book, Second Edition (International Edition). Prentice Hall, 2009, ISBN: 0-13-135428-0. The first edition of this book can also be used.

Contact

Course coordinator: Alma Orucevic-Alagic, alma.orucevic-alagic@cs.lth.se
Course coordinator: Marcus Klang, marcus.klang@cs.lth.se
Director of studies: Studierektor, studierektor@cs.lth.se
Course homepage: https://cs.lth.se/edaf20

Further information