EPL342: Databases
by Demetris Zeinalipour
Department of Computer Science
University of Cyprus

Quick Links

CS Courses

EPL342 Syllabus Schedule Exercises Laboratory Recitations Group Project Links Books ColloquiumT.A.


Instructor: Demetris Zeinalipour
(Email: dzeina@, Tel: 22-892755, Office Hours: Tue/Fri 9:30-10:30, Room: B106, New Campus, UCY)
Type:Upper-division Undergraduate (Compulsory Course for All Directions in CS)
When: Tuesdays/Fridays, 15:00-16:30
Where: ΧΩΔ001-#109, Pure and Applied Sciences, New Campus, University of Cyprus (map)
Overview: The main objective of this undergraduate course is to provide an in-depth understanding of concepts related to the design and utilization of a database management system. Students will get a deeper understanding byimplementing these concepts in a commercial database management system. The course is organized in four parts: i) Introduction and Conceptual Modeling using the ER Model, ii) Relational Model and Relational Algebra, iii) Structured Query Language III, and iv) Database Design Theory and Methodology

Outline: Introduction: Databases and Database Users, Database System Concepts and Architecture, Data Modeling Using the Entity-Relationship (ER) Model, The Enhanced Entity-Relationship (EER) Model, The Relational Data Model and Relational Database Constraints, Relational Algebra, Relational Database Design by ERand EER-to-Relational Mapping, SQL-99: Schema Definition, Constraints, Queries, and Views, Introduction to SQL Programming Techniques, Functional Dependencies and Normalization for Relational Databases, Relational Database Design Algorithms and Further Dependencies, Practical Database Design Methodology.

Textbook: Fundamentals of Database Systems, 5/E, Ramez Elmasri and Shamkant B. Navathe, ISBN-10: 0321369572, ISBN-13:  9780321369574, Publisher:  Addison-Wesley, 1168 pp, 2007.

Or Greek Translation:

Θεμελιώδεις Αρχές Συστημάτων Βάσεων Δεδομένων - 5η έκδοση (1ος τόμος), γραμμένο από τους Ramez Elmasri και Sham B. Navathe (μετάφραση Μιχάλης Χατζόπουλος), Εκδόσεις Δίαυλος,  σελίδες 784, ISBN: 9789605312190, 2007.
Wednesdays, 13:30-15:00, ΧΩΔ-001 #109
Laboratory:Thursdays, 1 hour between 08:00-12:00 (please check your registration), ΘΕΕ01-Β121
Teaching Assistants: Christoforos Panagiotou (Recitation/Project Coordinator)
panchris@cs, Tel: 22-892753, Office Hours: Wednesdays 11:00-13:00, Room: B104, New Campus, UCY)
Panayiotis Andreou (Lab Coordinator)
panic@cs, Tel: 22-892674, Office Hours:  Thursdays 12:00-14:00, Room: 208, New Campus, UCY)
Pavlos Antoniou (Grading Coordinator)
(Email: paul.antoniou
@cs, Tel: 22-892747, Office Hours: Mondays 16:00-18:00, Room: B111 or B176 (ΘΕΕ02), New Campus, UCY)


  • Photos from the 2010 EPL342 DB Competition have now been posted!
  • AS4 has been posted!
  • Final Exam: 10/12/2010, 8:30-11:30, XWD001 #107 and #108
  • AS3 has been posted!
  • Midterm: 2/11/2010 15:00-16:30, XWD001 #109 and #110
  • AS2 has been posted!
  • Term Project  has been posted!
  • AS1 has been posted!
  • Welcome to EPL342!
  • 2009 EPL342 DB competion winners are  posted here!
  • Two teams of last year's DB-II course (EPL446) ranked 9th and 10th in the premier database competition worldwide (i.e., ACM SIGMOD Programming Contest 2010)!

Important Notices

  • Check this section regularly for additions and changes.
  • The material will be finalized prior to each respective lecture.
  • To view all resources you need to logon to Moodle.


Copyright © Department of Computer Science, University of Cyprus