https://teaching.healthtech.dtu.dk:443/22112/index.php?action=history&feed=atom&title=Databases 2026-06-10T23:48:56Z Revision history for this page on the wiki MediaWiki 1.41.0 https://teaching.healthtech.dtu.dk:443/22112/index.php?title=Databases&diff=95&oldid=prev 2025-08-05T09:31:43Z

<p><span dir="auto"><span class="autocomment">Exercises</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:31, 5 August 2025</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l19">Line 19:</td> <td colspan="2" class="diff-lineno">Line 19:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>--&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>--&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;1) Logging in to a server&#039;&#039;&#039;&lt;br&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;1) Logging in to a server&#039;&#039;&#039;&lt;br&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>In the course we will change between using our personal laptop<del style="font-weight: bold; text-decoration: none;">, Computerome, </del>and the student server: pupil1.healthtech.dtu.dk&lt;br&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>In the course we will change between using our personal laptop and the student server: pupil1.healthtech.dtu.dk&lt;br&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In the database exercises we use &#039;&#039;pupil1&#039;&#039;. Log into &#039;&#039;pupil1&#039;&#039;:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>In the database exercises we use &#039;&#039;pupil1&#039;&#039;. Log into &#039;&#039;pupil1&#039;&#039;:</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  ssh -X s123456@pupil1.healthtech.dtu.dk</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>  ssh -X s123456@pupil1.healthtech.dtu.dk</div></td></tr> </table>

WikiSysop https://teaching.healthtech.dtu.dk:443/22112/index.php?title=Databases&diff=42&oldid=prev 2024-06-17T09:21:18Z

<p><span dir="auto"><span class="autocomment">Material for the lesson</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:21, 17 June 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6">Line 6:</td> <td colspan="2" class="diff-lineno">Line 6:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=e3896ea1-ad2c-4815-b9e7-af2701265ff6 Introduction to databases]&lt;br&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=e3896ea1-ad2c-4815-b9e7-af2701265ff6 Introduction to databases]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=a5a3d669-f11c-4e8a-b3ed-af2701263593 How to design a relational database]&lt;br&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=a5a3d669-f11c-4e8a-b3ed-af2701263593 How to design a relational database]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/22112/<del style="font-weight: bold; text-decoration: none;">22112-01</del>-Database.ppt Databases]&lt;br&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/22112/<ins style="font-weight: bold; text-decoration: none;">22112_01</ins>-Database.ppt Databases]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=37bd2458-4367-4e87-803f-af17006f5c14 Computer Communication, file transfer, terminal]&lt;br&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=37bd2458-4367-4e87-803f-af17006f5c14 Computer Communication, file transfer, terminal]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/22112/<del style="font-weight: bold; text-decoration: none;">22112-01</del>-Communication.ppt Communication]&lt;br&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/22112/<ins style="font-weight: bold; text-decoration: none;">22112_01</ins>-Communication.ppt Communication]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;!-- PDF: [https://teaching.healthtech.dtu.dk/material/22112/MysqlComputerome.pdf Using MySQL on Computerome] This only needed when accessing a database from Computerome.&lt;br --&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;!-- PDF: [https://teaching.healthtech.dtu.dk/material/22112/MysqlComputerome.pdf Using MySQL on Computerome] This only needed when accessing a database from Computerome.&lt;br --&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=b8500c9f-d31e-48d4-bc68-af170071f219 Exercises]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=b8500c9f-d31e-48d4-bc68-af170071f219 Exercises]</div></td></tr> </table>

WikiSysop https://teaching.healthtech.dtu.dk:443/22112/index.php?title=Databases&diff=41&oldid=prev 2024-06-17T09:20:35Z

<p><span dir="auto"><span class="autocomment">Material for the lesson</span></span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:20, 17 June 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6">Line 6:</td> <td colspan="2" class="diff-lineno">Line 6:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=e3896ea1-ad2c-4815-b9e7-af2701265ff6 Introduction to databases]&lt;br&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=e3896ea1-ad2c-4815-b9e7-af2701265ff6 Introduction to databases]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=a5a3d669-f11c-4e8a-b3ed-af2701263593 How to design a relational database]&lt;br&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=a5a3d669-f11c-4e8a-b3ed-af2701263593 How to design a relational database]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/<del style="font-weight: bold; text-decoration: none;">36612</del>/<del style="font-weight: bold; text-decoration: none;">HPCLife11</del>-Database.ppt Databases]&lt;br&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/<ins style="font-weight: bold; text-decoration: none;">22112</ins>/<ins style="font-weight: bold; text-decoration: none;">22112-01</ins>-Database.ppt Databases]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=37bd2458-4367-4e87-803f-af17006f5c14 Computer Communication, file transfer, terminal]&lt;br&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=37bd2458-4367-4e87-803f-af17006f5c14 Computer Communication, file transfer, terminal]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/22112/<del style="font-weight: bold; text-decoration: none;">HPCLife01</del>-Communication.ppt Communication]&lt;br&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/22112/<ins style="font-weight: bold; text-decoration: none;">22112-01</ins>-Communication.ppt Communication]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;!-- PDF: [https://teaching.healthtech.dtu.dk/material/22112/MysqlComputerome.pdf Using MySQL on Computerome] This only needed when accessing a database from Computerome.&lt;br --&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;!-- PDF: [https://teaching.healthtech.dtu.dk/material/22112/MysqlComputerome.pdf Using MySQL on Computerome] This only needed when accessing a database from Computerome.&lt;br --&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=b8500c9f-d31e-48d4-bc68-af170071f219 Exercises]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=b8500c9f-d31e-48d4-bc68-af170071f219 Exercises]</div></td></tr> </table>

WikiSysop https://teaching.healthtech.dtu.dk:443/22112/index.php?title=Databases&diff=10&oldid=prev 2024-03-06T10:48:14Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 12:48, 6 March 2024</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l8">Line 8:</td> <td colspan="2" class="diff-lineno">Line 8:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/36612/HPCLife11-Database.ppt Databases]&lt;br&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/36612/HPCLife11-Database.ppt Databases]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=37bd2458-4367-4e87-803f-af17006f5c14 Computer Communication, file transfer, terminal]&lt;br&gt;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=37bd2458-4367-4e87-803f-af17006f5c14 Computer Communication, file transfer, terminal]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/<del style="font-weight: bold; text-decoration: none;">36612</del>/HPCLife01-Communication.ppt Communication]&lt;br&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Powerpoint: [https://teaching.healthtech.dtu.dk/material/<ins style="font-weight: bold; text-decoration: none;">22112</ins>/HPCLife01-Communication.ppt Communication]&lt;br&gt;</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&lt;!-- PDF: [https://teaching.healthtech.dtu.dk/material/<del style="font-weight: bold; text-decoration: none;">36612</del>/MysqlComputerome.pdf Using MySQL on Computerome] This only needed when accessing a database from Computerome.&lt;br --&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&lt;!-- PDF: [https://teaching.healthtech.dtu.dk/material/<ins style="font-weight: bold; text-decoration: none;">22112</ins>/MysqlComputerome.pdf Using MySQL on Computerome] This only needed when accessing a database from Computerome.&lt;br --&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=b8500c9f-d31e-48d4-bc68-af170071f219 Exercises]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=b8500c9f-d31e-48d4-bc68-af170071f219 Exercises]</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> </table>

WikiSysop https://teaching.healthtech.dtu.dk:443/22112/index.php?title=Databases&diff=9&oldid=prev 2024-03-06T10:46:12Z

<p>Created page with &quot;{| width=500 style=&quot;float:right; margin-left: 10px; margin-top: -56px;&quot; |Previous: [https://teaching.healthtech.dtu.dk/22112/index.php/22112_High_Performance_Computing_in_Life_Science Main page] |Next: <a href="/22112/index.php/MySQL" title="MySQL">MySQL</a> |} == Material for the lesson == Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=e3896ea1-ad2c-4815-b9e7-af2701265ff6 Introduction to databases]&lt;br&gt; Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=a5a3d669-f11c-4e8a-b3ed-af2701263593 How...&quot;</p> <p><b>New page</b></p><div>{| width=500 style=&quot;float:right; margin-left: 10px; margin-top: -56px;&quot;<br /> |Previous: [https://teaching.healthtech.dtu.dk/22112/index.php/22112_High_Performance_Computing_in_Life_Science Main page]<br /> |Next: [[MySQL]]<br /> |}<br /> == Material for the lesson ==<br /> Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=e3896ea1-ad2c-4815-b9e7-af2701265ff6 Introduction to databases]&lt;br&gt;<br /> Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=a5a3d669-f11c-4e8a-b3ed-af2701263593 How to design a relational database]&lt;br&gt;<br /> Powerpoint: [https://teaching.healthtech.dtu.dk/material/36612/HPCLife11-Database.ppt Databases]&lt;br&gt;<br /> Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=37bd2458-4367-4e87-803f-af17006f5c14 Computer Communication, file transfer, terminal]&lt;br&gt;<br /> Powerpoint: [https://teaching.healthtech.dtu.dk/material/36612/HPCLife01-Communication.ppt Communication]&lt;br&gt;<br /> &lt;!-- PDF: [https://teaching.healthtech.dtu.dk/material/36612/MysqlComputerome.pdf Using MySQL on Computerome] This only needed when accessing a database from Computerome.&lt;br --&gt;<br /> Video: [https://panopto.dtu.dk/Panopto/Pages/Viewer.aspx?id=b8500c9f-d31e-48d4-bc68-af170071f219 Exercises]<br /> <br /> == Exercises ==<br /> &lt;!--<br /> &#039;&#039;&#039;1)&#039;&#039;&#039; Follow the instructions in the ’MysqlComputerome.pdf’ and make sure you can do password-less login from computerome to login.cbs.dtu.dk.&lt;br&gt;<br /> Once that is achieved, use the &#039;&#039;&#039;mysqltunnel.pl&#039;&#039;&#039; in the file repository, and run the ’mysql’ command as described. Do ’show databases;’ for fun or just ’quit’.<br /> This is mainly proof of concept and will be used next time.<br /> --&gt;<br /> &#039;&#039;&#039;1) Logging in to a server&#039;&#039;&#039;&lt;br&gt;<br /> In the course we will change between using our personal laptop, Computerome, and the student server: pupil1.healthtech.dtu.dk&lt;br&gt;<br /> In the database exercises we use &#039;&#039;pupil1&#039;&#039;. Log into &#039;&#039;pupil1&#039;&#039;:<br /> ssh -X s123456@pupil1.healthtech.dtu.dk<br /> Remember to replace s123456 with your s-number or DTU username<br /> Use your DTU password when asked - no chars will be displayed when writing the password<br /> You will then be asked to enter the MFA code you set up with DTU mail.<br /> The &#039;&#039;&#039;-X&#039;&#039;&#039; means you can use X on unix which may only be relevant for you if you run a X-server on your own computer.&lt;br&gt;<br /> &lt;!--<br /> You will immediately be asked to set up 2-factor authentication. Failure to do so at that point is &#039;&#039;&#039;failing the course&#039;&#039;&#039;, because you can not log in anymore if you do not read and follow the instructions.&lt;br&gt;<br /> You need an app on your smartphone for this: Authy, Google Authenticator, FreeOTP are examples of such an app. --&gt;<br /> <br /> Run the ’mysql’ command as described in the powerpoint. Do ’show databases;’ for fun or just ’quit’. <br /> <br /> The text editors available on &#039;&#039;pupil1&#039;&#039; are:<br /> geany X11-based<br /> gedit X11-based<br /> jedit X11-based<br /> nano text-based<br /> vim text-based<br /> This entire exercise is just proof of concept and will make you ready for next week.<br /> <br /> &#039;&#039;&#039;2) Design your own relational database&#039;&#039;&#039;&lt;br&gt;<br /> Design what tables you should use. That includes the names of the fields and the types of the fields. Which fields are primary keys and which are foreign keys. How the tables relate to each other. No programming is involved.<br /> <br /> Your database/tables must be able to model this scenario:&lt;br&gt;<br /> Model people. People get married and divorced. People have kids, not necessarily with their spouses. People get sick with zero or more diseases. The diseases start a a given time. You must be able to keep track of their diseases, so it is possible to track heritable diseases. You can obviously be sick from the same disease more than once.<br /> <br /> Think about the reality - described in above two lines - that you must model.<br /> <br /> Just to be nice, I will not throw polygamy, homosexual marriages, group marriages or 2D marriages into the model. You can also assume that every disease can be identified and is not just a bunch of symptoms.<br /> <br /> &#039;&#039;&#039;3) Change the database model&#039;&#039;&#039;&lt;br&gt;<br /> Let us be modern and creative so people can marry in other ways than just single male to single female - follow the times...&lt;br&gt;<br /> Also, people actually die. Put that fact into the model. Explain what constraints that will put on your data?&lt;br&gt;<br /> Here is an example of what I mean by constraints: Joe and Jane are married. Joe dies. Who is Jane married to?&lt;br&gt;<br /> The database must be able to reflect and contain this kind of changes.</div>

WikiSysop