Databases

Databases

Academic Semester:

Course Type	Reference Number	Subprogram
Compulsory	Theory: ΤΠ30Κ2 Lab: ΤΠ31Κ2

Semester	Academic Year	Hours per week
Winter	2nd	Theory: 3 Lab: 2

Exams	ECTS	Workload
Theory: Final written exam in the whole material (100%). The test includes five theory questions (1 point each) and three exercises (2.50 points each) from which the student selects and performs two. Laboratory: The final grade is subsumed under the eval	6	11

Prerequisites	Teaching method	Teaching Language
	Lectures with parallel laboratory classes	Greek, English

Academic Staff

Faculty in charge:

ακουμιανάκης δημοσθένης

Akoumianakis Demosthenes

Professor

Καθηγητής

2810-379190

Address:

The course is based on four main sections:

Introduction to Data Models and Databases (ie. What is the data model, overview of classical data models, principles and advantages of databases, architecture of a database management system, logical and physical database design).
Detailed presentation of the Entity-Relationship model (ie. Basic concepts of the model and detailed presentation of the diagrammatic style, implementation in selected areas and development of Entity-Relationship models.
Practicing in the relational data model (ie. Definition of structures of Relational database model, review of the integrity constraints of the model, detailed presentation of Data Management Languages (Relational Algebra, Tuple Relational Calculus and modern systems), transformation of Entity-Relationship model to Relational Database schema and vice versa.
Relational schema design (ie. Problems regarding Relational schemas, Relational schema good design principles and Normal Forms).

RECCOMENDED BIBLIOGRAPHY

C.J. Date (2002): Εισαγωγή στα Συστήματα Βάσεων Δεδομένων – Τόμοι Α' & Β', Μετάφραση στα Ελληνικά από τις εκδόσεις "Κλειδάριθμος".
Silberschatz, H. F. Korth & S. Sudarshan (2001): Database System Concepts (4th Edition), McGraw-Hill ISBN 0-07-255481-9.
R. Elmasri & S. Navathe (1996): Fundamentals of Database Systems, Μετάφραση στα Ελληνικά από τις εκδόσεις "ΔΙΑΥΛΟΣ".
P. P-S Chen (1976): The Entity-Relationship Model-Toward a Unified View of Data, ACM Transactions on Database Systems, 1(1), pp. 9-36.