{"id":101,"date":"2024-01-14T01:03:19","date_gmt":"2024-01-14T01:03:19","guid":{"rendered":"http:\/\/vargas-solar.com\/db-fundaments\/?page_id=101"},"modified":"2024-01-14T03:28:09","modified_gmt":"2024-01-14T03:28:09","slug":"knowledge-control","status":"publish","type":"page","link":"http:\/\/vargas-solar.com\/db-fundaments\/knowledge-control\/","title":{"rendered":"KNOWLEDGE CONTROL"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Fundamental concepts<\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li><em>Background: sets<\/em><\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>Define a set in intention and, in extension, illustrate with an example<\/li><li>Enumerate set operators, draw Venn Diagrams to illustrate their semantics<\/li><li>Define the notion of atomic DOMAIN type<\/li><\/ul>\n\n\n\n<p>2. <em>Relational Model<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Define the notion of RELATION SCHEMA in terms of a set expression. Give an example.<\/li><li>What is an integrity constraint? Enumerate the types of integrity constraints that define the semantics of a relation schema. Complete your previous example.<\/li><li>What is a relation key? What is a primary key?<\/li><li>Define a RELATIONAL DATABASE SCHEMA. Complete your example, including referential constraints.<\/li><\/ul>\n\n\n\n<p><em>3. Relational Database Design<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Define the concepts of Mini-world, Conceptual Model and Data Model<\/li><li>Draw a figure describing a relational database design process from the Mini-world to the Conceptual Model and from the Conceptual Model to a Relational Database Schema using a data model. <\/li><li>What is SQL Data Definition Language? Which are the different languages SQL proposes, and what is their purpose?<\/li><\/ul>\n\n\n\n<p><em>4. Database querying: relational model operators<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Which are the 5 basic operators of the relational algebra? What are the limits of the relational algebra regarding the expression of queries? Draw a Venn Diagram to specify the semantics of the operators.<\/li><li>Explain the notion of closure related to the relational algebra?<\/li><li>What is a query execution plan? What does it mean to use the operators properties for optimising a query?<\/li><li>What is an index and what is its purpose?<\/li><li>Which is the general expression of the SQL language for querying a database?<\/li><\/ul>\n\n\n\n<p><em>5. Execution model<\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Define the notion and purpose of a transaction and its properties? Illustrate the principle of having transactions when managing a relational database.<\/li><li>Which are the states of a transaction?<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Technical concepts<\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>Database Management System (DBMS)<\/li><\/ol>\n\n\n\n<ul class=\"wp-block-list\"><li>What is a DBMS? Draw the ANSI\/SPARC architecture and describe the models associated to it.<\/li><li>What are the guarantees ensured by a relational DBMS?<\/li><\/ul>\n\n\n\n<p>2. Relational Database Application<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>What is a database relational application? What is its general architecture? Draw it.<\/li><li>What is the meaning of ETL and which is the process it denotes?<\/li><li>What are the management operators of a database<\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fundamental concepts Background: sets Define a set in intention and, in extension, illustrate with an example Enumerate set operators, draw Venn Diagrams to illustrate their semantics Define the notion of atomic DOMAIN type 2. Relational Model Define the notion of &hellip; <a href=\"http:\/\/vargas-solar.com\/db-fundaments\/knowledge-control\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":11,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-101","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/pages\/101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/comments?post=101"}],"version-history":[{"count":6,"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/pages\/101\/revisions"}],"predecessor-version":[{"id":107,"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/pages\/101\/revisions\/107"}],"wp:attachment":[{"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/media?parent=101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}