Databases
Teaching Staff: Gergatsoulis Emmanuel, Kalogeros Eleftherios
Course Code: ARC000000000000000000000001
Field: General Core
Course Category: General Background
Course Type: Compulsory
Course Level: Undergraduate
Course Language: Greek
Delivery method: Face to face
Semester: 3rd
ECTS: 5
Total Hours: 5
E Class Page: https://opencourses.ionio.gr/modules/auth/opencourses.php?fc=26
Databases are an indispensable tool for storing, organizing, and retrieving data managed by Archives, Libraries, and Museums.
The course introduces students to the basic concepts of Databases and presents the basic principles of modern Database Management Systems (DBMSs).
Particular emphasis is given on database management systems based on the relational model while briefly describing modern approaches to database systems. The laboratory part of the course includes the practical application of the basic concepts of the databases and the familiarization of students with real database environments. In particular, students are practiced on DBMS such as MS-ACCESS and MySQL.
The course aims at familiarizing students with the basic concepts as well as the use of databases with particular emphasis on database applications in Archives, Libraries and Museums.
Week #1: Introduction to Databases. Database Management Systems (DBMS).
Week #2: Data models. Integrity Constraints.
Week #3: Database Design: Methodology.
Week #4: Entity-Relationship Model. ER-diagram.
Week #5: Relational Model.
Week #6: Methodology to transform ER-diagram to relational schema.
Week #7: Database design: A complete example.
Week #8: Relation Algebra: basic notions.
Week #9: SQL instructions: table creation, insertion of data and modification of tables.
Week #10: SQL queries.
Week #11: Query-by-Example.
Week #12: Applications of Databases in Archives, Libraries, and Museums.
Week #13: Semistructured Databases, XML Databases, Document Databases, No-SQL Databases.
- RaghuRamakrishnan, JohannesGehrke. Συστήματα Διαχείρισης Βάσεων Δεδομένων. Εκδόσεις Τζιόλα, 2012.
- D. Ullman, J. Widom. Βασικές Αρχές για τα Συστήματα Βάσεων Δεδομένων. Εκδόσεις Κλειδάριθμος, 2008.
- C. J. Date. Εισαγωγή στα Συστήματα Βάσεων Δεδομένων. Εκδόσεις Κλειδάριθμος (Τόμος Α & Β).
Lectures making extensive use of visual aids. Practical training takes place in the computer laboratory.
-
Course evaluation includes: a) Written examination for the theoretical part of the course, b) Examination of the laboratory part of the course. The final grade is obtained as the average of the two grades.
Back
Important News
Library and Information Center
72 Ioannou Theotoki str.+30 26610 87223
libraryloan@ionio.gr
library.ionio.gr
Working Hours
The secretariat is open:Monday-Friday: 9am to 3pm
Saturday & Sunday: Closed
For secretariat related issues, contact Mrs. Georgia Gatsou on weekdays between 9:00 - 11:00 in the morning at the telephone numbers 26610-87418/87406 and through email: gatsou@ionio.gr, archei@ionio.gr
