Study Guide@lith   Link to LiU Homepage
 

Linköping Institute of Technology

Search

 Link to LiU Homepage
 
Valid for year : 2009
 
TDDD37 Database Technology, 6 ECTS credits.
/Databasteknik/

For:   BME   COM   COS   CS   D   IT   Y  

 

Prel. scheduled hours: 50
Rec. self-study hours: 110

  Area of Education: Technology

Subject area: Computer Science/Computer Engineering
  Advancement level (G1, G2, A): G2

Aim:
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
  • design a data model using EER diagrams.
  • design, implement and use a relational database.
  • explain the theory behind the relational model och 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 be able to 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, discrete mathematics, 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.
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 ER, Relational databases, Datastructures for databases, SQL, Relational algebra, query optimization, transactions, serialisation, concurrency.
Course literature:
Elmasri & Navathe, Fundamentals of Database Systems, Fifth edition, 2006.
Examination:
Written examination
Laboratory work
 3 ECTS
3 ECTS
 


Course language is English.
Department offering the course: IDA.
Director of Studies: Lena Strömbäck
Examiner: Lena Strömbäck
Link to the course homepage at the department


Course Syllabus in Swedish

Linköping Institute of Technology
Link to top of pagep


Contact: TFK , val@tfk.liu.se
Last updated: 11/04/2008