Databases

General

• Code: 203
• Semester: 2nd
• Study Level: Undergraduate
• Course type: General Background
• Teaching and exams language: Greek
• The course is offered to Erasmus students
• Teaching Methods (Hours/Week): Lectures, Laboratory Exercises (4)
• ECTS Units: 5
• Course homepage: https://elearning.cm.ihu.gr/course/view.php?id=117
• Instructors: Kehris Evangelos
• Class Schedule:
  • Mon 13:00 - 16:00:
  • Thu 12:00 - 14:00:
• Exams Schedule:
  • 20/06/2024, 18:00 - 20:00:

Course Contents

Basic Concepts, Database Management System and Architecture, Data Models and the Entity-Relationship Diagram, The Relational Model, Converting a DBMS to a Relational Database, Introduction to SQL, Introducing a Database Management System and demonstrating its basic capabilities (creating a database , queries, forms).

Educational Goals

The objectives of of the course are:

• To demonstrate the importance of valid and timely data both in the daily operation of the business and in making business decisions.
• To present the basic concepts of database technology that makes access to data and information possible.
• To present and analyze the basic principles of relational databases.
• Describe and analyze the stages of developing a database, the human resources necessary and tools available for this undertaking.

Upon completion of the course students should be able to:

• Develop Entity-Relationship Diagrams based on descriptions and/or business documents.
• Recognize the advantages and limitations of design decisions underlying an Entity Relationship Diagram.
• know the basic principles of relational databases.
• Convert Entity-Relationship Models into well-designed relational databases.
• Implement the relational databases they have designed in a DBMS using the SQL language.

General Skills

to be filled

Teaching Methods

• Face to faqce.

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

• Database Systems Journal
• ACM Transactions on Database Systems
• International Journal of Intelligent Information and Database Systems