|
Lecturer(s)
|
-
Laštovička Jan, Mgr. Ph.D.
-
Urbanec Tomáš, Mgr.
-
Foltasová Eliška, Mgr.
|
|
Course content
|
Relational model: attributes, domains, relation schemes, tuples, relations and relational variables. Characteristics properties of relations and relational variables. Tables in SQL. Basic relational operations: sets operations, restriction, projection, join and renaming. Relational expressions and their characteristics properties. Relational division. SELECT expression: procedural and declarative semantics. Nasted SELECT expressions. Characteristic properties of SELECT expressions. Integrity constraints: primary and alternative keys, foreign keys. Functional dependency. Boyce-Codd normal form. Database normalisation. Advance SELECT expressions: tuples sorting, aggregations, grouping and group filtering. Query planner, optimisation and indexes. Building relational expression from characteristics property.
|
|
Learning activities and teaching methods
|
|
Lecture, Demonstration
|
|
Learning outcomes
|
The students become familiar with basic concepts of database systems.
2. Comprehension. Understand basic concepts of database systems.
|
|
Prerequisites
|
unspecified
|
|
Assessment methods and criteria
|
Oral exam, Written exam
Active participation in class. Completion of assigned homeworks. Passing the oral (or written) exam.
|
|
Recommended literature
|
-
Braharu D. (2018). Database For Beginners: Relational Database Concepts and Model (Programming courses). Independently published.
-
Connolly Thomas, Begg Carolyn. (2002). Database Systems: A Practical Approach to Design, Implementation and Management. Addison Wesley.
-
Elmasri R., Navathe S. B. (2000). Fundamentals of Database Systems, 3rd edition. Addison Wesley.
-
Johnson James L. (1997). Database Models, Languages, Design. Oxford University Press.
-
Maier R. (1983). The Theory of Relational Databases. Computer Science Press.
-
Pokorný J. (1992). Databázové systémy a jejich použití v informačních systémech. Academia.
-
Rob. P., Coronel C. (2004). Database Systems. Design, Implementation & Management, 6th edition. Thomson Course Technology.
-
Simovici D. A., Tenney R. L. (1995). Relational Database Systems. Academic Press.
|