| TDDD12 |
Database Technology, 6 ECTS credits.
/Databasteknik/
For:
DI
Ii
IP
M
Mat
MMAT
Y
|
| |
Prel. scheduled
hours: 42
Rec. self-study hours: 118
|
| |
Area of Education: Technology
Main field of studies: Computer Engineering, Programming
|
| |
Advancement level
(G1, G2, A): G2
|
|
Aim:
The aim of this course is to give a thorough introduction to the
theoretical and practical issues underlying the design and
implementation of modern database systems. After the completion of
the course you should be able to:
- explain and use important terminology in text-based information management in a correct way.
- design a data model using EER diagrams.
- design and use a relational database.
- explain the theory behind the relational model and how this
affects good design of databases.
- explain which file structures in the database management system can be used to implement a database system.
- explain the basic principles for indexing a database.
- explain which problems can occur when several users use the database and solutions to this.
- explain how a database can guarantee persistence of data.
|
|
Prerequisites: (valid for students admitted to programmes within which the course is offered)
Basic programming and Data structures and algorithms.
Note: Admission requirements for non-programme students usually also include admission requirements for the programme and threshhold requirements for progression within the programme, or corresponding.
|
|
Supplementary courses:
Advanced Data Models and Databases; data mining
|
|
Organisation:
The course consists of lectures, laboratory work and a
project. Lectures are devoted to theory and techniques. Database
design and implementation techniques are practised in the laboratory
work.
|
|
Course contents:
Principles for general database management systems: DBMS, Methods for
database design and use. Datamodelling with ER, Relational databases,
Datastructures for databases, SQL, Relational algebra, query
optimization, transactions, serialisation, concurrency.
|
|
Course literature:
Elmasri, R. and Navathe, S. B. Fundamentals of Database Systems, 3e, 4th, 5th or 6th edition, Addison Wesley.
OBSERVE: The title of the 6th edition is: Database Systems - Models, Languages, Design, and Application Programming.
|
|
Examination: |
|
Written examination
Laboratory work
|
3 ECTS
3 ECTS
|
| |
|
|
Course language is English.
Department offering the course: IDA.
Director of Studies: Patrick Lambrix
Examiner: Jose M. Pena
Course Syllabus in Swedish
|