Course title in Estonian
Course title in English
Design and Development of Databases
approximate amount of contact lessons
lecturer of 2019/2020 Spring semester
õppejõud on määramata
lecturer of 2020/2021 Autumn semester
lecturer not assigned
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.
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.
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.
A = 90% -100%
B = 80% - 89%
C = 70% - 79%
D = 60% - 69%
E = 50% - 59%
F = 0% - 49%
The course is a prerequisite
Andmebaaside projekteerimine, Erki Eessaar. TTÜ 2008
Asenduskirjanduse põhjal läbimine on võimalik eraldi kokkuleppel õppejõuga.