Kursplan för |
|
TDA357 - Databaser
|
Databases |
|
Kursplanen fastställd 2014-02-25 av programansvarig (eller motsvarande) |
Ägare: TKITE |
|
7,5 Högskolepoäng
|
Betygskala: TH - Fem, Fyra, Tre, Underkänd |
Utbildningsnivå: Grundnivå |
Huvudområde: Datateknik, Informationsteknik
|
Institution: 37 - DATA- OCH INFORMATIONSTEKNIK
|
Kurstillfälle 1
Undervisningsspråk: Engelska
Sökbar för utbytesstudenter: Ja
Blockschema:
D+
Max antal deltagare: 150
Modul |
|
Poängfördelning |
|
Tentamensdatum |
Lp1 |
Lp2 |
Lp3 |
Lp4 |
Sommarkurs |
Ej Lp |
0106 |
Tentamen |
4,5 hp |
Betygskala: TH |
|
|
4,5 hp
|
|
|
|
|
|
16 Jan 2019 em M
|
10 Jun 2019 em SB
|
29 Aug 2019 em SB_MU
|
0206 |
Laboration |
3,0 hp |
Betygskala: UG |
|
|
3,0 hp
|
|
|
|
|
|
|
I program
TIDAL DATATEKNIK, HÖGSKOLEINGENJÖR, Årskurs 2 (obligatorisk)
MPIDE INTERAKTIONSDESIGN, MASTERPROGRAM, Årskurs 2 (valbar)
TKIEK INDUSTRIELL EKONOMI, CIVILINGENJÖR - Informationsteknik, Årskurs 3 (obligatorisk)
TKITE INFORMATIONSTEKNIK, CIVILINGENJÖR, Årskurs 3 (valbar)
TKITE INFORMATIONSTEKNIK, CIVILINGENJÖR, Årskurs 2 (valbar)
MPBME MEDICINSK TEKNIK, MASTERPROGRAM, Årskurs 2 (valbar)
Examinator:
Jonas Duregård
Gå till kurshemsida
Kurstillfälle 2
Undervisningsspråk: Engelska
Sökbar för utbytesstudenter: Ja
Max antal deltagare: 90
Modul |
|
Poängfördelning |
|
Tentamensdatum |
Lp1 |
Lp2 |
Lp3 |
Lp4 |
Sommarkurs |
Ej Lp |
0106 |
Tentamen |
4,5 hp |
Betygskala: TH |
|
|
|
4,5 hp
|
|
|
|
|
22 Mar 2019 fm SB
|
10 Jun 2019 em SB_MU
|
29 Aug 2019 em SB_MU
|
0206 |
Laboration |
3,0 hp |
Betygskala: UG |
|
|
|
3,0 hp
|
|
|
|
|
|
I program
TKTEM TEKNISK MATEMATIK, CIVILINGENJÖR, Årskurs 3 (obligatoriskt valbar)
TKITE INFORMATIONSTEKNIK, CIVILINGENJÖR, Årskurs 3 (valbar)
TKITE INFORMATIONSTEKNIK, CIVILINGENJÖR, Årskurs 2 (valbar)
MPBME MEDICINSK TEKNIK, MASTERPROGRAM, Årskurs 1 (obligatoriskt valbar)
TKDAT DATATEKNIK, CIVILINGENJÖR, Årskurs 3 (valbar)
Examinator:
Aarne Ranta
Gå till kurshemsida
Ersätter
TDA355
Databaser TDA356
Databaser
Behörighet:
För kurser på grundnivå inom Chalmers utbildningsprogram gäller samma behörighetskrav som till de(t) program där kursen ingår i programplanen.
Kursspecifika förkunskaper
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.
Syfte
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.
Lärandemål (efter fullgjord kurs ska studenten kunna)
Knowledge and understanding
1. Discuss and use features of different data models: the entity-relationship model, the relational model and the semi-structured model.
2. Apply design theory for relational databases.
3. Describe the effect of indexes and transactions in a relational database.
4. Describe how access can be controlled via user authorisation.
Skills and abilities
1. Implement a database design using a data definition language.
2. Query and modify data using a data manipulation language.
3. Express queries in relational algebra.
4. Implement a database application in a host language.
Judgement and approach
1. Construct an entity-relationship diagram for a given domain.
2. Design and implement a database application that meets given requirements.
Innehåll
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
Litteratur
Information about literature will be given on the course home-page before the start of the course.
Examination inklusive obligatoriska moment
Written examination and compulsory programming assignments.