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 |
Programme of Study: Management and Information Systems
Registered students: 21
| Orientation | Attendance Type | Semester | Year | ECTS |
|---|---|---|---|---|
| KORMOS | Compulsory Course | 1 | 1 | 6 |
| Academic Year | 2019 – 2020 |
| Class Period | Winter |
| Faculty Instructors | |
| Instructors from Other Categories | |
| Weekly Hours | 3 |
| Class ID | 600155069
|
Type of the Course
- Scientific Area
- Skills Development
Course Category
Specific Foundation / Core
Mode of Delivery
- Face to face
Digital Course Content
- e-Study Guide https://qa.auth.gr/en/class/1/600155069
- 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
Cognitive: Learning ideas and database concepts, database management tools and database applications.
Skills: After the course completion students will have the ability to design and manage Databases. Moreover, they will have the ability to perform specific actions on database management systems and in other helping software tools. In addition, the assignments will help students to gain additional knowledge and solve practical problems.
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
11-10-2020
