Course syllabus
Databasteknik
Database Technology
EDAF75, 7,5 credits, G2 (First Cycle)
Valid for: 2017/18
Decided by: PLED C/D
Date of Decision: 2017-04-03
General Information
Main field: Technology.
Compulsory for: C2
Elective for: BME4, D4-pv, D4-se, E4-pv, F4, F4-pv, I4, 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 program and web interfaces to databases
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: object-oriented databases, NoSQL-databases,
semistructured data (XML).
- 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: Written examination. Compulsory course items: computer laboratory exercises, project. The final grade of the course is based on the result of the written examination.
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.
Parts
Code: 0117. Name: Laboratory Work and Assignment.
Credits: 3. Grading scale: UG. Assessment: To qualify for a passing grade the laboratory exercises and the assignment must be completed.
Code: 0217. Name: Written Examination.
Credits: 4,5. Grading scale: TH. Assessment: Written examination. The final grade of the course is based on the examination.
Admission
Admission requirements:
- EDA016 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
Required prior knowledge: EDAA01 Programming - Second Course.
The number of participants is limited to: No
The course overlaps following course/s: EDA215, EDA636, EDAF20, EXTN70, EDA216
Reading list
- 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 and other information
Course coordinator: Christian Söderberg, christian.soderberg@cs.lth.se
Course homepage: http://cs.lth.se/edaf75