Topics in Databases

General

• Code: Γ01
• Semester: Κατ/νσης Εαρ Εξάμηνο
• Study Level: Undergraduate
• Course type: Specialization
• Teaching and exams language: Greek
• Teaching Methods (Hours/Week): Lectures and Laboratory Exercises (4)
• ECTS Units: 5
• Course homepage: https://elearning.cm.ihu.gr/course/view.php?id=33
• Instructors: Kehris Evangelos

Course Contents

Extended Entity-Relationship Diagram, main and child classes, inheritance, EDOS to Relational Database Conversion – presentation of alternative approaches analysis of features of each approach, advanced topics in SQL, demonstration of data-driven application development technique using appropriate environment software, presentation and analysis of the application.

Educational Goals

The objectives of the course are:

• To present advanced concepts of database technology that have influenced modern approaches to the representation of reality.
• To analyze the relationship between the representation of data at a conceptual level and their implementation in a database management system.
• To present the SQL language.

By completing the course students should be able to:

• Develop Extended Entity-Relationship Diagrams based on descriptions and/or business documents.
• Recognize the advantages and limitations of design decisions underlying an Entity Relationship Diagram.
• Transform Extended Entity-Relationship Diagrams into well-designed relational databases.
• Use the SQL language to create a relational database by enforcing appropriate referential integrity constraints.

General Skills

to be filled

Teaching Methods

• Face to face.

Use of ICT means

• Online guidance.
• Slides Projection in the classroom.
• Use of E-mail and onlne communication systems.
• Use of e-learning system (moodle).

Teaching Organization

Students Evaluation

to be filled

Recommended Bibliography

• Ε. Κεχρής «Σχεσιακές Βάσεις Δεδομένων», ΚΡΙΤΙΚΗ, 2021
• Elmasri R., Navathe S. B., Θεμελιώδεις αρχές συστημάτων βάσεων δεδομένων, έκδοση: 6η Έκδοση, ΔΙΑΥΛΟΣ, 2016
• Ramakrishnan R., Gehrke J., Συστήματα Διαχείρισης Βάσεων Δεδομένων, 3η Έκδοση, Εκδ. Τζιόλα, 2024.
• Coronel Carlos, Morris Steven, Συστήματα Βάσεων Δεδομένων, ΚΡΙΤΙΚΗ, 2024
• Hoffer J., Ramesh V., Topi H.,Βάσεις Δεδομένων – σύγχρονη διαχείριση, ΕΚΔΟΣΕΙΣ ΤΖΙΟΛΑ, 2023

Related Research Journals

1. Database Systems Journal.
2. ACM Transactions on Database Systems.
3. International Journal of Intelligent Information and Database Systems.