Design and Use of Database Systems

Semester:
4ο
Course Type:
Compulsory courses (YM)
Track:
-
Code:
Κ29
ECTS:
7
TEACHING HOURS per week
Theory:
3
Seminar:
1
Laboratory:
1
Specializations
Foundations of Computer Science (Ε1):
-
Data and Knowledge Management (Ε2):
-
Software (Ε3):
-
Hardware and Architecture (Ε4):
-
Communications and Networking (Ε5):
-
Signal and Information Processing (Ε6):
-
Related Courses
Course Content

The course covers the upper levels of a database management system (DBMS), i.e. the conceptual and external or view levels. Specifically, the course provides students with an overview of databases; database history; the different conceptual models used to design a database, in particular the Entity-Relationship (E-R) model; the translation from the E-R to the Relational Model; Functional Dependencies and Normalization; the Relational Model; the Structured Query Language (SQL) to access and manipulate databases, the Query-By-Example language (QBE), Views and Constraints; Relational Algebra; the design and development of web applications to interface with databases using e.g., python, PHP, JDBC.

LITERATURE AND STUDY MATERIALS - READING LIST

Basic Book
Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th Edition). Pearson. Edited and translated in Greek by Prof. M. Chatzopoulos.


Ullman, J. D., & Widom, J. (2007). A First Course in Database Systems (2nd ed.). Prentice Hall. Translated in Greek.
Notes, presentations, tutorials on programming and tools are provided on e-class.