Courses

Database Systems and Data Structures

General

Course Contents

Theory:
1. Introduction to Database Systems
2. Introduction to Data Structures
3. Relational Database – Data Modelling
4. Database Entities and Data Structures
5. Database Constraints
6. Database Design Diagram
7. Introduction to SQL (Structured Query Language) a standardized programming language
8. Complex SQL queries
9. Database indexes, Database Views, Query optimization,
10. Non-relational Databases (NoSQL databases)
11. Big Data management
12. Information retrieval and Data Mining
13. Databases Management Systems – Database Security
Lab:
1. Introduction to database management tools and technologies
2. Access database management system
3. Hands-on for building a relational database
4. Data entry in database systems
5. Creating simple and complex queries
6. Manipulating data using sql queries

Educational Goals

KNOWLEDGE
Introduction to Database Systems and Data Structures
Assessment of database architectures and their use in ICT applications
Database Entities and Database Schema Design
Relational databases and Entity Relationship Diagram Design
Introduction to the SQL programming language
Identification of the basic user roles in modern Database Systems
Data and Information
ABILITIES
Analysis, design and implementation of Database Systems
Designing and implementing Entity Relationship Diagram models
Assessment database architectures
Using data structures in databases

General Skills

Search, analysis and synthesis of data and information, using corresponding technologies, Adaptation to new situations, Independent work, Teamwork – distribution of responsibilities.

Teaching Methods

Lectures, Exercises, Online guidance, Projected Presentations, E-mail communication, Online Synchronous and Asynchronous Teaching Platform (moodle).

Students Evaluation

Assessment Language: English / Greek
Theory (70%)
Public Presentations
Practical mid-term examination
Final Written Examinations
Lab (30%)
Public Presentations
Final Examinations
Evaluation criteria:
– Ability to Design and Implement Relational Databases
– Ability to program in SQL
– Ability to design a database
– Skills for managing databases
– Skills for Assignment Preparation and Presentation

Recommended Bibliography

Modern Database Management Hardcover by Jeffrey A. Hoffer (Author), V. Ramesh (Author), Heikki Topi ISBN: 978-960-418-502-3
Database Management Systems, 3rd Edition Raghu Ramakrishnan (Author), Johannes Gehrke (Author) ISBN: 978-960-418-411-8