|
Lecturer(s)
|
-
Rychlík Jan, Ing.
-
Dostal Martin, Ing. Ph.D.
-
Zíma Martin, Ing. Ph.D.
-
Prantl Martin, Ing. Ph.D.
|
|
Course content
|
1. DBMS, requirements for the DBMS and its properties. 2. Conceptual data model, Entity-Relationship Modeling . 3. Problems wits ER models, fan trap. 4. Loops in ER models, chasm trap, generalizace a specializace in ER models. 5. The relational data model, relational algebra. 6. Basic of language SQL, data definition and data manipulation. 7. Integrity constraints in SQL, access right and authority in SQL. 8. Network data model. 9. Functional dependency of attributes, Armstrong's axioms. 10. Basic normal forms. 11. Advanced normal forms, multivalued dependency. 12. Transaction management, journaling, consistent state of DB. 13. Concurrency control of 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 an examination (30-60)
- 40 hours per semester
- Preparation for formative assessments (2-20)
- 10 hours per semester
- Undergraduate study programme term essay (20-40)
- 40 hours per semester
- Contact hours
- 65 hours per semester
|
| prerequisite |
|---|
| Knowledge |
|---|
| apply basic knowledge of imperative programming |
| apply basic knowledge of operating systems |
| Skills |
|---|
| actively program in the imperative programming language |
| choose the basic data structures appropriately |
| Competences |
|---|
| N/A |
| learning outcomes |
|---|
| Knowledge |
|---|
| know the issues of transaction processing and the principles of parallel running of transactions |
| to design an entity-relationship model of a simple real situation |
| be familiar with data modeling with usage the entity-relational graphical notation |
| Skills |
|---|
| write simple SQL statements |
| create a simple database application |
| implement the entity relationship model of a simple real situation in the selected DBMS |
| Competences |
|---|
| N/A |
| teaching methods |
|---|
| Knowledge |
|---|
| Lecture |
| Practicum |
| Individual study |
| One-to-One tutorial |
| Interactive lecture |
| Discussion |
| Skills |
|---|
| Practicum |
| Task-based study method |
| Skills demonstration |
| Discussion |
| Competences |
|---|
| Interactive lecture |
| assessment methods |
|---|
| Knowledge |
|---|
| Combined exam |
| Test |
| Seminar work |
| Individual presentation at a seminar |
| Skills |
|---|
| Written exam |
| Skills demonstration during practicum |
| Individual presentation at a seminar |
| Competences |
|---|
| Combined exam |
| Seminar work |
| Continuous assessment |
|
Recommended literature
|
-
Connolly, Thomas M.; Begg, Carolyn E. Database systems : a practical approach to design, implementation, and management. 3rd ed. Harlow : Addison-Wesley, 2002. ISBN 0-201-70857-4.
-
Connolly, Thomas M., Begg, Carolyn E. Database systems : a practical approach to design, implementation, and management. Uttar Pradesh: Pearson India Education Services, 2020. ISBN 978-93-534-3891-3.
-
Conolly, Thomas; Begg, Carolyn E.; Holowczak, Richard. Mistrovství - databáze : profesionální průvodce tvorbou efektivních databází. Vyd. 1. Brno : Computer Press, 2009. ISBN 978-80-251-2328-7.
-
Chong, Raul; Hakes, Ian; Ahuja, Rav. Začínáme s DB2 Express-C : kniha od komunity pro komunitu. 3. vyd. Praha : DNS, 2009.
-
Pokorný J. Počítačové databáze, Výběr informací z organizační a výpočetní techniky. KS Praha, 1991.
-
Pokorný, J., Valenta, M. Databázové systémy. Praha: Česká technika - nakladatelství ČVUT, 2020. ISBN 978-80-01-06696-6.
-
Pokorný, Jaroslav. Databázové systémy 2. Vyd. 1. Praha : Nakladatelství ČVUT, 2007. ISBN 978-80-01-03797-3.
-
Pokorný, Jaroslav; Halaška, Ivan. Databázové systémy. Vyd. 2., přeprac. Praha : Vydavatelství ČVUT, 2003. ISBN 80-01-02789-9.
-
Scheber, Anton. Databázové systémy. 1. vyd. Praha : SNTL, 1988.
-
Stephens, Ryan K.; Plew, Ronald R.; Jones, Arie. Naučte se SQL za 28 dní. 1. vydání. 2012. ISBN 978-80-251-2700-1.
-
Teorey, Toby. Database modeling and design. Burlington, 2011. ISBN 978-0-12-382020-4.
|