The general scope of the course is to provide students with the specified knowledge of relational databases emphasizing to their design as well as to database implementation using the SQL language.
On successful completion of this module the learner will be able:
To understand the relational data mode and the database design by applying the entity-relationship model.
To understand the capabilities and advantages of the relational databases.
To design efficient and operational database systems.
General Skills:
The general skills that are acquired upon completion of the course are:
Work Autonomously
Work in Teams
Work in an International Context
Work in a Multidisciplinary Context
Course Contents:
Database administration and related topics: the role of the database administrator. Transactions. Recovery. Concurrency. Query optimization. Updateable views. Database design: advanced topics of normalization, Enhanced Entity Relationship modeling. Various topics and new trends e.g. object oriented model, object-relational model, active databases, data warehouse, data mining, knowledge management, OLAP, XML technology. Programming and implementation: database applications’ implementation using relational products and 4GLs. Case Studies: Distributed databases / databases over the Internet (and Intranets).
