https://userbase.kde.org/index.php?title=Kexi/Handbook/Introduction_to_Databases/What_Is_a_Database%3F/en&feed=atom&action=historyKexi/Handbook/Introduction to Databases/What Is a Database?/en - Revision history2024-03-28T09:09:41ZRevision history for this page on the wikiMediaWiki 1.40.2https://userbase.kde.org/index.php?title=Kexi/Handbook/Introduction_to_Databases/What_Is_a_Database%3F/en&diff=238733&oldid=prevFuzzyBot: Updating to match new version of source page2012-04-07T17:01:26Z<p>Updating to match new version of source page</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 17:01, 7 April 2012</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l22">Line 22:</td>
<td colspan="2" class="diff-lineno">Line 22:</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>
<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>To sum up, you have already got a simple database with one table '''''Contacts'''''.</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>To sum up, you have already got a simple database with one table '''''Contacts'''''.</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></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><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></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><ins style="font-weight: bold; text-decoration: none;">{{Note|1=Check content at [https://www.zoho.com/creator/database-software-vs-spreadsheet.html www.zoho.com/creator/database-software-vs-spreadsheet.html]}}</ins></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>
<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>{{Prevnext2</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>{{Prevnext2</div></td></tr>
</table>FuzzyBothttps://userbase.kde.org/index.php?title=Kexi/Handbook/Introduction_to_Databases/What_Is_a_Database%3F/en&diff=226793&oldid=prevFuzzyBot: Updating to match new version of source page2011-12-18T13:19:27Z<p>Updating to match new version of source page</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 13:19, 18 December 2011</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l5">Line 5:</td>
<td colspan="2" class="diff-lineno">Line 5:</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>
<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>Look at this diagram for one of the above examples: a simple phone book.</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>Look at this diagram for one of the above examples: a simple phone book.</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>----</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>----[[Image:contact-example.png|172px|center]]</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>[[Image:contact-example.png|172px|center]]</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>----The above picture shows a set of two contacts each of which is presented on a separate card. It appears that such a card can constitute a single row in a table: </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>----</div></td><td colspan="2" class="diff-side-added"></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>The above picture shows a set of two contacts each of which is presented on a separate card. It appears that such a card can constitute a single row in a table: </div></td><td colspan="2" class="diff-side-added"></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>
<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>{|class="tablecenter" style="border: 1px solid grey;"</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>{|class="tablecenter" style="border: 1px solid grey;"</div></td></tr>
</table>FuzzyBothttps://userbase.kde.org/index.php?title=Kexi/Handbook/Introduction_to_Databases/What_Is_a_Database%3F/en&diff=226128&oldid=prevFuzzyBot: Updating to match new version of source page2011-12-14T19:46:44Z<p>Updating to match new version of source page</p>
<p><b>New page</b></p><div><languages/><br />
===What Is a Database?===<br />
<br />
You can define a database as a collection of data on one topic. It is organised in a way allowing to easily browse the information, make changes or add new items. <br />
<br />
Look at this diagram for one of the above examples: a simple phone book.<br />
----<br />
[[Image:contact-example.png|172px|center]]<br />
----<br />
The above picture shows a set of two contacts each of which is presented on a separate card. It appears that such a card can constitute a single row in a table: <br />
<br />
{|class="tablecenter" style="border: 1px solid grey;"<br />
|+ ''Contacts table''<br />
! '''Name''' !! '''Tel No.'''<br />
|-<br />
| Joan || 699 23 43 12<br />
|-<br />
| Adam || 711 19 77 21<br />
|}<br />
<br />
Terms and definitions: A single data which constitutes a part of a greater collection can be called a ''row'' or more professionally a ''record''. The collection is normally called a ''table''. Moreover, the most natural name for the table is one describing the data it offers/stores which is Contacts. Furthermore, each row in the table consists of columns often also called ''fields''. In the table '''''Contacts''''' there are two columns (fields): '''Name''' and '''Tel No.'''. <br />
<br />
For simple uses a single table can make up a database. Many people consider these two equivalent. As you will see, for real databases we usually need more than one table. <br />
<br />
To sum up, you have already got a simple database with one table '''''Contacts'''''.<br />
<br />
{{Prevnext2<br />
|prevpage=Special:MyLanguage/Kexi/Handbook/Appendix_A._Introduction_to_Databases<br />
|prevtext=Appendix A. Introduction to Databases<br />
|nextpage=Special:MyLanguage/Kexi/Handbook/Introduction_to_Databases/Database_and_Spreadsheet<br />
|nexttext=Database and Spreadsheet<br />
|index=Special:MyLanguage/Kexi/Handbook|indextext=Back to menu<br />
}}<br />
<br />
[[Category:Kexi]]<br />
[[Category:Tutorials]]</div>FuzzyBot