{"id":2755,"date":"2023-06-02T10:40:57","date_gmt":"2023-06-02T07:40:57","guid":{"rendered":"https:\/\/www.ba.ihu.gr\/?post_type=course&#038;p=2755"},"modified":"2023-09-30T01:58:38","modified_gmt":"2023-09-29T22:58:38","slug":"203","status":"publish","type":"course","link":"https:\/\/www.ba.ihu.gr\/en\/courses\/203\/","title":{"rendered":"Databases"},"author":6,"template":"","meta":[],"semester":[11],"course_type":[12],"acf":{"code":"203","semester":[11],"level":"1","teaching_activities":{"activity_1":{"description":"Lectures, Laboratory Exercises","weekly_hrs":4,"ects":5},"activity_2":{"description":"","weekly_hrs":"","ects":""},"activity_3":{"description":"","weekly_hrs":"","ects":""},"activity_4":{"description":"","weekly_hrs":"","ects":""},"activity_5":{"description":"","weekly_hrs":"","ects":""}},"type":12,"language":"Greek","erasmus":"\u039d\u03b1\u03b9","url":"https:\/\/elearning.cm.ihu.gr\/course\/view.php?id=117","prerequisites":"","instructors":[1457],"coordinator":"","content":"Basic Concepts, Database Management System and Architecture, Data Models and the Entity-Relationship Diagram, The Relational Model, Converting a DBMS to a Relational Database, Introduction to SQL, Introducing a Database Management System and demonstrating its basic capabilities (creating a database , queries, forms).","goals":"The objectives of of the course are:\r\n<ul>\r\n \t<li>To demonstrate the importance of valid and timely data both in the daily operation of the business and in making business decisions.<\/li>\r\n \t<li>To present the basic concepts of database technology that makes access to data and information possible.<\/li>\r\n \t<li>To present and analyze the basic principles of relational databases.<\/li>\r\n \t<li>Describe and analyze the stages of developing a database, the human resources necessary and tools available for this undertaking.<\/li>\r\n<\/ul>\r\nUpon completion of the course students should be able to:\r\n<ul>\r\n \t<li>Develop Entity-Relationship Diagrams based on descriptions and\/or business documents.<\/li>\r\n \t<li>Recognize the advantages and limitations of design decisions underlying an Entity Relationship Diagram.<\/li>\r\n \t<li>know the basic principles of relational databases.<\/li>\r\n \t<li>Convert Entity-Relationship Models into well-designed relational databases.<\/li>\r\n \t<li>Implement the relational databases they have designed in a DBMS using the SQL language.<\/li>\r\n<\/ul>","skills":"to be filled","teaching_methods":"<ul>\r\n \t<li>Face to faqce.<\/li>\r\n<\/ul>","ict_usage":"<ul>\r\n \t<li>Online guidance.<\/li>\r\n \t<li>Slides Projection in the classroom.<\/li>\r\n \t<li>Use of E-mail and onlne communication systems.<\/li>\r\n \t<li>Use of e-learning system (moodle).<\/li>\r\n<\/ul>","teaching_organization":{"activity_1":{"description":"Lectures","workload":39},"activity_2":{"description":"Practice\/Exercises","workload":13},"activity_3":{"description":"Personal Study","workload":73},"activity_4":{"description":"","workload":""},"activity_5":{"description":"","workload":""},"activity_6":{"description":"","workload":""}},"students_evaluation":"to be filled","bib_textbooks":"","bib_journals":""},"_links":{"self":[{"href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/course\/2755"}],"collection":[{"href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/course"}],"about":[{"href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/types\/course"}],"author":[{"embeddable":true,"href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/users\/6"}],"version-history":[{"count":14,"href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/course\/2755\/revisions"}],"predecessor-version":[{"id":4122,"href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/course\/2755\/revisions\/4122"}],"acf:post":[{"embeddable":true,"href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/staff\/1457"}],"acf:term":[{"embeddable":true,"taxonomy":"course_type","href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/course_type\/12"},{"embeddable":true,"taxonomy":"semester","href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/semester\/11"}],"wp:attachment":[{"href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/media?parent=2755"}],"wp:term":[{"taxonomy":"semester","embeddable":true,"href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/semester?post=2755"},{"taxonomy":"course_type","embeddable":true,"href":"https:\/\/www.ba.ihu.gr\/en\/wp-json\/wp\/v2\/course_type?post=2755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}