Student rights and obligations (login required)
Linköping University common rules and regulations (in Swedish)
Database Technology, 8 credits
Databasteknik, 8 hp
TDDD46
Main field of study
Computer Science and EngineeringCourse level
First cycleCourse type
Programme courseExaminer
Olaf HartigDirector of studies or equivalent
Patrick LambrixEducation components
Preliminary scheduled hours: 66 hRecommended self-study hours: 147 h
ECV = Elective / Compulsory / Voluntary
| Course offered for | Semester | Period | Timetable module | Language | Campus | ECV | |
|---|---|---|---|---|---|---|---|
| 6CITE | Information Technology, M Sc in Engineering | 5 (Autumn 2017) | 2 | 1 | Swedish | Linköping, Valla | C |
Main field of study
Computer Science and EngineeringCourse level
First cycleAdvancement level
G2XCourse offered for
- Information Technology, M Sc in Engineering
Entry requirements
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.
Prerequisites
Basic programming as well as data structures and algorithms.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 database systems. After the completion of the course you should be able to:
- explain and use important terminology in text-based information management in a correct way.
- design a data model using EER diagrams.
- design 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.
- explain which problems can occur when several users use the database and solutions to this.
- explain how a database can guarantee persistence of data.
Course content
- Principles for general database management systems: DBMS,
- Methods for database design and use. Datamodelling with ER,
- Relational databases, SQL and relational algebra
- Normalisation of relational databases
- Datastructures for databases, indexing
- Transactions and cncurrency
- Recovery of databases
- Exempels on how effective data management can support sustainable development through a scenario.
Teaching and working methods
The course consists of lectures, laboratory work and a
project. Lectures are devoted to theory and techniques. Database
design and implementation techniques are practised in the laboratory
work.
Examination
| BAS1 | Work in PBL group | 1 credits | U, G |
| LAB1 | Laboratory work | 4 credits | U, G |
| TEN1 | Written examination | 3 credits | U, 3, 4, 5 |
Grades
Four-grade scale, LiU, U, 3, 4, 5Other information
Supplementary courses: Advanced Data Models and Databases; data mining.
Department
Institutionen för datavetenskapDirector of Studies or equivalent
Patrick LambrixExaminer
Olaf HartigEducation components
Preliminary scheduled hours: 66 hRecommended self-study hours: 147 h
Course literature
Additional literature
Books
- Elmasri, R. and Navathe, S. B., Fundamentals of Database Systems 3e, 4e, 5e eller 6e upplaga Addison Wesley
OBSERVE: The title of the 6th edition is: Database Systems - Models, Languages, Design, and Application Programming.
| Code | Name | Scope | Grading scale |
|---|---|---|---|
| BAS1 | Work in PBL group | 1 credits | U, G |
| LAB1 | Laboratory work | 4 credits | U, G |
| TEN1 | Written examination | 3 credits | U, 3, 4, 5 |
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.
Additional literature
Books
Elmasri, R. and Navathe, S. B., Fundamentals of Database Systems 3e, 4e, 5e eller 6e upplaga Addison Wesley
OBSERVE: The title of the 6th edition is: Database Systems - Models, Languages, Design, and Application Programming.
Note: The course matrix might contain more information in Swedish.
I = Introduce, U = Teach, A = Utilize
| I | U | A | Modules | Comment | ||
|---|---|---|---|---|---|---|
| 1. DISCIPLINARY KNOWLEDGE AND REASONING | ||||||
| 1.1 Knowledge of underlying mathematics and science (G1X level) |
|
|
X
|
|||
| 1.2 Fundamental engineering knowledge (G1X level) |
|
X
|
|
|||
| 1.3 Further knowledge, methods, and tools in one or several subjects in engineering or natural science (G2X level) |
|
|
|
|||
| 1.4 Advanced knowledge, methods, and tools in one or several subjects in engineering or natural sciences (A1X level) |
|
|
|
|||
| 1.5 Insight into current research and development work |
|
|
|
|||
| 2. PERSONAL AND PROFESSIONAL SKILLS AND ATTRIBUTES | ||||||
| 2.1 Analytical reasoning and problem solving |
|
X
|
|
|||
| 2.2 Experimentation, investigation, and knowledge discovery |
|
X
|
|
|||
| 2.3 System thinking |
|
X
|
|
|||
| 2.4 Attitudes, thought, and learning |
|
X
|
|
|||
| 2.5 Ethics, equity, and other responsibilities |
|
X
|
|
|||
| 3. INTERPERSONAL SKILLS: TEAMWORK AND COMMUNICATION | ||||||
| 3.1 Teamwork |
|
X
|
|
|||
| 3.2 Communications |
|
X
|
|
|||
| 3.3 Communication in foreign languages |
|
|
|
|||
| 4. CONCEIVING, DESIGNING, IMPLEMENTING AND OPERATING SYSTEMS IN THE ENTERPRISE, SOCIETAL AND ENVIRONMENTAL CONTEXT | ||||||
| 4.1 External, societal, and environmental context |
|
X
|
X
|
|||
| 4.2 Enterprise and business context |
|
|
|
|||
| 4.3 Conceiving, system engineering and management |
|
X
|
|
|||
| 4.4 Designing |
|
X
|
|
|||
| 4.5 Implementing |
|
X
|
|
|||
| 4.6 Operating |
|
|
|
|||
| 5. PLANNING, EXECUTION AND PRESENTATION OF RESEARCH DEVELOPMENT PROJECTS WITH RESPECT TO SCIENTIFIC AND SOCIETAL NEEDS AND REQUIREMENTS | ||||||
| 5.1 Societal conditions, including economic, social, and ecological aspects of sustainable development for knowledge development |
|
|
X
|
|||
| 5.2 Economic conditions for knowledge development |
|
|
|
|||
| 5.3 Identification of needs, structuring and planning of research or development projects |
|
|
|
|||
| 5.4 Execution of research or development projects |
|
|
|
|||
| 5.5 Presentation and evaluation of research or development projects |
|
|
|
|||
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.