SUBJECT

Title

Data Bases 2

Type of instruction

lecture + practical

Level

bachelor

Faculty

Faculty of Informatics

Part of degree program

Credits

3+2

Recommended in

Semester 5

Typically offered in

Autumn semester

Course description

Relational data models. Concept of the domain, the attribute, the record. Relation as a concept of Descartes series, as mapping, as a table. The key and is characteristics. The functional dependence and its properties, families. Decomposition and it’s properties. The four normal forms. Normalisation. The operations of relational algebra. Application of the dBase III language in data base handling. XML, DTD, XML Schema, XPath, XQuery, XSLT.

Readings

Ullman J.D., Widom J. : Database Systems Implementation (Prentice Hall, United States, edition, June 11, 1999)

Recommended literature:

Békéssy A., Demetrovics J. : Adatbázis-szerkezetek (Akadémiai Kiadó, Budapest, 2005)
Kende M., Kotsis D., Nagy I. :Adatbázis-kezelés az ORACLE rendszerben (Panem Kft., Budapest, 2002)
Gábor A., Juhász I.: PL/SQL-programozás (Panem, Budapest, 2007)
Kende M., Nagy I.: Oracle-példatár (SQL, PL/SQL) (Panem, Budapest, 2005)
Loney K.: Oracle database 10g Teljes referencia (Panem, Budapest, 2006)