Syllabus for |
|
| TDA357 - Databases |
| |
| Owner: TKITE |
|
|
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 |
| 0106 |
Examination |
3,0 c |
Grading: TH |
|
|
3,0 c
|
|
|
|
|
|
18 Dec 2006 pm V, |
31 Aug 2007 am V |
| 0206 |
Laboratory |
2,0 c |
Grading: UG |
|
|
2,0 c
|
|
|
|
|
|
|
In programs
TAUTA AUTOMATION AND MECHATRONICS ENGENEERING, Year 4 (elective)
TKDAT COMPUTER SCIENCE AND ENGINEERING, Year 3 (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)
TIDAL COMPUTER ENGINEERING - Software Engineering, Year 3 (compulsory)
TITEA SOFTWARE ENGINEERING, Year 3 (elective)
Examiner:
Docent
Rogardt Heldal
Course round 2
Teaching language: English
| Course module |
|
Credit distribution |
|
Examination dates |
|
Sp1 |
Sp2 |
Sp3 |
Sp4 |
|
No Sp |
| 0106 |
Examination |
3,0 c |
Grading: TH |
|
|
|
|
3,0 c
|
|
|
|
28 May 2007 pm M, |
13 Apr 2007 am V, |
31 Aug 2007 am V |
| 0206 |
Laboratory |
2,0 c |
Grading: UG |
|
|
|
|
2,0 c
|
|
|
|
|
In programs
TAUTA AUTOMATION AND MECHATRONICS ENGENEERING, Year 4 (elective)
TKITE SOFTWARE ENGINEERING, Year 2
TKDAT COMPUTER SCIENCE AND ENGINEERING, Year 3 (elective)
TDATA COMPUTER SCIENCE AND ENGINEERING, Year 3 (elective)
TDATA COMPUTER SCIENCE AND ENGINEERING - Interactive simulations and games, Year 4 (elective)
TDATA COMPUTER SCIENCE AND ENGINEERING - Engineering of Computer-Based Systems, Year 4 (elective)
TELTA ELECTRICAL ENGINEERING, Year 4 (elective)
TITEA SOFTWARE ENGINEERING, Year 3 (elective)
Examiner:
Docent
Rogardt Heldal
Replaces
TDA355
Data bases TDA356
Databases
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 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.