Zeinalipour > Courses > EPL342

EPL342: Databases

Instructor: Demetris Zeinalipour »
Type: Upper-division Undergraduate (Compulsory)
Prerequisite: EPL231 - Data Structures and Algorithms (or equivalent)
When: Tuesday and Friday, 09:00 – 10:15, ΧΩΔ01-#108
Recitation: Friday, 08:10 – 09:00, ΧΩΔ01-#108
Laboratory: Monday, 12:00-18:00 (physical 1 1/2 hours each / check your Banner slot) in ΘΕΕ01-B121
Teaching Assistant: Christoforos Panayiotou »

Podcast » AI Assistant »

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

Content

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.

Syllabus (in greek) »

News

  • AI Assistant EPL342 Artificial Intelligence Assistant (AIA) is available. AIA can help you with more personalized Q/A over course slides, laboratory and assignments, besides regular help by your instructors. You require a Google account to use it
  • Competition (ends January 10, 2025) Future of Database Programming Contest. Please sign up and participate!
  • Competition (ended) EPL342 Group project winners have been announced on the competitions website. Congrats to all teams!
  • AS4 Functional Dependencies and Normal Forms assignment (self-evaluation) has been posted (solutions to be posted on Moodle)!
  • PROJECT evaluation to be carried out in-lab. Please check the slot with Christophoros Panayiotou !
  • Final scheduled for Wednesday, December 11, 2024. Time: 12:30-15:30 in ΧΩΔ02-B205.
  • AS3 SQL assignment to be carried out as a QUIZ (Monday 18/11, 19:30-21:00, Room ΧΩΔ02-B210).
  • AS2 Relational Model and Relational Algebra assignment has been posted!
  • AS1 Conceptual Modeling with ER diagrams has been posted.
  • Term Project has been posted.
  • Midterm scheduled for Tuesday, October 29, 2024. Time: 09:00-10:15 in ΧΩΔ01-108. Please be there 8:40 to be seated.
  • DMSL Please visit the Data Management Systems Laboratory (DMSL) to acquiant yourself with our research!
  • ACM SIGMOD Contest this programming contest is the premier world-wide competition in DBs co-organized by MIT. The highest rankings of UCY students in the contest over the years are as follows:
    • 2015: ranked 5th (Topic: Concurrent Transaction Processing and Validation System). Congrats to Lambros Petrou, George Koummeto and Marios Mintzis
    • 2014: ranked 9th (Topic: Social Network Analysis System). Congrats to Lambros Petrou, Marios Mintzis and George Koummeto.
    • 2013: ranked 10th (Topic: Parallel Document Matching with TRIES). Congrats to Lambros Petrou, George Koummetou, George Larkou.
    • 2011: ranked 6th (Topic: A Durable Main-Memory Index Using Flash). Congrats to George Constantinou, Marios Constantinides and Silouanos Nicolaou.
    • 2010: ranked 9th (Topic: Distributed Query Engine). Congrats to Fotos Fragkoudis, Andriani Stylianou, Onisiforos Onisiforou.
  • Welcome to EPL342! Please sign up to our course management platform to access the course forum and assignment submission portal.

Schedule »

Laboratory »

Assignments

AS1 | Entity-Relationship Model | Due: W5 | PDF

AS2 | Relational Model and Algebra | Due: W7 | PDF

AS3 | Structured Query Language (SQL) | Due. W12

AS4 | Functional Dependencies and Normal Forms | AS4

PROJECT | EVManager Application Management Platform: | Phase 1: W6 | Phase 2: W13 | PDF | GUIDE

Bibliography