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
Short Description:

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.

Objectives - Learning Outcomes:

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.

Syllabus:

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.

Suggested Bibliography:
  • RaghuRamakrishnan, JohannesGehrke. Συστήματα Διαχείρισης Βάσεων Δεδομένων. Εκδόσεις Τζιόλα, 2012.
  • D. Ullman, J. Widom. Βασικές Αρχές για τα Συστήματα Βάσεων Δεδομένων. Εκδόσεις Κλειδάριθμος, 2008.
  • C. J. Date. Εισαγωγή στα Συστήματα Βάσεων Δεδομένων. Εκδόσεις Κλειδάριθμος (Τόμος Α & Β).
Teaching Methods:

Lectures making extensive use of visual aids. Practical training takes place in the computer laboratory.

New Technologies:

-

Evaluation Methods:

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

<< <
March 2024
> >>
Mo Tu We Th Fr Sa Su
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Today, Friday 29-03-2024
No results found for that day

Secretariat

72 Ioannou Theotoki str.
+30 26610 87418 / 87406 / 87423
archei@ionio.gr

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

Text To SpeechText To Speech Text ReadabilityText Readability Color ContrastColor Contrast
Accessibility Options