| Title | ΒΑΣΕΙΣ ΔΕΔΟΜΕΝΩΝ / DATABASES |
| Code | NCO-05-03 |
| Faculty | Sciences |
| School | Informatics |
| Cycle / Level | 1st / Undergraduate, 2nd / Postgraduate |
| Teaching Period | Winter |
| Coordinator | Anastasios Gounaris |
| Common | No |
| Status | Active |
| Course ID | 40002945 |
Programme of Study: PPS-Tmīma Plīroforikīs (2019-sīmera)
Registered students: 43
| Orientation | Attendance Type | Semester | Year | ECTS |
|---|---|---|---|---|
| GENIKĪ KATEUTHYNSĪ | Compulsory Course | 5 | 3 | 7 |
| Academic Year | 2017 – 2018 |
| Class Period | Winter |
| Faculty Instructors |
|
| Weekly Hours | 6 |
| Class ID | 600104629
|
Class Schedule
| Building | Βιολογίας |
| Floor | Ισόγειο |
| Hall | ΑΙΘΟΥΣΑ Β (210) |
| Calendar | Τρίτη 09:00 έως 11:00 |
| Building | Βιολογίας |
| Floor | Ισόγειο |
| Hall | PCLAB (489) |
| Calendar | Τετάρτη 09:00 έως 14:00 |
| Building | Βιολογίας |
| Floor | Ισόγειο |
| Hall | ΑΙΘΟΥΣΑ Β (210) |
| Calendar | Πέμπτη 09:00 έως 11:00 |
Course Type 2016-2020
- Background
- 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/600104629
- At the Website of the School: http://delab.csd.auth.gr/courses/c_db/
Erasmus
The course is also offered to exchange programme students.
Language of Instruction
- Greek (Instruction, Examination)
Prerequisites
General Prerequisites
There are no prerequisite courses in the formal sense. Students should master topics related to Programming, Data Structures, Algorithms
Learning Outcomes
Understanding of the concept of massive data management (using secondary memory). Knowledge of designing applications with massive data. Mastering SQL. Acquaintance of MS SQL Server to design, implement, define and manipulate a database.
General Competences
- Apply knowledge in practice
- Make decisions
- Work autonomously
Course Content (Syllabus)
Introduction. Storage media. System architecture. Entity-relationship model. Relational model. Relational algebra and relational calculus. Functional and multivalued dependencies. Normalization and Normal forms. SQL language. Mandatory lab exercises with MS SQL Server.
Keywords
ER model. Relational model. Relational algebra. Dependencies and normalization. SQL.
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 | 52 | ✓ | |||
| Laboratory Work | 26 | ✓ | |||
| Project | 45 | ✓ | |||
| Exams | 6 | ✓ | |||
| Literature study | 81 | ✓ | |||
| Total | 210 |
Student Assessment
Description
Written exams (70%) and Lab exams (30%)
Student Assessment methods
- Written Exam with Short Answer Questions (Formative, Summative)
- Written Exam with Problem Solving (Formative, Summative)
Bibliography
Course Bibliography (Eudoxus)
Ιωάννης Μανωλόπουλος και Απόστολος Παπαδόπουλος: "Βάσεις Δεδομένων: Θεωρία και Πρακτική Εφαρμογή", Εκδόσεις Νέων Τεχνολογιών, Αθήνα, 2006.
Additional bibliography for study
- 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
08-06-2016