Search course

Use the search function to find more information about the study programmes and courses available at Chalmers. When there is a course homepage, a house symbol is shown that leads to this page.

Graduate courses

Departments' graduate courses for PhD-students.

​​​​
​​

Syllabus for

Academic year
TDA357 - Databases
 
Syllabus adopted 2008-02-27 by Head of Programme (or corresponding)
Owner: TKITE
7,5 Credits
Grading: TH - Five, Four, Three, Not passed
Education cycle: First-cycle
Major subject: Computer Science and Engineering, Information Technology
Department: 37 - COMPUTER SCIENCE AND ENGINEERING


Course round 1


Teaching language: English

Course module   Credit distribution   Examination dates
Sp1 Sp2 Sp3 Sp4 No Sp
0106 Examination 4,5c Grading: TH   4,5c   19 Dec 2008 pm H,  16 Apr 2009 am V
0206 Laboratory 3,0c Grading: UG   3,0c    

In programs

TIDAL COMPUTER ENGINEERING, Year 3 (compulsory)
TKDAT COMPUTER SCIENCE AND ENGINEERING, Year 3 (elective)
TKIEK INDUSTRIAL ENGINEERING AND MANAGEMENT - Information technology, Year 3 (elective)
TKITE SOFTWARE ENGINEERING, Year 3 (elective)
ITMDM HUMAN COMPUTER INTERACTION - INTERACTIONDESIGN, Year 2 (elective)
MPBME BIOMEDICAL ENGINEERING, MSC PROGR, Year 1 (elective)
MPBME BIOMEDICAL ENGINEERING, MSC PROGR, Year 2 (elective)
MPIDE INTERACTION DESIGN, MSC PROGR, Year 2 (elective)
MPSYS SYSTEMS, CONTROL AND MECHATRONICS, MSC PROGR - Automation specialization, Year 1 (elective)
MPSYS SYSTEMS, CONTROL AND MECHATRONICS, MSC PROGR - Automation specialization, Year 2 (elective)

Examiner:

Docent  Sven-Arne Andreasson
Docent  Rogardt Heldal
Bitr professor  Graham Kemp



Course round 2


Teaching language: English

Course module   Credit distribution   Examination dates
Sp1 Sp2 Sp3 Sp4 No Sp
0106 Examination 4,5c Grading: TH   4,5c   13 Mar 2009 pm V
2) 14 Mar 2009 8.30 am HA, HB, HC
27 Aug 2009 am V
2) Responsible: Programansv IT Decision date: 2009-02-02
0206 Laboratory 3,0c Grading: UG   3,0c    

In programs

TKDAT COMPUTER SCIENCE AND ENGINEERING, Year 3 (elective)
TKITE SOFTWARE ENGINEERING, Year 2 
TKITE SOFTWARE ENGINEERING, Year 3 (elective)
MPBIS BIOINFORMATICS AND SYSTEMS BIOLOGY, MSC PROGR - Systems biology track, Year 1 (elective)
MPBIS BIOINFORMATICS AND SYSTEMS BIOLOGY, MSC PROGR, Year 2 (elective)
MPBME BIOMEDICAL ENGINEERING, MSC PROGR, Year 2 (elective)
MPSYS SYSTEMS, CONTROL AND MECHATRONICS, MSC PROGR - Automation specialization, Year 1 (elective)

Examiner:

Docent  Sven-Arne Andreasson
Docent  Rogardt Heldal
Bitr professor  Graham Kemp



Replaces

TDA355   Data bases TDA356   Databases

Course evaluation:

http://document.chalmers.se/doc/677401709


  Go to Course Homepage

Eligibility:

For single subject courses within Chalmers programmes the same eligibility requirements apply, as to the programme(s) that the course is part of.

Course specific prerequisites

Programming experience (in Java) is a prerequisite, as is basic mathematical maturity, and a course in data structures. Dispensations can only be permitted with the permission of the course instructor.

Aim

Databases are a ubiquitous feature of the information technology society, and most people have come in contact with them, either directly while using the world wide web, or indirectly through banks, the tax office, etc. A course on database systems is therefore essential to a well-rounded education in computer science.

Learning outcomes (after completion of the course the student should be able to)

By the end of the course the student should know how to design and use databases as an end user, as an application programmer and as a database administrator.

Content

The course covers the basic principles of database systems as seen by users, application programmers and database administrators. A laboratory assignment develops these topics as a running example throughout the course. These include programming in SQL, as seen by a user querying or modifying an existing database, by a database designer, and by an application programmer invoking SQL from a host language.

Course contents include:
* Entity-Relationship modelling
* Functional Dependencies and Normalisation
* Database querying and manipulation through SQL
* Interfacing to a database from a host language (Java/JDBC)
* The semi-structured model, XML

The course is thus a typical first course in database systems, and occupies a traditional place in the curriculum.

Organisation

The course consists of weekly lectures and exercise sessions. There is also a laboratory assignment divided into the following parts:

1. Designing a database
2. Implementing the above database
3. Using the database from an external application

Literature

Information about literature will be given on the course home-page before the start of the course.

Examination

Written exam and passed laboration. Alternative modes of examination can occur.


Page manager Published: Thu 04 Feb 2021.