Lecturer(s)
|
-
Remeš Radim, Mgr. Ph.D.
-
Beránek Ladislav, prof. Ing. CSc., MBA
|
Course content
|
1. - Basic database terminology 2. - E-R conceptual model 3. - Relational database model 4. - Relational algebra, relational calculus 5. - Structured query language (SQL) 6. - SQL - complex queries, data definition, updating data 7. - Security. Queries optimalization 8. - Database normalization 9. - Transaction data processing 10. - Deductive DS 11. - Distributive DS 12. - Post-relational DS 13. - Data mining
|
Learning activities and teaching methods
|
Monologic (reading, lecture, briefing), Demonstration, E-learning
- Preparation for exam
- 14 hours per semester
- Preparation for credit
- 14 hours per semester
- Semestral paper
- 42 hours per semester
- Preparation for classes
- 42 hours per semester
- Class attendance
- 28 hours per semester
|
Learning outcomes
|
The course is aimed to introduce students basic theory of database technology. The course includes an overview of basic database models (E-R conceptual model, relational DB model, object DB model), rules of database normalization process, relational algebra, query language SQL, transaction and concurrent access to databases.
The students are able to design, develop and manage relational database applications for personal use even for school or small firm use. Student can orientate in problematics of database design, creating and optimalizating SQL queries.
|
Prerequisites
|
The course has no prerequisities.
|
Assessment methods and criteria
|
Combined exam
Credit Requirements: Programming partial short tasks, creating a project application. Global success rate minimally 65%. Examination Requirements: Students will demonstrate complex knowledge of creating and designing databases.
|
Recommended literature
|
-
Elmasri - Navathe:. Fundamentals of database systems.
-
CHURCHER, C. Beginning Database Design: From Novice to Professional. Apress, 2007.
-
J. Viescas, M. J. Hernandez. SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL. Addison-Wesley Professional; 3 edition, 2014. ISBN 978-0321992475.
-
K. Toth. Beginner Database Design & SQL Programming Using Microsoft SQL Server 2014. CreateSpace Independent Publishing Platform, 2014. ISBN 978-1499321739.
-
N. Jukic, S. Vrbsky, S. Nestorov. Database Systems: Introduction to Databases and Data Warehouses. Prentice Hall, 2013. ISBN 978-0132575676.
-
S. Bagui, R, Earp. Database Design Using Entity-Relationship Diagrams. Auerbach Publications, 2003. ISBN 978-0849315480.
|