Study Guide@lith   Link to LiU Homepage
 

Linköping Institute of Technology

Search

 Link to LiU Homepage
 
Valid for year : 2007
 
TDDC94 Database Technology, 8 ECTS credits.
/Databasteknik/

For:   COS   CS   D   IT   Y  

 

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

  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:
  • understand and be able to use important terminology in text-based information management in a correct way.
  • be able to design a data model using EER diagrams.
  • be able to design and use a relational database.
  • understand the theory behind the relational model och how this affects good design of databases.
  • understand which file structures in the database management system can be used to implement a database system.
  • know the basic principles for indexing a database.
  • understand which problems can occur when several users use the database and solutions to this.
  • understand how a database can guarantee persistence of data och how this is solved using recovery and back-up.
  • understand 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)
Basic programming course. Knowledge about data structures and algorithms (for instance, TDDB56, TDDB57 or TDDB28)

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:
Multimedia databases are studied in TDDC08 Multimedia information retrieval.
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
 - p
- p
/
/
4 ECTS
4 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/18/2007