Database Technology, 6 credits

Databasteknik, 6 hp

732A57

Main field of study

Computer Science

Course level

Second cycle

Course type

Programme course

Examiner

Olaf Hartig

Course coordinator

Olaf Hartig

Director of studies or equivalent

Patrick Lambrix
ECV = Elective / Compulsory / Voluntary
Course offered for Semester Weeks Timetable module Language Campus ECV
F7MSL Statistics and Machine Learning, Master´s Programme - First and main admission round 3 (Autumn 2022) 202244-202302 1 English Linköping, Valla E
F7MSL Statistics and Machine Learning, Master´s Programme - Second admission round (open only for Swedish/EU students) 3 (Autumn 2022) 202244-202302 1 English Linköping, Valla E

Main field of study

Computer Science

Course level

Second cycle

Advancement level

A1F

Course offered for

  • Master´s Programme in Statistics and Data Mining
  • Master's Programme in Statistics and Machine Learning

Entry requirements

  • 180 ECTS credits passed including 90 ECTS credits in one of the following subjects:
    • statistics
    • mathematics
    • applied mathematics
    • computer science
    • engineering
  • Completed courses in
    • calculus
    • linear algebra
    • statistics
    • machine learning
    • programming
  • English corresponding to the level of English in Swedish upper secondary education (Engelska 6)
    Exemption from Swedish
  • At least 30 ECTS credits passed from semester 1 and 2 Master's Programme in Statistics and Machine Learning, including the course Machine Learning 9 ECTS credits, or the equivalent

Intended learning outcomes

After the completion of the course you should on an advanced level 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. 

Course content

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
- 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.

Teaching and working methods

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.
Homework and independent study are a necessary complement to the course. Language of instruction: English. 

 

Examination

Written examination. Laboratory work.
Detailed information about the examination can be found in the course’s study guide. 

If special circumstances prevail, and if it is possible with consideration of the nature of the compulsory component, the examiner may decide to replace the compulsory component with another equivalent component.

If the LiU coordinator for students with disabilities has granted a student the right to an adapted examination for a written examination in an examination hall, the student has the right to it.

If the coordinator has recommended for the student an adapted examination or alternative form of examination, the examiner may grant this if the examiner assesses that it is possible, based on consideration of the course objectives.

An examiner may also decide that an adapted examination or alternative form of examination if the examiner assessed that special circumstances prevail, and the examiner assesses that it is possible while maintaining the objectives of the course.

Students failing an exam covering either the entire course or part of the course twice are entitled to have a new examiner appointed for the reexamination.

Students who have passed an examination may not retake it in order to improve their grades.

Grades

ECTS, EC

Other information

Planning and implementation of a course must take its starting point in the wording of the syllabus. The course evaluation included in each course must therefore take up the question how well the course agrees with the syllabus. 

The course is carried out in such a way that both men´s and women´s experience and knowledge is made visible and developed.

If special circumstances prevail, the vice-chancellor may in a special decision specify the preconditions for temporary deviations from this course syllabus, and delegate the right to take such decisions.

Department

Institutionen för datavetenskap
Code Name Scope Grading scale
LAB1 Laboratory work 3 credits EC
TENT Examination 3 credits EC
There is no course literature available for this course in studieinfo.

This tab contains public material from the course room in Lisam. The information published here is not legally binding, such material can be found under the other tabs on this page.

There are no files available for this course.