Course: Database Systems 1

« Back
Course title Database Systems 1
Course code KMI/ODBS1
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 5
Language of instruction English
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Remeš Radim, Mgr.
  • Beránek Ladislav, doc. Ing. CSc.
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.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Economics Study plan (Version): - (1) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter