{"id":1583,"date":"2024-07-25T18:37:12","date_gmt":"2024-07-25T15:37:12","guid":{"rendered":"https:\/\/www.iem.ihu.gr\/?post_type=course&p=1583"},"modified":"2025-10-03T07:34:07","modified_gmt":"2025-10-03T04:34:07","slug":"54","status":"publish","type":"course","link":"https:\/\/www.iem.ihu.gr\/en\/courses\/54\/","title":{"rendered":"Database Systems and Data Structures"},"author":5,"template":"","meta":{"_acf_changed":false},"semester":[38],"course_type":[58],"class_list":["post-1583","course","type-course","status-publish","hentry","semester-38","course_type-core"],"acf":{"code":"54","semester":38,"level":"1","teaching_activities":{"activity_1":{"description":"Theory","weekly_hrs":2,"ects":5},"activity_2":{"description":"Exercises","weekly_hrs":1,"ects":""},"activity_3":{"description":"Lab","weekly_hrs":1,"ects":""},"activity_4":{"description":"","weekly_hrs":"","ects":""},"activity_5":{"description":"","weekly_hrs":"","ects":""}},"type":58,"language":"\u0395\u03bb\u03bb\u03b7\u03bd\u03b9\u03ba\u03ac","erasmus":"\u038c\u03c7\u03b9","url":"https:\/\/exams-sm.the.ihu.gr\/enrol\/index.php?id=47","prerequisites":"","instructors":[2063],"coordinator":"","content":"Theory:\r\n1. Introduction to Database Systems\r\n2. Introduction to Data Structures\r\n3. Relational Database \u2013 Data Modelling\r\n4. Database Entities and Data Structures\r\n5. Database Constraints\r\n6. Database Design Diagram\r\n7. Introduction to SQL (Structured Query Language) a standardized programming language\r\n8. Complex SQL queries\r\n9. Database indexes, Database Views, Query optimization,\r\n10. Non-relational Databases (NoSQL databases)\r\n11. Big Data management\r\n12. Information retrieval and Data Mining\r\n13. Databases Management Systems \u2013 Database Security\r\nLab:\r\n1. Introduction to database management tools and technologies\r\n2. Access database management system\r\n3. Hands-on for building a relational database\r\n4. Data entry in database systems\r\n5. Creating simple and complex queries\r\n6. Manipulating data using sql queries","goals":"KNOWLEDGE\r\nIntroduction to Database Systems and Data Structures\r\nAssessment of database architectures and their use in ICT applications\r\nDatabase Entities and Database Schema Design\r\nRelational databases and Entity Relationship Diagram Design\r\nIntroduction to the SQL programming language\r\nIdentification of the basic user roles in modern Database Systems\r\nData and Information\r\nABILITIES\r\nAnalysis, design and implementation of Database Systems\r\nDesigning and implementing Entity Relationship Diagram models\r\nAssessment database architectures\r\nUsing data structures in databases","skills":"Search, analysis and synthesis of data and information, using corresponding technologies, Adaptation to new situations, Independent work, Teamwork \u2013 distribution of responsibilities.","teaching_methods":"Lectures, Exercises, Online guidance, Projected Presentations, E-mail communication, Online Synchronous and Asynchronous Teaching Platform (moodle).","students_evaluation":"Assessment Language: English \/ Greek\r\nTheory (70%)\r\nPublic Presentations\r\nPractical mid-term examination\r\nFinal Written Examinations\r\nLab (30%)\r\nPublic Presentations\r\nFinal Examinations\r\nEvaluation criteria:\r\n- Ability to Design and Implement Relational Databases\r\n- Ability to program in SQL\r\n- Ability to design a database\r\n- Skills for managing databases\r\n- Skills for Assignment Preparation and Presentation","bib_textbooks":"Modern Database Management Hardcover by Jeffrey A. Hoffer (Author), V. Ramesh (Author), Heikki Topi ISBN: 978-960-418-502-3\r\nDatabase Management Systems, 3rd Edition Raghu Ramakrishnan (Author), Johannes Gehrke (Author) ISBN: 978-960-418-411-8","bib_journals":""},"_links":{"self":[{"href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/course\/1583","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/course"}],"about":[{"href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/types\/course"}],"author":[{"embeddable":true,"href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/users\/5"}],"version-history":[{"count":10,"href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/course\/1583\/revisions"}],"predecessor-version":[{"id":4510,"href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/course\/1583\/revisions\/4510"}],"acf:post":[{"embeddable":true,"href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/staff\/2063"}],"acf:term":[{"embeddable":true,"taxonomy":"course_type","href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/course_type\/58"},{"embeddable":true,"taxonomy":"semester","href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/semester\/38"}],"wp:attachment":[{"href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/media?parent=1583"}],"wp:term":[{"taxonomy":"semester","embeddable":true,"href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/semester?post=1583"},{"taxonomy":"course_type","embeddable":true,"href":"https:\/\/www.iem.ihu.gr\/en\/wp-json\/wp\/v2\/course_type?post=1583"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}