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 (3)
• 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

1. Ε. Κεχρής «Σχεσιακές Βάσεις Δεδομένων», ΚΡΙΤΙΚΗ, 2021.
2. Elmasri R., Navathe S. B., Θεμελιώδεις αρχές συστημάτων βάσεων δεδομένων, έκδοση: 6η Έκδοση, ΔΙΑΥΛΟΣ, 2012.
3. Ramakrishnan R., Gehrke J., Συστήματα Διαχείρισης Βάσεων Δεδομένων, 3η Έκδοση, Εκδ. Τζιόλα, 2012.
4. Begg Carolyn, Connolly Thomas, Μια Πρακτική Προσέγγιση στο Σχεδιασμό την Υλοποίηση και τη Διαχείριση Συστημάτων Βάσεων Δεδομένων, Γκιύρδας, 2008.

Related Research Journals

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