Department of Information & Communication Systems Engineering
University of the Aegean
SCHOOL OF ENGINEERING

Department of Information
& Communication Systems Engineering

Information & Communication Systems Security
Information Systems
Artificial Intelligence
Computer & Communication Systems
Geometry, Dynamical Systems & Cosmology
 
Βάσεις Δεδομένων Ι

Title: Βάσεις Δεδομένων Ι
Lesson Code: 321-3203
Semester: 4
ECTS: 5
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.

 
Prerequisites

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

Classroom teaching, group activities, etc.
 

 
Language of Instruction
Greek, English (for Erasmus students)
 
Μode of delivery

Face-to-face.



Home | Contact

University Of The Aegean

SCHOOL OF ENGINEERING
Department of Information & & Communications Systems Engineering

© Copyright ICSD :: 2008 - 2017