|
Lecturer(s)
|
-
Procházka Libor, Ing. Ph.D.
|
|
Course content
|
DBMS, requirements and properties. Conceptual data model. Entity-Relationship and Entity-Relationship-Attribute Modeling. Problems with ER models. The relational data model, relational algebra. Terms relation, entity, file and table. Functional dependency of attributes, normalization. Basics of the SQL, data definition and data manipulation. Embedded SQL, ODBC.Integrity constraints in SQL. Triggers, Access rights and authority in SQL. Transaction management, journaling, and consistent state of the database. Concurrency control of the transaction, locking methods and timestamping methods.
|
|
Learning activities and teaching methods
|
Lecture with practical applications, Discussion, One-to-One tutorial, Individual study, Lecture, Practicum
- Preparation for formative assessments (2-20)
- 10 hours per semester
- Preparation for an examination (30-60)
- 40 hours per semester
- Undergraduate study programme term essay (20-40)
- 40 hours per semester
- Contact hours
- 65 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| to apply basic knowledge of imperative programming |
| to apply basic knowledge of operating systems |
| Skills |
|---|
| actively program in an imperative programming language |
| appropriately select basic data structures |
| Competences |
|---|
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| to design an E-R-A model of a simple real situation |
| to be familiar with data modeling using E-R-A graphical notation |
| to know the issues of transaction processing and the principles of parallel transactions |
| Skills |
|---|
| to design an E-R-A model of a real situation |
| to implement a database in a selected DBMS |
| to write SQL statements |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecture |
| Practicum |
| Individual study |
| One-to-One tutorial |
| Interactive lecture |
| Discussion |
| assessment methods |
|---|
| Combined exam |
| Test |
| Seminar work |
| Individual presentation at a seminar |
|
Recommended literature
|
-
CONNOLLY, Thomas; BEGG, Carolyn; HOLOWCZAK, Richard. Database Systems: A Practical Approach to Design, Implementation and Management. Pearson, 2014. ISBN 978-1-292-06118-4.
-
CHOPRA Rajiv. Database Management System (DBMS): A Practical Approach. S. Chand Publishing, 2016. ISBN 978-93-856-7634-5.
-
PANNEERSELVAM, R. Database Management Systems. PHI Learning, 2018. ISBN 978-93-874-7210-5.
-
TALE, Steve. SQL: The Ultimate Beginners Guide: Learn SQL Today. 2016. ISBN 978-15-336-0456-9.
|