PA036 Database System Project

Faculty of Informatics
Spring 2025
Extent and Intensity
0/2/0. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
In-person direct teaching
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Mgr. David Procházka (assistant)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics
Prerequisites
!(SEMESTR(1)||SEMESTR(2))||OBOR(SL)
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 80 student(s).
Current registration and enrolment status: enrolled: 0/80, only registered: 169/80, only registered with preference (fields directly associated with the programme): 165/80
fields of study / plans the course is directly associated with
there are 31 fields of study the course is directly associated with, display
Course objectives
The aim of the course is to analyze a given problem in the field of data processing, implement a solution to the problem, and run performance tests. The implementation requires the use of a contemporary database system, i.e. knowledge of SQL, and any programming language.
Learning outcomes
Upon completion of the course the student will be able to: - use a database storage system; - study and use advanced data processing techniques; - design and implement application performance tests.
Syllabus
  • A presentation of ideas in the tasks to be solved. Overview of approaches to optimizing SQL queries.
  • Assignment and solution of specific tasks - typically within two weeks per task.
  • Continuous evaluation during the solution period (approximately two times) with the possibility of getting extra points in the final solution ranking.
  • Corrections to solutions based on feedback after the submission deadline - typically within one week.
  • Consultation on assignments during class time.
  • Evaluation of all solutions (overall ranking) and announcement of the best ones.
Literature
    recommended literature
  • SMITH, Gregory. PostgreSQL 9.0 high performance : accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down. 1st pub. Birmingham: Packt Publishing, 2010, xiii, 442. ISBN 9781849510301. info
  • DOUGLAS, Korry and Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
Teaching methods
Introductory presentation of the concept of the course, synchronous consultations during seminars, and independent solving of assigned tasks.
Assessment methods
Credit will be awarded based on the successful completion of all assignments. Each assignment must be completed 100%. Assignments have interim checks before the due date and up to two corrections after the due date. Attendance at the opening and closing seminars.
Language of instruction
English
Further comments (probably available only in Czech)
The course is taught annually.
The course is taught: every week.
Information on course enrolment limitations: Prerekvizity jsou nastaveny jako preference pro studenty zapisující si předmět dle doporučeného průchodu. Ostatní mohou požádat o výjimku, která bude schválena v případě volné kapacity.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024.

PA036 Database System Project

Faculty of Informatics
Spring 2024
Extent and Intensity
0/2/0. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Mgr. David Procházka (assistant)
Jan Švestka (assistant)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics
Timetable
Mon 19. 2. to Thu 9. 5. Thu 12:00–13:50 D2
Prerequisites
!(SEMESTR(1)||SEMESTR(2))||OBOR(SL)
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 80 student(s).
Current registration and enrolment status: enrolled: 109/80, only registered: 2/80, only registered with preference (fields directly associated with the programme): 2/80
fields of study / plans the course is directly associated with
there are 50 fields of study the course is directly associated with, display
Course objectives
The aim of the course is to analyze a given problem in the field of data processing, implement a solution to the problem, and run performance tests. The implementation requires the use of a contemporary database system, i.e. knowledge of SQL, and any programming language.
Learning outcomes
Upon completion of the course the student will be able to: - use a database storage system; - study and use advanced data processing techniques; - design and implement application performance tests.
Syllabus
  • A presentation of ideas in the tasks to be solved. Overview of approaches to optimizing SQL queries.
  • Assignment and solution of specific tasks - typically within two weeks per task.
  • Continuous evaluation during the solution period (approximately two times) with the possibility of getting extra points in the final solution ranking.
  • Corrections to solutions based on feedback after the submission deadline - typically within one week.
  • Consultation on assignments during class time.
  • Evaluation of all solutions (overall ranking) and announcement of the best ones.
Literature
    recommended literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
  • SMITH, Gregory. PostgreSQL 9.0 high performance : accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down. 1st pub. Birmingham: Packt Publishing, 2010, xiii, 442. ISBN 9781849510301. info
  • DOUGLAS, Korry and Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
Teaching methods
Introductory presentation of the concept of the course, synchronous consultations during seminars, and independent solving of assigned tasks.
Assessment methods
Credit will be awarded based on the successful completion of all assignments. Each assignment must be completed 100%. Assignments have interim checks before the due date and up to two corrections after the due date. Attendance at the opening and closing seminars.
Language of instruction
Czech
Further comments (probably available only in Czech)
Study Materials
The course is taught annually.
Information on course enrolment limitations: Prerekvizity jsou nastaveny jako preference pro studenty zapisující si předmět dle doporučeného průchodu. Ostatní mohou požádat o výjimku, která bude schválena v případě volné kapacity.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2023
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Mgr. David Procházka (assistant)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics
Timetable
Tue 14. 2. to Tue 9. 5. Tue 12:00–13:50 A318
Prerequisites
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 16/40, only registered: 4/40, only registered with preference (fields directly associated with the programme): 4/40
fields of study / plans the course is directly associated with
there are 50 fields of study the course is directly associated with, display
Course objectives
The aim of the course is to analyze and create the assigned problem from the area of data processing, implement a solution to the problem and present results, typically performance results. The implementation assumes the use of a current database system, not excluding database installation in portable devices.
Learning outcomes
Upon completion of the course the student will be able to: - use a database storage system; - study and use advanced data processing techniques; - design and implement application performance tests; - document the test results and present them.
Syllabus
  • Presenting project topics, and creating a detailed assignment.
  • Planning and managing project implementation using the GANTT chart.
  • Project solution consultation.
  • Presentation of a project solution proposal.
  • Implementing the solution and consulting it.
  • Executing performance tests.
  • Presentation of the project implementation, achieved results, and evaluation of the work time schedule.
Literature
    recommended literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
  • SMITH, Gregory. PostgreSQL 9.0 high performance : accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down. 1st pub. Birmingham: Packt Publishing, 2010, xiii, 442. ISBN 9781849510301. info
  • DOUGLAS, Korry and Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
Teaching methods
Discussion at seminars, preparation of a team project including documentation, and presentation of project results.
Assessment methods
The credit will be awarded on the basis of the presentation of the project's intention at the seminar, the project's own realization, the submission of the project documentation and the presentation of the functional project at the seminar. Next, reviewing one project assignment of other students and participating in all presentations.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2022
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Bc. Daniel Plakinger (assistant)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics
Timetable
Thu 17. 2. to Thu 12. 5. Thu 12:00–13:50 A217; and Thu 7. 4. 16:00–19:50 A217
Prerequisites
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 6/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 50 fields of study the course is directly associated with, display
Course objectives
The aim of the course is to analyze and create the assigned problem from the area of data processing, implement a solution to the problem and present results, typically performance results. The implementation assumes the use of a current database system, not excluding database installation in portable devices.
Learning outcomes
Upon completion of the course the student will be able to: - use a database storage system; - study and use advanced data processing techniques; - design and implement application performance tests; - document the test results and present them.
Syllabus
  • Presenting project topics, creating a detailed assignment.
  • Planning and managing project implementation using the GANTT chart.
  • Project solution consultation.
  • Presentation of a project solution proposal.
  • Implementing the solution and consulting it.
  • Executing performance tests.
  • Presentation of the project implementation, results achieved and evaluation of the work time schedule.
Literature
    recommended literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
  • SMITH, Gregory. PostgreSQL 9.0 high performance : accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down. 1st pub. Birmingham: Packt Publishing, 2010, xiii, 442. ISBN 9781849510301. info
  • DOUGLAS, Korry and Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
Teaching methods
Discussion at seminars, preparation of a team project including documentation, and presentation of project results.
Assessment methods
The credit will be awarded on the basis of the presentation of the project's intention at the seminar, the project's own realization, the submission of the project documentation and the presentation of the functional project at the seminar. Next, reviewing one project assignment of other students and participating in all presentations.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2021
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Bc. Daniel Plakinger (assistant)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics
Timetable
Fri 10:00–11:50 Virtuální místnost
Prerequisites
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 48 fields of study the course is directly associated with, display
Course objectives
The aim of the course is to analyze and create the assigned problem from the area of data processing, implement a solution to the problem and present results, typically performance results. The implementation assumes the use of a current database system, not excluding database installation in portable devices.
Learning outcomes
Upon completion of the course the student will be able to: - use a database storage system; - study and use advanced data processing techniques; - design and implement application performance tests; - document the test results and present them.
Syllabus
  • Presenting project topics, creating a detailed assignment.
  • Planning and managing project implementation using the GANTT chart.
  • Project solution consultation.
  • Presentation of a project solution proposal.
  • Implementing the solution and consulting it.
  • Executing performance tests.
  • Presentation of the project implementation, results achieved and evaluation of the work time schedule.
Literature
    recommended literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
  • SMITH, Gregory. PostgreSQL 9.0 high performance : accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down. 1st pub. Birmingham: Packt Publishing, 2010, xiii, 442. ISBN 9781849510301. info
  • DOUGLAS, Korry and Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
Teaching methods
Discussion at seminars, preparation of a team project including documentation, and presentation of project results.
Assessment methods
The credit will be awarded on the basis of the presentation of the project's intention at the seminar, the project's own realization, the submission of the project documentation and the presentation of the functional project at the seminar. Next, reviewing one project assignment of other students and participating in all presentations.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2020
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Machine Learning and Data Processing – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics
Timetable
Mon 17. 2. to Thu 7. 5. Wed 14:00–15:50 A318; and Wed 13. 5. 14:00–15:50 B517
Prerequisites
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 48 fields of study the course is directly associated with, display
Course objectives
The aim of the course is to analyze and create the assigned problem from the area of data processing, implement a solution to the problem and present results, typically performance results. The implementation assumes the use of a current database system, not excluding database installation in portable devices.
Learning outcomes
Upon completion of the course the student will be able to: - use a database storage system; - study and use advanced data processing techniques; - design and implement application performance tests; - document the test results and present them.
Syllabus
  • Presenting project topics, creating a detailed assignment.
  • Planning and managing project implementation using the GANTT chart.
  • Project solution consultation.
  • Presentation of a project solution proposal.
  • Implementing the solution and consulting it.
  • Executing performance tests.
  • Presentation of the project implementation, results achieved and evaluation of the work time schedule.
Literature
    recommended literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
  • SMITH, Gregory. PostgreSQL 9.0 high performance : accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down. 1st pub. Birmingham: Packt Publishing, 2010, xiii, 442. ISBN 9781849510301. info
  • DOUGLAS, Korry and Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
Teaching methods
Discussion at seminars, preparation of a team project including documentation, and presentation of project results.
Assessment methods
The credit will be awarded on the basis of the presentation of the project's intention at the seminar, the project's own realization, the submission of the project documentation and the presentation of the functional project at the seminar. Next, reviewing one project assignment of other students and participating in all presentations.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2019
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Eva Hladká, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Tue 19. 2. to Tue 14. 5. Tue 18:00–19:50 A218
Prerequisites
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 19 fields of study the course is directly associated with, display
Course objectives
The aim of the course is to analyze and create the assigned problem from the area of data processing, implement a solution to the problem and present results, typically performance results. The implementation assumes the use of a current database system, not excluding database installation in portable devices.
Learning outcomes
Upon completion of the course the student will be able to: - use a database storage system; - study and use advanced data processing techniques; - design and implement application performance tests; - document the test results and present them.
Syllabus
  • Presenting project topics, creating a detailed assignment.
  • Planning and managing project implementation using the GANTT chart.
  • Project solution consultation.
  • Presentation of a project solution proposal.
  • Implementing the solution and consulting it.
  • Executing performance tests.
  • Presentation of the project implementation, results achieved and evaluation of the work time schedule.
Literature
    recommended literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
  • SMITH, Gregory. PostgreSQL 9.0 high performance : accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down. 1st pub. Birmingham: Packt Publishing, 2010, xiii, 442. ISBN 9781849510301. info
  • DOUGLAS, Korry and Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
Teaching methods
Discussion at seminars, preparation of a team project including documentation, and presentation of project results.
Assessment methods
The credit will be awarded on the basis of the presentation of the project's intention at the seminar, the project's own realization, the submission of the project documentation and the presentation of the functional project at the seminar. Next, reviewing one project assignment of other students and participating in all presentations.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2018
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Eva Hladká, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Mon 14:00–15:50 A217
Prerequisites
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 19 fields of study the course is directly associated with, display
Course objectives
The aim of the course is to analyze and create the assigned problem from the area of data processing, implement a solution to the problem and present results, typically performance results. The implementation assumes the use of a current database system, not excluding database installation in portable devices.
Learning outcomes
Upon completion of the course the student will be able to: - use a database storage system; - study and use advanced data processing techniques; - design and implement application performance tests; - document the test results and present them.
Syllabus
  • Presenting project topics, creating a detailed assignment.
  • Planning and managing project implementation using the GANTT chart.
  • Project solution consultation.
  • Presentation of a project solution proposal.
  • Implementing the solution and consulting it.
  • Executing performance tests.
  • Presentation of the project implementation, results achieved and evaluation of the work time schedule.
Literature
    recommended literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
  • SMITH, Gregory. PostgreSQL 9.0 high performance : accelerate your PostgreSQL system and avoid the common pitfalls that can slow it down. 1st pub. Birmingham: Packt Publishing, 2010, xiii, 442. ISBN 9781849510301. info
  • DOUGLAS, Korry and Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
Teaching methods
Discussion at seminars, preparation of a team project including documentation, and presentation of project results.
Assessment methods
The credit will be awarded on the basis of the presentation of the project's intention at the seminar, the project's own realization, the submission of the project documentation and the presentation of the functional project at the seminar. Next, reviewing one project assignment of other students and participating in all presentations.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2017
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Eva Hladká, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Wed 12:00–13:50 A218
Prerequisites
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 19 fields of study the course is directly associated with, display
Course objectives
At the end of the course students will be able to create a working application in a relational database system. Next they will be able to write technical documentations. Presentations skills will also be trained.
Syllabus
  • The goal is to create a working application based on a relational database system and its technical documentation, and to present it.
  • The documentation consists of: project plans, logical data model, physical data model, application's functions description, user manual, source code;
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
Teaching methods
class discussion, database project including documentation
Assessment methods
Credit will be awarded based on the oral presentation of the project objectives within a seminar, project's implementation, submission of project documentation and the final oral presentation of project's implementation within a seminar. Next, the student has to review one data model by his or her colleague and be present at his or her both oral presentations.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2016
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Eva Hladká, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Mon 12:00–13:50 A320
Prerequisites
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 19 fields of study the course is directly associated with, display
Course objectives
At the end of the course students will be able to create a working application in a relational database system. Next they will be able to write technical documentations. Presentations skills will also be trained.
Syllabus
  • The goal is to create a working application based on a relational database system and its technical documentation, and to present it.
  • The documentation consists of: project plans, logical data model, physical data model, application's functions description, user manual, source code;
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
Teaching methods
class discussion, database project including documentation
Assessment methods
Credit will be awarded based on the oral presentation of the project objectives within a seminar, project's implementation, submission of project documentation and the final oral presentation of project's implementation within a seminar. Next, the student has to review one data model by his or her colleague and be present at his or her both oral presentations.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2015
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Eva Hladká, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Thu 12:00–13:50 A318
Prerequisites
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 18 fields of study the course is directly associated with, display
Course objectives
At the end of the course students will be able to create a working application in a relational database system. Next they will be able to write technical documentations. Presentations skills will also be trained.
Syllabus
  • The goal is to create a working application based on a relational database system and its technical documentation, and to present it.
  • The documentation consists of: project plans, logical data model, physical data model, application's functions description, user manual, source code;
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
Teaching methods
class discussion, database project including documentation
Assessment methods
Credit will be awarded based on the oral presentation of the project objectives within a seminar, project's implementation, submission of project documentation and the final oral presentation of project's implementation within a seminar. Next, the student has to review one data model by his or her colleague and be present at his or her both oral presentations.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2014
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Mon 8:00–9:50 G125
Prerequisites
Knowledge of database systems, data modeling and software engineering is expected and positive attitude to programming
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 18 fields of study the course is directly associated with, display
Course objectives
At the end of the course students will be able to create a working application in a relational database system. Next they will be able to write technical documentations. Presentations skills will also be trained.
Syllabus
  • The goal is to create a working application based on a relational database system and its technical documentation, and to present it.
  • The documentation consists of: project plans, logical data model, physical data model, application's functions description, user manual, source code;
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
Teaching methods
class discussion, database project including documentation
Assessment methods
Credit will be awarded based on the oral presentation of the project objectives within a seminar, project's implementation, submission of project documentation and the final oral presentation of project's implementation within a seminar. Next, the student has to review one data model by his or her colleague and be present at his or her both oral presentations.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2013
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: doc. RNDr. Vlastislav Dohnal, Ph.D.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Tue 12:00–13:50 C511
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 18 fields of study the course is directly associated with, display
Course objectives
At the end of the course students will be able to create a working application in a relational database system. Next they will be able to write technical documentations. Presentations skills will also be trained.
Syllabus
  • The goal is to create a working application based on a relational database system and its technical documentation, and to present it.
  • The documentation consists of: project plans, logical data model, physical data model, application's functions description, user manual, source code;
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
Teaching methods
class discussion, database project including documentation
Assessment methods
group projects, class discussion; credit is based on the data model presentation, documentation and functional project.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2012
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
RNDr. Marek Kumpošt, Ph.D. (lecturer)
Guaranteed by
prof. RNDr. Luděk Matyska, CSc.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Tue 18:00–19:50 B204
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 23 fields of study the course is directly associated with, display
Course objectives
At the end of the course students will be able to create a working application in Oracle. Next they will be able to write technical documentations. Presentations skills will also be trained.
Syllabus
  • The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
  • The documentation consists of: project plans , logical data model, physical data model, application's functions description, user manual, source code
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
Teaching methods
class discussion, database project including documentation
Assessment methods
group projects, class discussion; credit is based on the data model presentation, documentation and functional project.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2011
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
RNDr. Marek Kumpošt, Ph.D. (lecturer)
Guaranteed by
prof. RNDr. Václav Matyáš, M.Sc., Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D.
Timetable
Mon 8:00–9:50 B411
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 22 fields of study the course is directly associated with, display
Course objectives
At the end of the course students will be able to create a working application in Oracle. Next they will be able to write technical documentations. Presentations skills will also be trained.
Syllabus
  • The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
  • The documentation consists of: project plans , logical data model, physical data model, application's functions description, user manual, source code
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
Teaching methods
class discussion, database project including documentation
Assessment methods
group projects, class discussion; credit is based on the data model presentation, documentation and functional project.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2010
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
RNDr. Marek Kumpošt, Ph.D. (lecturer)
Guaranteed by
prof. RNDr. Václav Matyáš, M.Sc., Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D.
Timetable
Mon 14:00–15:50 B410
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 22 fields of study the course is directly associated with, display
Course objectives
At the end of the course students will be able to create a working application in Oracle. Next they will be able to write technical documentations. Presentations skills will also be trained.
Syllabus
  • The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
  • The documentation consists of: project plans , logical data model, physical data model, application's functions description, user manual, source code
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
Teaching methods
class discussion, database project including documentation
Assessment methods
group projects, class discussion; credit is based on the data model presentation, documentation and functional project.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2009
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
Guaranteed by
prof. RNDr. Václav Matyáš, M.Sc., Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D.
Timetable
Wed 8:00–9:50 B204
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 19 fields of study the course is directly associated with, display
Course objectives
The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
Syllabus
  • The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
  • The documentation consists of: project plans , logical data model, physical data model, application's functions description, user manual, source code
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Literature
  • Řízení projektů. Edited by Milton D. Rosenau. Vyd. 1. Praha: Computer Press, 2000, xiv, 344. ISBN 8072262181. info
  • SVOZILOVÁ, Alena. Projektový management. 1. vyd. Praha: Grada, 2006, 353 s. ISBN 8024715015. info
Assessment methods
group projects, class discussion; credit is based on the data model presentation, documentation and functional project.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2008
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
Guaranteed by
prof. RNDr. Václav Matyáš, M.Sc., Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D.
Timetable
Mon 12:00–13:50 B410
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 19 fields of study the course is directly associated with, display
Course objectives
The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
Syllabus
  • The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
  • The documentation consists of: project plans , logical data model, physical data model, application's functions description, user manual, source code
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Assessment methods (in Czech)
Zápočet bude udělen na základě prezentace projektu na semináři, odevzdání dokumentace a prezentace funkčního projektu.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2007
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
Guaranteed by
prof. RNDr. Václav Matyáš, M.Sc., Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D.
Timetable
Mon 12:00–13:50 B204
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 7 fields of study the course is directly associated with, display
Course objectives
The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
Syllabus
  • The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
  • The documentation consists of: project plans , logical data model, physical data model, application's functions description, user manual, source code
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Assessment methods (in Czech)
Zápočet bude udělen na základě prezentace projektu na semináři, odevzdání dokumentace a prezentace funkčního projektu.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2006, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2006
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
RNDr. Zdenko Staníček, Ph.D. (lecturer)
Guaranteed by
prof. RNDr. Václav Matyáš, M.Sc., Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D.
Timetable
Mon 11:00–12:50 B204
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40, only registered with preference (fields directly associated with the programme): 0/40
fields of study / plans the course is directly associated with
there are 7 fields of study the course is directly associated with, display
Syllabus
  • The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
  • The documentation consists of: project plans , logical data model, physical data model, application's functions description, user manual, source code
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Assessment methods (in Czech)
Zápočet bude udělen na základě prezentace projektu na semináři, odevzdání dokumentace a prezentace funkčního projektu.
Language of instruction
Czech
Further Comments
The course is taught annually.
Teacher's information
http://www.math.muni.cz/~zriha/vyuka/pa036/
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2005, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2005
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
RNDr. Zdenko Staníček, Ph.D. (lecturer)
Guaranteed by
doc. Ing. Jan Staudek, CSc.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D.
Timetable
Tue 12:00–13:50 B204
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.

The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40
fields of study / plans the course is directly associated with
there are 7 fields of study the course is directly associated with, display
Syllabus
  • The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
  • The documentation consists of: project plans , logical data model, physical data model, application's functions description, user manual, source code
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Assessment methods (in Czech)
Zápočet bude udělen na základě prezentace projektu na semináři, odevzdání dokumentace a prezentace funkčního projektu.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2004, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2004
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
RNDr. Zdenko Staníček, Ph.D. (lecturer)
Guaranteed by
doc. Ing. Jan Staudek, CSc.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D.
Timetable
Thu 16:00–17:50 B011
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.

The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40
fields of study / plans the course is directly associated with
there are 6 fields of study the course is directly associated with, display
Syllabus
  • The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
  • The documentation consists of: project plans , logical data model, physical data model, application's functions description, user manual, source code
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Assessment methods (in Czech)
Zápočet bude udělen na základě prezentace projektu na semináři, odevzdání dokumentace a prezentace funkčního projektu.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 2003, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.

PA036 Database System Project

Faculty of Informatics
Spring 2003
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D. (lecturer)
RNDr. Zdenko Staníček, Ph.D. (lecturer)
Guaranteed by
doc. Ing. Jan Staudek, CSc.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: Ing. Mgr. et Mgr. Zdeněk Říha, Ph.D.
Timetable
Fri 8:00–9:50 B011
Prerequisites
Knowledge of database systems, data modelling and software engineering is expected.
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.

The capacity limit for the course is 40 student(s).
Current registration and enrolment status: enrolled: 0/40, only registered: 0/40
fields of study / plans the course is directly associated with
there are 6 fields of study the course is directly associated with, display
Syllabus
  • The goal is to create a working application based on a relational database system (Oracle), the technical documentation and to present the results.
  • The documentation consists of: project plans , logical data model, physical data model, application's functions description, user manual, source code
  • The data model will be presented and discussed in the class. Presentation of the working application with some testing data is required.
Assessment methods (in Czech)
Zápočet bude udělen na základě prezentace projektu na semináři, odevzdání dokumentace a prezentace funkčního projektu.
Language of instruction
Czech
Further Comments
The course is taught annually.
The course is also listed under the following terms Spring 2004, Spring 2005, Spring 2006, Spring 2007, Spring 2008, Spring 2009, Spring 2010, Spring 2011, Spring 2012, Spring 2013, Spring 2014, Spring 2015, Spring 2016, Spring 2017, Spring 2018, Spring 2019, Spring 2020, Spring 2021, Spring 2022, Spring 2023, Spring 2024, Spring 2025.
  • Enrolment Statistics (recent)