Syllabus for |
|
| 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
TELTA ELECTRICAL ENGINEERING, Year 4 (elective)
TMASA MECHANICAL ENGINEERING, Year 4 (elective)
TTFYA ENGINEERING PHYSICS, Year 4 (elective)
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)
TIEKA INDUSTRIAL ENGINEERING AND MANAGEMENT, 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
TELTA ELECTRICAL ENGINEERING, Year 4 (elective)
TTFYA ENGINEERING PHYSICS, Year 4 (elective)
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)
TIEKA INDUSTRIAL ENGINEERING AND MANAGEMENT - Information Technology , Year 3 (compulsory)
TIEKA INDUSTRIAL ENGINEERING AND MANAGEMENT, 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.