AGRICULTURAL
UNIVERSITY OF ATHENS
Department of Agribusiness
& Supply Chain Management

5205 - Database Management

Content

The theoretical part of the course covers the following topics:
  1. Introduction to Databases and Database Management Systems (DBMS)
  2. DBMS Architecture
  3. Relational DBMS and Levels of Abstraction
  4. Entity-Relationship Model
  5. Relational model
  6. Relational Algebra
  7. SQL: Introduction, Standards, Basic commands
  8. SQL: More commands, Functions
  9. Converting Entity-Relationship Diagrams into Relational Database schema
  10. Normalization
  11. Complex Examples (A)
  12. Complex Examples (B)
  13. New Trends in Databases.
  The laboratory part of the course covers the following topics:
  1. Getting acquainted with a software tool for Database Management
  2. Designing Tables, entering/deleting/modifying data
  3. Editing Tables, data types, validation rules
  4. Linking Tables / Creating Relationships
  5. Designing and processing of Queries
  6. Designing and editing Forms
  7. Designing and editing Reports
  8. Creating Macros

Learning results

The scope of the course is to help students to:

  • Familiarize with the concepts of Database Technology
  • understand the usefulness of Database Management Systems (DBMS)
  • understand the database design rules
  • understand the operations of Relational Algebra for managing relational data model relationships
  • understand the SQL commands for creating and managing databases
  • explore the functioning of DBMSs through problem solving exercises

Upon successful completion of the course the student will be able to:

  • analyze problems in their basic entities and detect their relationships
  • design entity-relationships diagrams that meet the requirements of specific applications
  • convert an entity-relationships diagram to a relational database schema
  • design a normalized relational database schema
  • create expressions of Relational Algebra
  • create SQL commands
  • implement relational database schemas in a DBMS

Bibliography

Suggested Bibliography:
  1. Κεχρής E. (2022). Σχεσιακές Βάσεις Δεδομένων, 3η έκδοση, Εκδ. Κριτική.
  2. Database Systems https://repository.kallipos.gr/handle/11419/8413
  3. Εισαγωγή στην SQL https://repository.kallipos.gr/handle/11419/6247
  4. Hoffer, J. Ramesh, V., Topi, H. (2017). Βάσεις Δεδομένων. Σύγχρονη Διαχείριση, 11η έκδοση, Εκδόσεις Τζιόλα.
  5. Μανωλόπουλος, Ι., Παπαδόπουλος, Α.Ν. (2006). Συστήματα βάσεων δεδομένων - Θεωρία και πρακτική εφαρμογή, Εκδόσεις Νέων Τεχνολογιών.
  6. Σκουρλάς Χ. (2000). Σχεσιακές Βάσεις Δεδομένων, 2η έκδοση, Εκδ. Νέων Τεχνολογιών.
  7. Ταμπακάς Β. (2009). Εισαγωγή στις Βάσεις Δεδομένων, Εκδότης Β. Ταμπακάς.
  8. Connolly, T., Begg, C. (2010). Database Systems: A Practical Approach to design, Implementation, and Management, 5th Edition, Addison Wesley.
  9. Date, C.J. (2008). Εισαγωγή στα συστήματα Βάσεων Δεδομένων,Τόμος Α΄και Τόμος Β΄, 6η Έκδοση, Κλειδάριθμος,
  10. Elmasri R., Navathe S. B. (2012). Θεμελιώδεις αρχές συστημάτων βάσεων δεδομένων, 6η έκδοση, Δίαυλος Α.Ε. Εκδόσεις Βιβλίων,
  11. Garcia-Molina, H., Ullman J.D. and Widom, J.D. (2012). Συστήματα βάσεων δεδομένων - Ένα πλήρες εγχειρίδιο, Πανεπιστημιακές Εκδόσεις Κρήτης.
  12. Ramakrishnan R., Gehrke J. (2011). Συστήματα διαχείρισης βάσεων δεδομένων, 3η Έκδοση, Εκδόσεις Α. Τζιόλα & Υιοί Ο.Ε.
  13. Silberschatz, Α., Korth, H.F., Sudarshan, S. (2011). Συστήματα βάσεων δεδομένων - Η πλήρης θεωρία των βάσεων δεδομένων, 6η έκδοση, Εκδ. Γκιούρδας Μ.
  Συναφή επιστημονικά περιοδικά:
  1. International Journal of Database Management Systems (IJDMS)
  2. Journal of Database Management
  3. Database Systems Journal (open access)
  4. ACM Transactions on Database Systems
  5. International Journal of Database Theory and Application

Faculty

2262022569
anompilaki@aua.gr
Lecturer at the Department of Agribusiness and Supply Chain Management, of the AppliedEconomics and […]
2262022569
kofakis@aua.gr
Petros Kofakis is an Assistant Professor at the Department of Agribusiness and Supply Chain […]

NEWSLETTER

The Department was created in 2019 (article 20, Law 4589/2019) and is an evolution of the Supply Systems Management Department (D.S.E.). Housed in a 770 sq.m. building. within a plot with a total area of 8,000 sq.m. in facilities with extensive research and teaching spaces.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram Skip to content