Output Title Creation of on-line distance course on Databases
Output Type Course / curriculum – Pilot course / module
Start Date (yyyy-mm-dd) 2021-09-15
End Date (yyyy-mm-dd) 2022-09-15
Output Description (including: needs analysis, target groups, elements of innovation, expected impact and transferability potential)
The Pandemic of Covid19 has faced the educational institutions worldwide in front of new unexpected challenges with regard to the new requirements of the state authorities for
transition from face-to face to distance education type of learning activities. The greater part of the schools and universities worldwide and even in Europe were not ready to take that
challenge due to lack of administrative, staff and financial resources. The innovativeness of the current learning course on Databases is expresses by its characteristics to be prepared
in a way that will meet all the quality requirements of the F2F course, as at the same time it will be on-line distance course. It is expected to have great beneficial impact on the Target
group – students in Databases, as it will allow them not to lower the quality of their education as that happened in the learning year 2020.
The course Databases is part of the curriculum and includes 15 summary topics. As a form of control it is envisaged on-gong control, course project and exam.
The proposed curriculum addresses key issues in the theory of Databases:
a) The conceptual model of databases includes the main tasks that solve the problems set;
b) The logical model of the database includes the logical connections between the different data, which are the basis of the developed database;
c) A physical model of the databases is their physical realization (location, links and management of inoration);
The course examines the three main models of data presentation encountered in practice:
a) hierarchical;
b) network;
c) relational.
In conclusion, some of the main ideas part of the theory of distributed databases are being considered.
AIMS AND EXPECTED RESULTS
The aim of the course is for students to acquire theoretical knowledge and practical experience in building databases. The main task is for the student to be able to build databases
under set conditions.
Expected results. The student should be able to build databases that are not very complex.
LECTURES

  1. Basic concepts.
  2. Logical and physical bases of databases.
  3. Data models.
  4. Basic search methods. File types.
  5. Relational model – basic concepts, relational schemes.
  6. Relational languages.
  7. Relational systems.
  8. Development of a sample database.
  9. Object-oriented database systems.

PRACTICE

  1. Basic concepts in databases. Introduction to the computer program MS Access.
  2. Use of tables and subforms. Using filters and reports.
  3. Maintaining database changes. Ensuring the reliability of information in the database.
  4. Creation of a query. Use of queries.
  5. Ensuring the reliability of information in the database.
  6. Use of queries.
  7. Merging of data into one form.
  8. Presentation of an effective report.

For the on-line distance learning course in Databases
The main responsible partners for development of the on-line distance learning course in Databases will be – South-West University “Neofit Rilski” – Blagoevgrad, Çanakkale Onsekiz
Mart University. Each of them will devote two researchers for applying the Methodology from IO 1 and to develop the learning course. Furthermore one technician per partner will be
responsible for the on- line development and coherence of the course. The course will be approbated in both universities within the framework of one school year.
Based on the Methodology developed under IO 1 an on-line distance learning course in Databases will be developed and at least 150 students will be trained using those courses in
one Academic year.
The methodologies applied, leading to the production of the intellectual output will be:
􀀀 Desk research
􀀀 Best practices application
Tasks leading to the production of the intellectual output:
􀀀 Preparation of detailed outline for curriculum development according the methodology developed under IO 1
􀀀 Development of draft version of the modular content of the learning courses in Databases
􀀀 Approbation of the learning courses
􀀀 Development of final version of the modular content of the learning courses in Databases