{"id":489,"date":"2023-09-06T09:08:07","date_gmt":"2023-09-06T09:08:07","guid":{"rendered":"https:\/\/w1.aua.gr\/agribusiness\/?post_type=courses&#038;p=489"},"modified":"2025-10-03T09:06:24","modified_gmt":"2025-10-03T09:06:24","slug":"5205-database-management","status":"publish","type":"courses","link":"https:\/\/w1.aua.gr\/agribusiness\/en\/courses\/5205-database-management\/","title":{"rendered":"5205 - Database Management"},"content":{"rendered":"\n<p><strong>The scope of the course is to help students to:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Familiarize with the concepts of Database Technology<\/li>\n\n\n\n<li>understand the usefulness of Database Management Systems (DBMS)<\/li>\n\n\n\n<li>understand the database design rules<\/li>\n\n\n\n<li>understand the operations of Relational Algebra for managing relational data model relationships<\/li>\n\n\n\n<li>understand the SQL commands for creating and managing databases<\/li>\n\n\n\n<li>explore the functioning of DBMSs through problem solving exercises<\/li>\n<\/ul>\n\n\n\n<p><strong>Upon successful completion of the course the student will be able to:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>analyze problems in their basic entities and detect their relationships<\/li>\n\n\n\n<li>design entity-relationships diagrams that meet the requirements of specific applications<\/li>\n\n\n\n<li>convert an entity-relationships diagram to a relational database schema<\/li>\n\n\n\n<li>design a normalized relational database schema<\/li>\n\n\n\n<li>create expressions of Relational Algebra<\/li>\n\n\n\n<li>create SQL commands<\/li>\n\n\n\n<li>implement relational database schemas in a DBMS<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The scope of the course is to help students to: Upon successful completion of [&hellip;]<\/p>\n","protected":false},"featured_media":529,"template":"","semester":[126],"level":[144],"choice":[148],"direction":[248],"lab-theory":[243,245],"class_list":["post-489","courses","type-courses","status-publish","has-post-thumbnail","hentry","semester-2semester-eng","level-undergraduate-eng","choice-compulsory","direction-basic-en","lab-theory-laboratorys","lab-theory-theorys"],"acf":[],"_links":{"self":[{"href":"https:\/\/w1.aua.gr\/agribusiness\/wp-json\/wp\/v2\/courses\/489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w1.aua.gr\/agribusiness\/wp-json\/wp\/v2\/courses"}],"about":[{"href":"https:\/\/w1.aua.gr\/agribusiness\/wp-json\/wp\/v2\/types\/courses"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/w1.aua.gr\/agribusiness\/wp-json\/wp\/v2\/media\/529"}],"wp:attachment":[{"href":"https:\/\/w1.aua.gr\/agribusiness\/wp-json\/wp\/v2\/media?parent=489"}],"wp:term":[{"taxonomy":"semester","embeddable":true,"href":"https:\/\/w1.aua.gr\/agribusiness\/wp-json\/wp\/v2\/semester?post=489"},{"taxonomy":"level","embeddable":true,"href":"https:\/\/w1.aua.gr\/agribusiness\/wp-json\/wp\/v2\/level?post=489"},{"taxonomy":"choice","embeddable":true,"href":"https:\/\/w1.aua.gr\/agribusiness\/wp-json\/wp\/v2\/choice?post=489"},{"taxonomy":"direction","embeddable":true,"href":"https:\/\/w1.aua.gr\/agribusiness\/wp-json\/wp\/v2\/direction?post=489"},{"taxonomy":"lab-theory","embeddable":true,"href":"https:\/\/w1.aua.gr\/agribusiness\/wp-json\/wp\/v2\/lab-theory?post=489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}