Conceptual Modeling and Databases (5 op)

Osaamistavoitteet (Opintojakso)

After completing the course, the student recognizes
and analyzes human concepts and theories and knows how to
produce conceptual models based on them. The
student knows how to design databases based on
the conceptual model. The student learns also how to use the database as a repository through an interface.

Sisältö (Opintojakso)

- Conceptual modeling techniques
- ER-modeling
- Database design theories
- RDBMS and SQL
- Reverse and forward engineering
- Repositories and interfaces

Arviointimenetelmät ja arvioinnin perusteet

The course is evaluated based on a practical work (0-5) and exercises (0-1). The grade is the sum of these two, but the practical work is mandatory.
85 % gives number 1 in exercise activity. The evaluation of the practical work will be published later.

Opiskelumuodot ja opetusmenetelmät

contact teaching|exercises|assignments, practical work|demonstrations

Oppimateriaalit

The course book: Fundamentals of Database Systems (Elmasri & Navathe, 5th edition or newer).
Database Systems: A Practical Approach to Design, Implementation and Management, 5/E
Also some material in Tabula.

Sisällön jaksotus

* Introduction
* Conceptual modeling and UoD
* Database environment
* Relational model
* ER-modeling and database design
* CASE-tool: MySQLWorkbench
* SQL
* Database interfaces and web