Sivut:
|
|
Topics
This course is intended as a first year course in Computer Science.
It assumes basic knowledge on programming (in Java), WWW and HTML.
The 'Database design' part of the course assumes knowledge
about UML class diagrams (taught in the course
Introduction to Appication Analysis and Design).
The course covers the foundationss of relational databases: structure and use
of the database, SQL database language and principles of programming
database applications (in Java). The following list of topics lists also textbook
material that may be used in addition to the lectures and e-learning material.
Two alternatives are given. The textbook Ramakrishnan & Gehrke is the current text
book of the course Database Management thus if you are considering to continue your database studies,
you might consider buying this book. Elmasri & Navathe was the previuos text book of
Database Management, and is still valid. It might be easier to get in the student library.
The current edition of Elmasri & Navathe is 4th (since September 2003), but the chapters
below are the chapters of the 3rd edition.
- What is a database
Elmasri&Navathe: Ch 1
Ramakrishnan & Gehrke: Ch 1
- Data models
Elmasri&Navathe: Ch 2.1, pages
23-27
Ramakrishnan & Gehrke: Ch 1.5, 2.1
- Database system
Elmasri&Navathe: Ch 2.2 -2.6, pages 27-39
Ramakrishnan & Gehrke: Ch 1
- The relational model of data
- domain
- relation
- key
- foreign key
- referential integriy
Elmasri&Navathe: Ch 7.1-7.2, pages 195-208
Ramakrishnan & Gehrke: Ch 3.1-3.3
- Relational algebra
Elmasri&Navathe: Ch 7.4, pages 211-224 (division
excluded), 7.5.3, 7.6, 7.7 pages 228-235
Ramakrishnan & Gehrke: Ch 2, 4.1-4.2
- Introduction to database design
Elmasri&Navathe: Ch 14.1
Ramakrishnan & Gehrke: Ch 2, 19.1-19.4.1,19.6.1
- SQL
- SQL data definition
Elmasri&Navath: Ch 8.1 pages 243-251
Ramakrishnan & Gehrke: Ch 3.1.1-3.3.1
- SQL queries, the basics
Elmasri&Navathe: Ch 8.2, pages
251-261
- Ramakrishnan & Gehrke: Ch 5.1-5.2, 5.6
- SQL queries, additional features
Elmasri&Navathe: Ch 8.3, pages 261-275.
Ramakrishnan & Gehrke: Ch 5.3-5.4
- Yhteenvetokyselyt
Elmasri & Navathe: Ch 8.4
Ramakrishnan & Gehrke: Ch 5.5
- SQL views
Ramakrishnan & Gehrke: Ch 3.6.
- SQL data manipulation
Elmasri&Navathe: Ch 8.4-8.5, pages
275-282
Ramakrishnan & Gehrke: Ch 3.3.1
- Database applications
- Concepts
- Java database programming - JDBC
Harri Laine: Database programming
- WWW- database applications
Elmasri&Navathe: Ch 27.1
Ramakrishnan & Gehrke: Ch 6.1-6.4, 7.5,7.6 ja 7.7 (only the main principles) .
SQL practicing is carried out with the automated SQLTrainer practice environment.
|