Databases

Course Information
TitleΒάσεις Δεδομένων / Databases
Code112
FacultyEngineering
SchoolElectrical and Computer Engineering
Cycle / Level1st / Undergraduate
Teaching PeriodWinter
CoordinatorThemistoklis Diamantopoulos
CommonNo
StatusActive
Course ID600001077

Programme of Study: Electrical and Computer Engineering

Registered students: 104
OrientationAttendance TypeSemesterYearECTS
ELECTRICAL ENERGYElective Courses954
ELECTRONICS AND COMPUTER ENGINEERINGElective Courses954
TELECOMMUNICATIONSElective Courses954

Class Information
Academic Year2020 – 2021
Class PeriodWinter
Instructors from Other Categories
Class ID
600169791
Course Type 2016-2020
  • Scientific Area
  • Skills Development
Course Type 2011-2015
Specific Foundation / Core
Mode of Delivery
  • Face to face
Digital Course Content
Erasmus
The course is also offered to exchange programme students.
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
Lectures451.5
Interactive Teaching in Information Center150.5
Project150.5
Written assigments210.7
Exams240.8
Total1204
Student Assessment
Description
Final Exam 70% Project 1 - Design of a relational database (report, in class presentation) 15% Project 2 - Development of an SQL database (software, report, lab exam) 15%
Student Assessment methods
  • Written Exam with Multiple Choice Questions (Formative)
  • Written Exam with Short Answer Questions (Formative)
  • Written Exam with Extended 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. 4. Συστήματα Διαχείρισης Βάσεων Δεδομένων, (3η έκδοση, μεταφρ. στα ελληνικά), R. Ramakrishnan and J. Gehrke, Εκδόσεις Τζιόλας, 2011.
Additional bibliography for study
Πληθώρα συγγραμμάτων στην ελληνική και ξένη βιβλιογραφία. Σημειώσεις και διαφάνειες των διαλέξεων είναι διαθέσιμες στο διαδίκτυο.
Last Update
17-12-2015