DSP201 Database Management Systems

Code DSP201
Name Database Management Systems
Status Compulsory/Courses of Limited Choice
Level and type Undergraduate Studies, Academic
Field of study Computer Science
Faculty
Academic staff Jānis Eiduks, Viktorija Vinogradova, Andrejs Grigorjevs, Ainārs Auziņš, Pēteris Rudzājs, Oļegs Verhodubs
Credit points 4.0 (6.0 ECTS)
Parts 1
Annotation Concepts of database (DB) technology. DB management systems (DBMS) and their functionality. DBMS types. Possibilities and restrictions of relation DB. DB data definition languages. Query languages SQL and QbE. Application design in DB systems. Tools of programming automatization. DBMS programming languages. Data exchange standards. Main principles of DB design..
Goals and objectives
of the course in terms
of competences and skills
Students are able to design and implement a relational data base. Students are able to retrieve data from relational data base using SQL. Students are able to implement data base application using data access technologies.
Learning outcomes
and assessment
Students are able to design and implement a relational data base. Students are able to define the data base constraints - Task „Data base implementation” / Exam
Students are able to retrieve data from the relational data base using SQL. - Task „Data retrieval” / Exam
Students are familiar with reporting tools and are able to design report according to the user needs - Task „Data base reporting” / Exam
Students are able to implement the data base application using data access technologies and automatic tools. - Task „Data base application” / Exam
Students are able to implement the data warehouse for the existing data base - Task „Data warehouse” / Exam
Course prerequisites Discrete Structures of Computer Science

[Extended course information PDF]