Main field of studyBiotechnology Computer Science and Engineering
Course typeProgramme course
Director of studies or equivalentPatrick Lambrix
|Course offered for||Semester||Period||Timetable module||Language||Campus||VOF|
|6CTBI||Engineering Biology, M Sc in Engineering||4 (Spring 2018)||2||4||Swedish/English||Linköping||o|
|6CMED||Biomedical Engineering, M Sc in Engineering (Biomedical Modelling)||8 (Spring 2018)||2||4||Swedish/English||Linköping||v|
|6CMED||Biomedical Engineering, M Sc in Engineering||8 (Spring 2018)||2||4||Swedish/English||Linköping||v|
Main field of studyBiotechnology, Computer Science and Engineering
Course levelFirst cycle
Course offered for
- Engineering Biology, M Sc in Engineering
- Biomedical Engineering, M Sc in Engineering
The course is not availble for exchange students
Note: Admission requirements for non-programme students usually also include admission requirements for the programme and threshold requirements for progression within the programme, or corresponding.
Basic programming course.
Intended learning outcomes
The aim of this course is to give a thorough introduction to the theoretical and practical issues underlying the design and implementation of modern biological database systems that are used in bioinformatics research.
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 and 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 which problems can occur when a user needs to integrate information from different databases and solutions to this.
Methods for storage of information: text, semi-structured data, data models, rules. Text: basic issues in information retrieval, conceptual models, file models, query mechanisms, ranking. Semi-structured data: conceptual model, query mechanisms. Data models: relational model, object-oriented model. Databases:
General database management systems (DBMS). Methods for data modelling and database design. Physical database. Data structures for databases. Query language. Multiple user issues: transactions, concurrency control and recovery. Integration of biological databases.
Teaching and working methods
The course consists of lectures, laboratory work and a project. Some lectures are given in English. Lectures are devoted to theory and techniques. Database design and implementation techniques are practised in the laboratory work. During the project work a number of well-known biological databases are studied and a database system that integrates the information in these sources is implemented.
|LAB1||Laboratory work and project||U, G||3 credits|
|TEN1||Written examination||U, 3, 4, 5||3 credits|
GradesFour-grade scale, LiU, U, 3, 4, 5
Supplementary courses: Advanced Data Models and Databases; data mining
DepartmentInstitutionen för datavetenskap
Director of Studies or equivalentPatrick Lambrix
Course website and other linkshttp://www.ida.liu.se/~TDDD74/
Education componentsPreliminary scheduled hours: 50 h
Recommended self-study hours: 110 h
Course literatureElmasri, R. and Navathe, S. B. Fundamentals of Database Systems, 3e, 4e, 5e, 6e eller 7e upplaga, Addison Wesley. Artikelsamling 2015.
|LAB1||Laboratory work and project||U, G||3 credits|
|TEN1||Written examination||U, 3, 4, 5||3 credits|
A syllabus has been established for each course. The syllabus specifies the aim and contents of the course, and the prior knowledge that a student must have in order to be able to benefit from the course.
Courses are timetabled after a decision has been made for this course concerning its assignment to a timetable module. A central timetable is not drawn up for courses with fewer than five participants. Most project courses do not have a central timetable.
Interrupting a course
The vice-chancellor’s decision concerning regulations for registration, deregistration and reporting results (Dnr LiU-2015-01241) states that interruptions in study are to be recorded in Ladok. Thus, all students who do not participate in a course for which they have registered must record the interruption, such that the registration on the course can be removed. Deregistration from a course is carried out using a web-based form: www.lith.liu.se/for-studenter/kurskomplettering?l=sv.
Courses with few participants (fewer than 10) may be cancelled or organised in a manner that differs from that stated in the course syllabus. The board of studies is to deliberate and decide whether a course is to be cancelled or changed from the course syllabus.
Regulations relating to examinations and examiners
Details are given in a decision in the university’s rule book: http://styrdokument.liu.se/Regelsamling/VisaBeslut/622678.
Forms of examination
Written and oral examinations are held at least three times a year: once immediately after the end of the course, once in August, and once (usually) in one of the re-examination periods. Examinations held at other times are to follow a decision of the board of studies.
Principles for examination scheduling for courses that follow the study periods:
- courses given in VT1 are examined for the first time in March, with re-examination in June and August
- courses given in VT2 are examined for the first time in May, with re-examination in August and October
- courses given in HT1 are examined for the first time in October, with re-examination in January and August
- courses given in HT2 are examined for the first time in January, with re-examination at Easter and in August.
The examination schedule is based on the structure of timetable modules, but there may be deviations from this, mainly in the case of courses that are studied and examined for several programmes and in lower grades (i.e. 1 and 2).
- Examinations for courses that the board of studies has decided are to be held in alternate years are held only three times during the year in which the course is given.
- Examinations for courses that are cancelled or rescheduled such that they are not given in one or several years are held three times during the year that immediately follows the course, with examination scheduling that corresponds to the scheduling that was in force before the course was cancelled or rescheduled.
- If teaching is no longer given for a course, three examination occurrences are held during the immediately subsequent year, while examinations are at the same time held for any replacement course that is given, or alternatively in association with other re-examination opportunities. Furthermore, an examination is held on one further occasion during the next subsequent year, unless the board of studies determines otherwise.
- If a course is given during several periods of the year (for programmes, or on different occasions for different programmes) the board or boards of studies determine together the scheduling and frequency of re-examination occasions.
Registration for examination
In order to take an examination, a student must register in advance at the Student Portal during the registration period, which opens 30 days before the date of the examination and closes 10 days before it. Candidates are informed of the location of the examination by email, four days in advance. Students who have not registered for an examination run the risk of being refused admittance to the examination, if space is not available.
Symbols used in the examination registration system:
** denotes that the examination is being given for the penultimate time.
* denotes that the examination is being given for the last time.
Code of conduct for students during examinations
Details are given in a decision in the university’s rule book: http://styrdokument.liu.se/Regelsamling/VisaBeslut/622682.
Retakes for higher grade
Students at the Institute of Technology at LiU have the right to retake written examinations and computer-based examinations in an attempt to achieve a higher grade. This is valid for all examination components with code “TEN” and "DAT". The same right may not be exercised for other examination components, unless otherwise specified in the course syllabus.
Retakes of other forms of examination
Regulations concerning retakes of other forms of examination than written examinations and computer-based examinations are given in the LiU regulations for examinations and examiners, http://styrdokument.liu.se/Regelsamling/VisaBeslut/622678.
For examinations that involve the writing of reports, in cases in which it can be assumed that the student has had access to other sources (such as during project work, writing essays, etc.), the material submitted must be prepared in accordance with principles for acceptable practice when referring to sources (references or quotations for which the source is specified) when the text, images, ideas, data, etc. of other people are used. It is also to be made clear whether the author has reused his or her own text, images, ideas, data, etc. from previous examinations.
A failure to specify such sources may be regarded as attempted deception during examination.
Attempts to cheat
In the event of a suspected attempt by a student to cheat during an examination, or when study performance is to be assessed as specified in Chapter 10 of the Higher Education Ordinance, the examiner is to report this to the disciplinary board of the university. Possible consequences for the student are suspension from study and a formal warning. More information is available at https://www.student.liu.se/studenttjanster/lagar-regler-rattigheter?l=sv.
The grades that are preferably to be used are Fail (U), Pass (3), Pass not without distinction (4) and Pass with distinction (5). Courses under the auspices of the faculty board of the Faculty of Science and Engineering (Institute of Technology) are to be given special attention in this regard.
- Grades U, 3, 4, 5 are to be awarded for courses that have written examinations.
- Grades Fail (U) and Pass (G) may be awarded for courses with a large degree of practical components such as laboratory work, project work and group work.
- Grades U, 3, 4, 5 are to be awarded for written examinations (TEN).
- Grades Fail (U) and Pass (G) are to be used for undergraduate projects and other independent work.
- Examination components for which the grades Fail (U) and Pass (G) may be awarded are laboratory work (LAB), project work (PRA), preparatory written examination (KTR), oral examination (MUN), computer-based examination (DAT), home assignment (HEM), and assignment (UPG).
- Students receive grades either Fail (U) or Pass (G) for other examination components in which the examination criteria are satisfied principally through active attendance such as other examination (ANN), tutorial group (BAS) or examination item (MOM).
The examination results for a student are reported at the relevant department.
Regulations (apply to LiU in its entirety)
The university is a government agency whose operations are regulated by legislation and ordinances, which include the Higher Education Act and the Higher Education Ordinance. In addition to legislation and ordinances, operations are subject to several policy documents. The Linköping University rule book collects currently valid decisions of a regulatory nature taken by the university board, the vice-chancellor and faculty/department boards.
LiU’s rule book for education at first-cycle and second-cycle levels is available at http://styrdokument.liu.se/Regelsamling/Innehall/Utbildning_pa_grund-_och_avancerad_niva.
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.