| TDDD37 |
Database Technology, 6 ECTS credits.
/Databasteknik/
For:
BME
CS
D
DAV
U
|
OBS! |
Overlaps with TDDD12 and TDDD46.
|
| |
Prel. scheduled
hours: 48
Rec. self-study hours: 112
|
| |
Area of Education: Technology
Main field of studies: Computer Science, Computer Engineerring, Information technology
|
| |
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 the most important terminology within databases and database technology in a correct way
- design a data model using EER diagrams.
- design, implement 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 and based on this design an efficient index for 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 and given desired properties explain how this is solved using recovery and back-up.
- explain the main principles behind heuristic query optimization
and given a query compute the efficiency of the optimization.
|
|
Prerequisites: (valid for students admitted to programmes within which the course is offered)
The course requires thorough knowledge in programming, data structures and algorithms, and mathematics preferrably directed towards discrete mathematics or logics.
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 and laboratory work. 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 EER, 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
Link to the course homepage at the department
Course Syllabus in Swedish
|