Semester 6

Course: Databases

Course Code: MK38
Course Level: Undergratuate
Obligatory/Elective: Elective
Semester: 6
Division: Main Course
Group: Main Course
ECTS Credits: 5
Hours Per Week: 4
Language: Greek

1. Introduction to databases (DBs) and DB Management Systems.
2. Architecture of DB Systems.
3. Entity-Relationship model.
4. Relational Model.
5. Relational Algebra.
6. Structured Query Language (SQL).
7. Functional Dependencies and Normalization.
8. Physical organization of DBs and means of storage.
9. Indexes.

Learning Results:

The expected learning outcomes are the following:
1. Understanding the basic principles of design and implementation of Database Systems
2. Familiarity with using Entity Relationship Diagrams
3. Understanding the Relational Model
4. Acquisition of basic knowledge of Relational Algebra and SQL
5. Acquisition of advanced SQL capabilities knowledge
6. Experience with MySQL
7. Understanding the basic principles of normalization
8. Acquisition of knowledge about the storage of Databases and basic indexing structures
9. Experience in collaborative database implementation



Teaching Methods:
Method Description Semester Workload
Lectures 52
Project work in small groups 38
Personal studying 35
Total 125

The evaluation is done through:
1. written examination at the end of the semester
that includes short answer questions and resolution
of exercises
1. scoring the report and the code of the project
carried out during the semester. The scoring is 

done separately for each of the four phases of the
project and in total at the end
2. oral presentation of the various phases of the
project carried out during the semester
The evaluation criteria are as follows:
• correctness
• clarity
• accuracy
• efficiency

Suggested Books:

- Recommended Book Resources:
• Elmasri Ramez, Navathe Shamkant B., Fundamentals of Database Systems, 2007.
• Ramakrishnan Raghu, Gehrke Joahannes, Database Management Systems, 2012.
• Abraham Silberschatz, Henry F. Korth, S. Sudarshan, Database Systems, 2011.
- Recommended Article/Paper Resources:
ACM Transactions on Database Systems, VLDB Journal, IEEE Transactions on Knowledge and Data Engineering,
Information Systems

Lecturer: Ploskas Nikolaos