Data Bases
| Title | Βάσεις Δεδομένων / Data Bases |
| Code | MIS-102 |
| Interdepartmental Programme | Management and Information Systems |
| Collaborating Schools | Informatics Economics |
| Cycle / Level | 2nd / Postgraduate |
| Teaching Period | Winter |
| Common | No |
| Status | Active |
| Course ID | 600015134 |
| Academic Year | 2018 – 2019 |
| Class Period | Winter |
| Faculty Instructors | |
| Instructors from Other Categories |
|
| Weekly Hours | 3 |
| Total Hours | 39 |
| Class ID | 600125013
|
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/600125013
- eLearning (Moodle): https://elearning.auth.gr/course/view.php?id=10984
Erasmus
The course is also offered to exchange programme students.
Language of Instruction
- Greek (Instruction, Examination)
Prerequisites
General Prerequisites
There are no prerequisite courses.
Learning Outcomes
Understanding: Explaining ideas or database concepts.
Application: Application of database concepts.
Analysis: Analyze database concepts into their components.
Creation: Synthetic project in Databases.
Manipulation: Ability to perform specific actions on a database management system and in other helping software tools.
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
- Advance free, creative and causative thinking
Course Content (Syllabus)
Introduction, Database Architecture, Modeling data with entity-relationship model, Relational model and relational algebra, SQL language, Relational calculus and multi-valued Functional Dependencies, Normal forms. Lab exercises.
Keywords
databases, entity-relationship model, relational model, relational algebra, SQL language, functional dependencies, normal forms
Educational Material Types
- Slide presentations
- Book
Use of Information and Communication Technologies
Use of ICT
- Use of ICT in Course Teaching
- Use of ICT in Laboratory Teaching
Course Organization
| Activities | Workload | ECTS | Individual | Teamwork | Erasmus |
|---|---|---|---|---|---|
| Lectures | 39 | 1.3 | ✓ | ||
| Project | 48 | 1.6 | ✓ | ||
| Written assigments | 42 | 1.4 | ✓ | ||
| Study | 51 | 1.7 | ✓ | ||
| Total | 180 | 6 |
Student Assessment
Description
Final exam (60%), Synthetic project assignment (40%)
Student Assessment methods
- Written Exam with Extended Answer Questions (Summative)
- Written Assignment (Summative)
- Written Exam with Problem Solving (Summative)
Bibliography
Course Bibliography (Eudoxus)
Διδακτικές Σημειώσεις (διαφάνειες & πρόσθετο υλικό)
Additional bibliography for study
- Ιωάννης Μανωλόπουλος και Απόστολος Παπαδόπουλος: "Βάσεις Δεδομένων: Θεωρία και Πρακτική Εφαρμογή", Εκδόσεις Νέων Τεχνολογιών, Αθήνα, 2006.
- H. Garcia-Molina, J.D. Ullman, J.D. Widom, "ΣΥΣΤΗΜΑΤΑ ΒΑΣΕΩΝ ΔΕΔΟΜΕΝΩΝ, ΤΟΜΟΣ Ι", Πανεπιστημιακές Εκδόσεις Κρήτης, 2011.
- R. Ramakrishnan, J. Gehrke, "Database Management Systems", McGraw-Hill, 2002.
- C. J. Date, "Introduction to Database Systems", Addison Wesley, 2003.
- R. Elmasri, S.B. Navathe, "Fundamentals of Database Systems", Addison Wesley, 2006.
- A. Silberschatz, H.F. Korth, S. Sudarshan, "Database System Concepts", McGraw-Hill, 2005.
Last Update
16-10-2018
