Department of Information & Communication Systems Engineering
University of the Aegean

Department of Information
& Communication Systems Engineering

Information & Communication Systems Security
Information Systems
Artificial Intelligence
Computer & Communication Systems
Geometry, Dynamical Systems & Cosmology
Databases I

Title: Databases I
Lesson Code: 321-3203
Semester: 4
Theory Hours: 3
Lab Hours: 2
Faculty: Tzouramanis Theodoros
Content outline

Introduction to Database Management Systems (DBMS). Databases. Database users. Advantages of using a DBMS. Schemas and instances. DBMS architecture. The principle of data independence. The entity-relationship, the relational and the object-relational model. Integrity constraints. Database update operations. Database languages. Relational algebra. Tuple and domain relational calculus. The QBE language. SQL as a query language: queries, views, update statements. Introduction to primary file organizations and indexes. Presentation of commercial DBMSs.

Learning outcomes

The foundation of database science and, more precisely, developing students’ knowledge of the principle of conceptual and logical modeling and designing of databases, the database programming languages, as well as of the options for implementation that are nowadays made available by database management systems.

Not required.
Basic Textbooks

1. Elmasri R. and Navathe S.B.: "Θεμελιώδεις Αρχές Συστημάτων Βάσεων Δεδομένων", 6η Έκδοση, 2012. Μετάφραση από τις Εκδόσεις Δίαυλος (in Greek).
2. Μανωλόπουλος Ι. και Παπαδόπουλος Α.: "Συστήματα Βάσεων Δεδομένων", Εκδόσεις Νέων Τεχνολογιών, 2006 (in Greek).
3. Ramakrishnan R., Gehrke J.: "Συστήματα Διαχείρισης Βάσεων Δεδομένων", 3η Έκδοση, 2012 (in Greek).

Additional References

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

Learning Activities and Teaching Methods

Personal assignments and pair or group assignments, lab practice, regular short assessments in the form of a quiz test, final examination.

Assessment/Grading Methods
Activity Semester workload
Lectures 39 hours
Laboratory Exercises 26 hours
Personal study 56 hours
Πρόοδος 1 hour
Final exams 3 hours
Course total 125 hours (5 ECTS)
Language of Instruction
Greek, English (for Erasmus students)
Μode of delivery


Home | Contact

University Of The Aegean

Department of Information & & Communications Systems Engineering

© Copyright ICSD :: 2008 - 2017