ΥΠ16 - Databases

General Information

School: Digital Technology

Department: Informatics and Telematics

Level: Undergraduate

Course Title: Databases

Course id: ΥΠ16

Type: Core Course 

Semester: 4

Teaching and Examination Language: Greek

Is the course offered in Erasmus: Yes

Course web-page: http://eclass.hua.gr/courses/DIT105/

Activities

Lectures (Theory): 2,5

Lab lectures: 1,5

ECTS credits: 7,0

Learning Outcomes

The aim of the course is to assist students understand the basic concepts of Database Management Systems (DBMS) and become familiar with the process of creating a database. Students will understand the need for constraints and how the database constraints affect the modification of data in the database. Finally, students will become familiar with basic SQL commands through their application in a real DBMS. At the end of the course the students must be able to:
- Understand the role of constraints in database creation and updates
- Use SQL in real database environment

General Skills

- Adaptation in new conditions
- Independent work
- Team work

Course Content

The Database Environment. Database Development Process. The Entity-Relationship (E-R) Model. Logical Database Design and the Relational Database Model. Integrity constraints. Transformation of the E-R diagram to a Relational DB Schema. Database Update. Database Management Languages. Relational Algebra. Relational calculus. SQL as a data management language: queries, views, updates. Introduction to the DB file management and indexing structures.

Learning and Teaching Methods - Evaluation

Teaching methods: - face-to-face (lectures & lab)
- Hands-on exercises
- Assignments

Use of ICT: 

- Use of database software
- Custom software for individual exercises in SQL
- Dissemination and organization of course material using OpenClass
- Communication via OpenClass and emails
- The course is available as open course in opencourses.gr

Course Organization

Assessment

The course grade takes into account
- the final exam grade (60%), which comprises
      - Multiple choice questions
      - Problem solving
      - Critical evaluation of theoretical knowledge
- two or three compulsory assignments (40%), which are group and/or individual.

Literature

- R. Elmasri S. B. Navathe, “Fundamentals of Database Systems”, Addison Wesley. 2005.
- H. Garcia Mollina, J.Ullman, J.Widom, “A First Course in Database Systems”, Prentice Hall. 2008.
- R. Ramakrishnan, J. Gehrke. “Database Management Systems”, 2nd Edition. McGraw Hill, 2000.

Journals
- VLDB Journal, ACM
- Transactions on Database Systems (TODS), ACM
- Transactions on Knowledge and Data Enginering (TKDE), ACM
- Data and Knowledge Engineering Journal (DKE), Elsevier.
- International Journal of Big Data Intelligence, Inderscience.

Conferences
- ACM SIGMOD
- ACM VLDB
- IEEE ICDE
- EDBT/ICDT
- ACM PODS