Course Details

Course Code (English)*

Semester*

Title (English)*

Lecture Hours (Weekly)

ECTS Credits*

Course Type (English)

Prerequisites (English) Data structures

Course URL (e.g., on e-class)

Learning Outcomes (English) The aim of the course is to assist students understand the basic concepts of Database Management Systems DBMS and become familiar with the process of creating a database. Students will understand the need for constraints and how the database constraints affect the modification of data in the database. Finally, students will become familiar with basic SQL commands through their application in a real DBMS. At the end of the course the students must be able to: - Understand the role of constraints in database creation and updates - Use SQL in real database environment

General Competencies (English) - Adaptation in new conditions - Independent work - Team work

Course Content (English) The Database Environment. Database Development Process. The Entity-Relationship E-R Model. Logical Database Design and the Relational Database Model. Integrity constraints. Transformation of the E-R diagram to a Relational DB Schema. Database Update. Database Management Languages. Relational Algebra. Relational calculus. SQL as a data management language: queries, views, updates. Introduction to the DB file management and indexing structures.

Use of ICT (English) - Use of database software - Custom software for individual exercises in SQL - Dissemination and organization of course material using OpenClass - Communication via OpenClass and emails - The course is available as open course in opencourses.gr

Is it elective? Άγνωστο Ναι Όχι

Load within semester (Hours)

Lecture Hours

Lab Hours

Independent Study*

Project Work*

Lab Report*