Database Systems

Database Systems, photo: Gerd Altmann

Course ID:

ECO_424

Semester: 8th

Year of Study:

For Erasmus Students: Όχι

Learning Outcomes

After successfully completing the course, students will be able to:
Knowledge:

  • Understand the role and importance of databases in data management issues and in real life applications
  • Define the notion of database and Database Management System (DBMS)
  • Describe the desired characteristics of data
  • Describe conceptual data models and especially the EntityRelationship and Extended Entity-Relationship models
  • Describe the Relational database model and the Relational Database Management Systems
  • Describe the basic steps required to design databases
  • Evaluate the design of databases
  • Identify the concepts and operators that are supported by the SQL language for defining and manipulating data

Skills

  • Design conceptual models based on the description of microcosms
  • Design relational databases based on the conceptual design of microcosms
  • Define the data using the SQL language
  • Retrieve data using the SQL language
  • Use the RBDMSs MS Access and MySQL to design and implement databases

Course Contents

Definition of database and Database Management System (DBMS), Comparing DBMSs to filesystems of Operating Systems, Advantages of DBMSs, Architecture of DBMSs and levels of abstraction, Data models, Methodology of database design and implementation, The Entity-Relationship conceptual model (Entities, Relationships, Constraints), The Extended Entity Relationship conceptual model (Generalization, Specialization and related constraints), The relational model (relation, relation schema, instances/tuples, relational database schema, Domain constraints, Key constraints, Foreign key constraints, General purpose constraints), Logical database design using the relational model, Relational Algebra, The SQL language, The DDL subset of SQL, The DML subset of SQL, Queries in SQL.

Teaching Activities

Lectures (2 hours per week) and Laboratory Exercises (2 hours per week)

Teaching Organization

Activity

Semester workload

Lectures

2X13=26 hours

Lab exercises

2X13=26 hours

Team Project

64 hours

Individual quizzes, assignments and Self-study

34 hours

Total number of hours for the Course (25 hours of work-load per ECTS credit)

150 hours (total student work-load)

Assessment

  1. One Team Project on designing and implementing a database using a RDBMS: 30%
  2. Final exam: 70%

Use of ICT

  • Slides and notes to support lectures
  • Software tools for demonstration and practical application purposes:
    • Diagram editor tools for the design of Entity-Relationship diagrams (MS Vision, Open source DIA, etc.)
    • RDBMS tools for the implementation of database systems (MS Access, OpenOffice base, etc.)
  • Use of the E-Learning platform eclass in order to:
    • Organize the course material (slides, notes, examples, code snippets etc)
    • Perform weekly online quizzes to evaluate the understanding of the related course material
    • Hand in homeworks
    • Communicate with the students and the class

Teaching Hours: 4

ECTS Credits: 6

Teaching Credits: 3

Weight: 1.5

Type:

Language: Ελληνική

Teaching Method: Πρόσωπο με πρόσωπο

General Competences: Αναζήτηση, ανάλυση και σύνθεση δεδομένων και πληροφοριών, με τη χρήση και των απαραίτητων τεχνολογιών, Προσαρμογή σε νέες καταστάσεις, Ομαδική εργασία, Εργασία σε διεπιστημονικό περιβάλλον, Προαγωγή της ελεύθερης, δημιουργικής και επαγωγικής σκέψης

Teaching Staff
Δασκάλου Βικτωρία - ΕΔΙΠ

Γνωστικό Αντικείμενο: Internet Information Systems

Οργανική Μονάδα / Εργαστήριο:

Τηλέφωνο: +30 2610 997788

Ώρες γραφείου: Tuesday 12:30-14:00 Thursday 13:00-14:30

Associate Professor
Μανώλης Τζαγκαράκης

Γνωστικό Αντικείμενο: Information and Knowledge Management

Οργανική Μονάδα / Εργαστήριο:

Τηλέφωνο: +30 2610 962588

Ώρες γραφείου: Mon 10:00 - 12:00 Fri 11:00-12:00

eclass URL: e-class