VSFS:B_RD Relation Database - Course Information
B_RD Relation Database
University of Finance and AdministrationSummer 2015
- Extent and Intensity
- 1/1. 3 credit(s). Type of Completion: z (credit).
- Teacher(s)
- RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
- Guaranteed by
- RNDr. Jakub Lokoč, Ph.D.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Tamara Urbánková - Timetable of Seminar Groups
- B_RD/cAPH: each even Thursday 10:30–11:14 E303PC, each even Thursday 11:15–12:00 E303PC, J. Lokoč
B_RD/pAPH: each odd Thursday 10:30–11:14 E303PC, each odd Thursday 11:15–12:00 E303PC, J. Lokoč
B_RD/vAPH: Sat 28. 3. 9:45–11:15 E303PC, 11:30–13:00 E303PC, Fri 24. 4. 13:45–15:15 E303PC, J. Lokoč - Prerequisites
- B_UDS Introduction to Database Sys.
The requirement for the completion of this course is completion of the course B_UDS. - Course Enrolment Limitations
- The course is offered to students of any study field.
- Course objectives
- The goal is that at the end of the course the student practical knowledge and skills in the area of relational databases, as well as to get acquainted with new trends in object-relational and object databases. A substantial part is devoted to creating your own database project.
- Syllabus
- This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures: First Data Definition Language, Indexes Second integrity constraints Third Data manipulation language 4th Triggers, stored procedures 5th transaction 6th SQL and application programs, cursors 7th Rights and safety 8th IS architecture: three-tier, centralization / decentralization, replication, integration 9th data Warehousing 10th Advantages and shortcomings of the relational model, object-oriented approach 11th Object databases, Object-relational features of modern databases 12th Current trends and future vision. Summary practical approach to creating applications.
- Literature
- Povinná literatura
- Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
- http://nb.vse.cz/~palovska/uds/tskripta.zip
- Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
- Doporučená literatura
- Další zdroje
- Teaching methods
- Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is 75%, the controlled group consultations in 50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject
- Assessment methods
- Course completion: Credit is awarded on the basis of semester work: own database project (from conceptual design through SQL DDL code, one input / output form). The test is subject to a credit and is 50% based on the semester work and 50% to written test of the theory.
- Language of instruction
- Czech
- Further comments (probably available only in Czech)
- The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin KS/semestr.
- Enrolment Statistics (Summer 2015, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/summer2015/B_RD