ΥΠ16 - Databases

Information

Code : ΥΠ16

Type : Obligatory

Semester : 4

ECTS credits: 6

Course URL: http://eclass.hua.gr/courses/DIT105/

Expected 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

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.

Evaluation Means

I. Written final exam 60% which includes:
-Multiple choice questions
-Problem solving
-Comparative evaluation of theory elements
II. Individual or Group Assignments 40%

Bibliοgraphy

- 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.

ACM Transactions on Database Systems (TODS)
IEEE Transactions on Knowledge and Data Engineering (TKDE)
VLDB Journal (Very Large Data Bases Journal)
Information Systems Journal