Search programme

​Use the search function to search amongst programmes at Chalmers. The study programme and the study programme syllabus relating to your studies are generally from the academic year you began your studies.

Syllabus for

Academic year
TDA355 - Data bases
 
Owner: TDATA
4,0 Credits (ECTS 6)
Grading: TH - Five, Four, Three, Not passed
Level: A
Department: 37 - COMPUTER SCIENCE AND ENGINEERING


Course round 1


Teaching language: English

Course module   Credit distribution   Examination dates
Sp1 Sp2 Sp3 Sp4 No Sp
0101 Examination 4,0 c Grading: TH   4,0 c   14 Dec 2004 pm V,  01 Apr 2005 am V   26 Aug 2005 am V
0201 Laboratory 0,0 c Grading: UG   0,0 c    

In programs

TAUTA AUTOMATION AND MECHATRONICS ENGENEERING, Year 4 (elective)
TDATA COMPUTER SCIENCE AND ENGINEERING, Year 3 (elective)
TDATA COMPUTER SCIENCE AND ENGINEERING - Engineering of Computer-Based Systems, Year 4 (elective)
TDATA COMPUTER SCIENCE AND ENGINEERING - Interactive simulations and games, Year 4 (elective)
TELTA ELECTRICAL ENGINEERING, Year 4 (elective)
TIEKA INDUSTRIAL ENGINEERING AND MANAGEMENT, Year 4 (elective)
TMASA MECHANICAL ENGINEERING, Year 4 (elective)
TTFYA ENGINEERING PHYSICS, Year 4 (elective)

Examiner:

Forskarassistent  Marcin Benke



Course round 2


Teaching language: English

Course module   Credit distribution   Examination dates
Sp1 Sp2 Sp3 Sp4 No Sp
0101 Examination 4,0 c Grading: TH   4,0 c   28 May 2005 pm V   26 Aug 2005 am V
0201 Laboratory 0,0 c Grading: UG   0,0 c    

In programs

TAUTA AUTOMATION AND MECHATRONICS ENGENEERING, Year 4 (elective)
TDATA COMPUTER SCIENCE AND ENGINEERING, Year 3 (elective)
TDATA COMPUTER SCIENCE AND ENGINEERING - Engineering of Computer-Based Systems, Year 4 (elective)
TDATA COMPUTER SCIENCE AND ENGINEERING - Interactive simulations and games, Year 4 (elective)
TELTA ELECTRICAL ENGINEERING, Year 4 (elective)
TIEKA INDUSTRIAL ENGINEERING AND MANAGEMENT - Information Technology , Year 3 (compulsory)
TIEKA INDUSTRIAL ENGINEERING AND MANAGEMENT, Year 4 (elective)
TTFYA ENGINEERING PHYSICS, Year 4 (elective)

Examiner:

Forskarassistent  Marcin Benke




Eligibility:

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

Content

How a modern database management system (DBMS) works: the physical organisation of secondary memory, and the various levels of abstraction through which a databse is viewed. Most present day DBMS are relational, and the course concentrates mostly on these, and on SQL as the main database query and data manipulation language. The relational model, algebra and calculus are studied in detail, as are integrity constraints and functional dependencies and normalisation.

Other approaches such as QBE, object oriented languages, etc. are treated without much detail.

The course also studies transaction management in some detail, including atomicity, serialisability and recovery. Query
implementation and security are studied, but in less detail.

Organisation

The course is organiserad as lectures, exercise sessions and laboratory assignments. In the autumn term the course is given in English.

Literature

Currently we are using "Database System Concepts", 4th. ed., by Silberschatz, Korth and Sudarshan, published by McGraw-Hill. The literature to be used is announced in advance on the course home page.

Examination

The course is examined by laboratory assignments and a written examination. Possible grades: U, 3, 4, 5.


Page manager Published: Mon 28 Nov 2016.