Database Systems

Course Information
TitleΒΑΣΕΙΣ ΔΕΔΟΜΕΝΩΝ / Database Systems
CodeΗΥ1001
FacultyEngineering
SchoolElectrical and Computer Engineering
Cycle / Level1st / Undergraduate
Teaching PeriodWinter
CoordinatorThemistoklis Diamantopoulos
CommonNo
StatusActive
Course ID20000587
Class Information
Academic Year2024 – 2025
Class PeriodWinter
Instructors from Other Categories
Weekly Hours3
Class ID
600263154
Course Type 2016-2020
  • Scientific Area
  • Skills Development
Course Type 2011-2015
Specific Foundation / Core
Mode of Delivery
  • Face to face
Digital Course Content
Language of Instruction
  • Greek (Instruction, Examination)
  • English (Examination)
Prerequisites
General Prerequisites
Students are strongly encouraged to have completed the following courses: Programming Techniques, Data Structures, and Software Engineering.
Learning Outcomes
Upon successful completion of the course students are expected to be able to: a) Analyse the requirements of an application that requires a database, b) Design a relational database, c) Develop a relational database, d) Design and submit SQL queries, e) Understand the advantages of using a database, f) Know the main architectural options for database management systems, g) Know the basic concepts and technologies for web databases.
General Competences
  • Apply knowledge in practice
  • Retrieve, analyse and synthesise data and information, with the use of necessary technologies
  • Adapt to new situations
  • Make decisions
  • Work autonomously
  • Work in teams
  • Work in an international context
  • Design and manage projects
  • Advance free, creative and causative thinking
Course Content (Syllabus)
Introductory course to Database Management Systems under the broad category of software courses. It includes techniques and methods for the analysis, modeling, design, and development of databases and introduces the student to some popular database management systems. The course comprises theoretical and practical work and its contents are: - The need for database (DB) management systems. - Data models: Entity-relationship, Relational, and Object-oriented. - Database design according to the relational model. Normal forms and Normalization. - Relational algebra and calculus. SQL. - Methodology for the development of a database. - Web databases. Intro to XML. - Query optimization. - Data protection: recovery, synchronization, integrity, security. - Architectures for database management systems.
Keywords
Databases, Software, Database Management Systems, Data Search
Educational Material Types
  • Notes
  • Slide presentations
  • Multimedia
  • Interactive excersises
  • Book
Use of Information and Communication Technologies
Use of ICT
  • Use of ICT in Course Teaching
  • Use of ICT in Laboratory Teaching
  • Use of ICT in Communication with Students
Course Organization
ActivitiesWorkloadECTSIndividualTeamworkErasmus
Lectures✓
Seminars✓
Laboratory Work✓
Tutorial✓
Interactive Teaching in Information Center✓
Project✓
Written assigments✓
Public presentation of project✓
Total
Student Assessment
Description
Student evaluation is clearly stated in the course syllabus, which is distributed on the first day of classes and is continuously available on the course website. Student evaluation comprises: Final Exam 70% Project 1 (Design of a relational database) 15% Project 2 (Development of an SQL database) 15% Details at the course website
Student Assessment methods
  • Written Exam with Multiple Choice Questions (Formative)
  • Written Exam with Short Answer Questions (Formative)
  • Written Assignment (Formative)
  • Oral Exams (Formative)
  • Performance / Staging (Formative)
  • Written Exam with Problem Solving (Formative)
  • Report (Formative)
  • Labortatory Assignment (Formative)
Bibliography
Course Bibliography (Eudoxus)
1. Συστήματα Βάσεων Δεδομένων, (6η έκδοση, μεταφρασμένο στα ελληνικά), A. Silberschatz, H. Korth, and S. Sudarshan, Εκδόσεις Γκιούρδας, Έτος έκδοσης 2011. 2. Βασικές Αρχές για τα Συστήματα Βάσεων Δεδομένων, (2η έκδοση, μεταφρασμένο στα ελληνικά), J. D. Ullman and J. Widom, Εκδόσεις Κλειδάριθμος, Έτος Έκδοσης 2008. 3. Συστήματα Βάσεων Δεδομένων: Θεωρία και Πρακτική Εφαρμογή, Ι. Μανωλόπουλος και Α. Ν. Παπαδόπουλος, Εκδόσεις Νέων Τεχνολογιών, Έτος έκδοσης 2006, Σελ. 556 4. Συστήματα Διαχείρισης Βάσεων Δεδομένων, (3η έκδοση, μετ. στα ελληνικά), R. Ramakrishnan and J. Gehrke, Εκδόσεις Τζιόλας, Έτος έκδοσης 2011.
Additional bibliography for study
Πληθώρα συγγραμμάτων στην ελληνική και ξένη βιβλιογραφία. Σημειώσεις και διαφάνειες των διαλέξεων είναι διαθέσιμες στο διαδίκτυο.
Last Update
05-09-2024