Design and Development of Databases
Course code
IFI6013.DT
old course code
IFI6013
Course title in Estonian
Andmebaaside projekteerimine
Course title in English
Design and Development of Databases
ECTS credits
3.0
approximate amount of contact lessons
42
Teaching semester
autumn
Assessment form
Examination
lecturer of 2019/2020  Autumn semester
Inga Petuhhov (eesti keel) tavaline kursus
lecturer of 2019/2020  Spring semester
lecturer not assigned
Course aims
The objective of the course is to give general theoretical knowledge about database management systems and databases. Also this course gives theoretical knowledge and practical skills for designing, implementing and managing databases.
Brief description of the course
Overview of a Database Management System. Structure of database, data models. The Entity-Relationship Data Model. The Relational Data Model. The Database Language SQL. Normalization. Concurrency, transactions, security.
Independent work
The aim of the work is data model sketching and documenting on a selected subject of the work. All independent assignments must be done so that the result is positive. More information on course webpage.
Learning outcomes in the course
Knows the construction principles of realtional database models. Can create ER-datamodels and use it for the logical design of a database. Knows the problems regarding database security. Knows how to use SQL for making enquiries from the database.

Assessment methods
Studies end with exams. To get a permission for the exam one must have submitted and defended all independent tasks. Pass tests and the seminar.

Grading scale:
A = 90% -100%
B = 80% - 89%
C = 70% - 79%
D = 60% - 69%
E = 50% - 59%
F = 0% - 49%
Teacher
Inga Petuhhov
The course is a prerequisite
Study literature
Andmebaaside projekteerimine, Erki Eessaar. TTÜ 2008
Replacement literature
Asenduskirjanduse põhjal läbimine on võimalik eraldi kokkuleppel õppejõuga.