Kexi/Handbook/Introduction to Databases/What Is a Database?/da: Difference between revisions

From KDE UserBase Wiki
(Importing a new version from external source)
(Importing a new version from external source)
Line 27: Line 27:
{{Prevnext2
{{Prevnext2
|prevpage=Special:MyLanguage/Kexi/Handbook/Appendix_A._Introduction_to_Databases
|prevpage=Special:MyLanguage/Kexi/Handbook/Appendix_A._Introduction_to_Databases
|prevtext=Appendix A. Introduction to Databases
|prevtext=Appendix A. Introduktion til databaser
|nextpage=Special:MyLanguage/Kexi/Handbook/Introduction_to_Databases/Database_and_Spreadsheet
|nextpage=Special:MyLanguage/Kexi/Handbook/Introduction_to_Databases/Database_and_Spreadsheet
|nexttext=Database and Spreadsheet
|nexttext=Database og regneark
|index=Special:MyLanguage/Kexi/Handbook|indextext=Back to menu
|index=Special:MyLanguage/Kexi/Handbook|indextext=Indholdsfortegnelse
}}
}}


[[Category:Kexi]]
[[Category:Kexi]]
[[Category:Tutorials]]
[[Category:Tutorials]]

Revision as of 18:48, 10 April 2012

Other languages:

Hvad er en database?

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.

Look at this diagram for one of the above examples: a simple phone book.



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:

Contacts table
Name Tel No.
Joan 699 23 43 12
Adam 711 19 77 21

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..

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.

To sum up, you have already got a simple database with one table Contacts.