Conceptual Modeling and Databases (5 cr)
Code: 5I00CI81-3001
General information
- Enrolment period
- 30.11.2015 - 10.01.2016
- Registration for the implementation has ended.
- Timing
- 01.01.2016 - 31.08.2016
- Implementation has ended.
- Credits
- 5 cr
- Local portion
- 5 cr
- Mode of delivery
- Contact learning
- Unit
- ICT Engineering
- Campus
- TAMK Main Campus
- Teaching languages
- Finnish
Objectives (course unit)
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.
Content (course unit)
- Conceptual modeling techniques
- ER-modeling
- Database design theories
- RDBMS and SQL
- Reverse and forward engineering
- Repositories and interfaces
Evaluation methods and criteria
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.
Teaching methods
contact teaching|exercises|assignments, practical work|demonstrations
Learning materials
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.
Content scheduling
* Introduction
* Conceptual modeling and UoD
* Database environment
* Relational model
* ER-modeling and database design
* CASE-tool: MySQLWorkbench
* SQL
* Database interfaces and web