{"id":37,"date":"2023-11-28T22:48:32","date_gmt":"2023-11-28T22:48:32","guid":{"rendered":"http:\/\/vargas-solar.com\/db-fundaments\/?page_id=37"},"modified":"2024-01-17T04:14:34","modified_gmt":"2024-01-17T04:14:34","slug":"activity-5-designing-a-database-application-19-01-2024","status":"publish","type":"page","link":"http:\/\/vargas-solar.com\/db-fundaments\/activity-5-designing-a-database-application-19-01-2024\/","title":{"rendered":"Activity 5: Designing a database application 19\/01\/2024"},"content":{"rendered":"\n<p><strong><em>Objective: <\/em><\/strong><em>The research question to answer is which are the technical considerations to build a database application by interacting with the DBMS? Which are the aspects delegated to the application and those externalised to the DBMS?<\/em><\/p>\n\n\n\n<p><strong><em>Theory background [<a href=\"https:\/\/drive.google.com\/file\/d\/18-sqDZW9zZppZ6NrI77EP-sFqzePADFz\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\">PDF<\/a>]\u00a0<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Host language<\/li><li>Impedance mismatch<\/li><li>JDBC\/ODBC&nbsp;<\/li><li>Externalisation to the cloud and architectural considerations<\/li><\/ul>\n\n\n\n<p><strong><em>ToDo<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Implement a module for connecting to your database in the DBMS and start your database application showing the main menu<\/li><li>Implement the menus for each user type with the given options according to his\/her access and operation grants connect them to the modules that you already have implemented in activities 3 and 4.<\/li><li>Define testing scenarios for users with CRUD operations according to their type<\/li><li>Prepare a video explaining the functions and guarantees ensured by your application<\/li><li>Prepare the documents: architectural, technical specification, installation instructions including the definition of the DB, population, queries, and application<\/li><\/ul>\n\n\n\n<p><strong><em>Deliverables:<\/em><\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Testing scenarios (code and video\/demo) &#8211; 26\/01\/2024<\/li><li>Architectural, technical specification, installation instructions including the definition of the DB, population, queries, and application&nbsp; (document\/readme) 26\/01\/2024<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Objective: The research question to answer is which are the technical considerations to build a database application by interacting with the DBMS? Which are the aspects delegated to the application and those externalised to the DBMS? Theory background [PDF]&nbsp; Host &hellip; <a href=\"http:\/\/vargas-solar.com\/db-fundaments\/activity-5-designing-a-database-application-19-01-2024\/\">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-37","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/pages\/37","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=37"}],"version-history":[{"count":3,"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/pages\/37\/revisions"}],"predecessor-version":[{"id":116,"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/pages\/37\/revisions\/116"}],"wp:attachment":[{"href":"http:\/\/vargas-solar.com\/db-fundaments\/wp-json\/wp\/v2\/media?parent=37"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}