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
• 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