Databases (Theory)

Module Information

Module Semester:
4
Module Part:
Theory
Sub-Module Code:
244402
Hours per Week:
2
Workshop Hours per Week:
1
Module Website:
Module ECTS Credits:
5.5
Available to ERASMUS Students:
No
Module Staff:


Module Objective

This course is intended to provide an understanding of the current theory and practice of database management systems, as well, as a solid technical overview of database management systems. In addition to technical concerns, more general issues are emphasized. These include data independence, integrity, security, recovery, performance, database design principles, and database administration.


Module Study Targets

Upon completion of this class, students should be able to:

  • Employ design methodology for databases and verifying their structural correctness
  • implement databases and applications software primarily in the relational model
  • Use querying languages, primarily SQL, and other database supporting software
  • Apply the theory behind various database models and query languages
  • Understand the theories and techniques in developing database applications and be able to demonstrate the ability to build databases using DBMS products
  • Implement security and integrity policies relating to databases
  • Work in group settings to design and implement database projects
  • Understand new developments and trends in databases


Module Acquired Abilities

  • Search, analysis and synthesis of data and information
  • Decision Making: Synthesis of techniques for more advanced programming problems
  • Autonomous work: Knowledge of development tools and use of programming techniques in order to formulate a solution
  • Teamwork: Ability for dialog and cooperation for the development of composite Database problems


Module Description

  1. Introduction to Database Systems
  2. Data Models
  3. Relational Database Modelling
  4. Design Theory for Relational Databases
  5. High Level Database Models
  6. Relational Database Programming
  7. The Database Language SQL
  8. Advanced SQL
  9. Database Design
  10. Transactions Management and Concurrency Control
  11. Database Optimization
  12. Database Administration and Security
  13. Distributed Database Management Systems

Module Student Evaluation

Written examination: 60%

Laboratory examination: 40%

Project presentation of up to 20%, towards the written examination


Bibliography

  • A. Silberschatz, H.F. Korth and S. Sudarshan, "Database System Concepts", 6th Edition, McGraw-Hill, 2010
  • G.-Molina H., Ullman J. and Widom J., "Database Systems: The Complete Book", Prentice Hall Inc, 2002
  • C.J. Date, "An Introduction to Database Systems", 8th Edition, Addison Wesley-Pearson Education Inc, 2004