Syllabus for |
|
| TDA356 - Databases |
| |
| Owner: TITEA |
|
|
5,0 Credits (ECTS 7,5) |
| Grading: TH - Five, Four, Three, Not passed |
| Level: B |
|
Department: 37 - COMPUTER SCIENCE AND ENGINEERING
|
Course round 1
Teaching language: English
| Course module |
|
Credit distribution |
|
Examination dates |
|
Sp1 |
Sp2 |
Sp3 |
Sp4 |
|
No Sp |
| 0105 |
Examination |
5,0 c |
Grading: TH |
|
|
5,0 c
|
|
|
|
|
|
13 Dec 2005 pm M, |
21 Apr 2006 am V, |
01 Sep 2006 am V |
| 0205 |
Laboratory |
0,0 c |
Grading: UG |
|
|
0,0 c
|
|
|
|
|
|
|
In programs
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)
TDATA COMPUTER SCIENCE AND ENGINEERING, Year 3 (elective)
TELTA ELECTRICAL ENGINEERING, Year 4 (elective)
TIEKA INDUSTRIAL ENGINEERING AND MANAGEMENT, Year 4 (elective)
TITEA SOFTWARE ENGINEERING, Year 2 (elective)
TTFYA ENGINEERING PHYSICS, Year 4 (elective)
Examiner:
Forskarassistent Marcin Benke
Course round 2
Teaching language: Swedish
| Course module |
|
Credit distribution |
|
Examination dates |
|
Sp1 |
Sp2 |
Sp3 |
Sp4 |
|
No Sp |
| 0105 |
Examination |
5,0 c |
Grading: TH |
|
|
|
|
5,0 c
|
|
|
|
22 May 2006 pm V |
| 0205 |
Laboratory |
0,0 c |
Grading: UG |
|
|
|
|
0,0 c
|
|
|
|
|
In programs
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)
TDATA COMPUTER SCIENCE AND ENGINEERING, Year 3 (elective)
TELTA ELECTRICAL ENGINEERING, Year 4 (elective)
TIEKA INDUSTRIAL ENGINEERING AND MANAGEMENT, Year 4 (elective)
TIEKA INDUSTRIAL ENGINEERING AND MANAGEMENT - Information Technology , Year 3 (compulsory)
TITEA SOFTWARE ENGINEERING, Year 2 (elective)
BIMAS MSc PROGRAMME IN BIOINFORMATICS, Year 1 (elective)
Examiner:
Forskarassistent Marcin Benke
Replaces
TDA355
Data bases
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.
Goal
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, particularly as seen by users, application programmers and database administrators. Laboratory exercises develop these topics. Apart from paper exercises, they also 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.
Other topics are covered only theoretically: storage and search techniques, query optimisation and transaction management. Thus the course will not give the student any practice in implementing a database management system, but will give an understanding of what facilities are usually offered, and what difficulties arise in providing them.
The course is thus a typical first course in database systems, and occupies a traditional place in the curriculum.
Organisation
Laboratories
0. SQL querying/modifying existing database
1. Designing a database
2. Implementing the above database
3. Putting this database on the WWW with various front ends
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.