Databases
| Title | Βάσεις Δεδομένων / Databases |
| Code | 112 |
| Faculty | Engineering |
| School | Electrical and Computer Engineering |
| Cycle / Level | 1st / Undergraduate |
| Teaching Period | Winter |
| Coordinator | Andreas Symeonidis |
| Common | No |
| Status | Active |
| Course ID | 600001077 |
Programme of Study: Electrical and Computer Engineering
Registered students: 129
| Orientation | Attendance Type | Semester | Year | ECTS |
|---|---|---|---|---|
| ELECTRICAL ENERGY | Elective Courses | 9 | 5 | 4 |
| ELECTRONICS AND COMPUTER ENGINEERING | Elective Courses | 9 | 5 | 4 |
| TELECOMMUNICATIONS | Elective Courses | 9 | 5 | 4 |
| Academic Year | 2021 – 2022 |
| Class Period | Winter |
| Instructors from Other Categories | |
| Class ID | 600196675
|
Course Type 2016-2020
- Scientific Area
- Skills Development
Course Type 2011-2015
Specific Foundation / Core
Mode of Delivery
- Face to face
Digital Course Content
- e-Study Guide https://qa.auth.gr/en/class/1/600196675
- At the Website of the School: http://alexander.ee.auth.gr:8083/eTHMMY/
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
| Activities | Workload | ECTS | Individual | Teamwork | Erasmus |
|---|---|---|---|---|---|
| Lectures | 45 | 1.5 | ✓ | ||
| Interactive Teaching in Information Center | 15 | 0.5 | |||
| Project | 15 | 0.5 | ✓ | ||
| Written assigments | 21 | 0.7 | |||
| Exams | 24 | 0.8 | |||
| Total | 120 | 4 |
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
