Kexi/Handbook/Introduction to Databases/What Is a Database?: Difference between revisions
(Splitting lists into smaller units) |
(Marked this version for translation) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 10: | Line 10: | ||
</translate> | </translate> | ||
----<translate> | ----<translate> | ||
<!--T:10--> | |||
[[Image:contact-example.png|172px|center]] | [[Image:contact-example.png|172px|center]] | ||
</translate> | </translate> | ||
----<translate> | ----<translate> | ||
<!--T:11--> | |||
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: | 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: | ||
| Line 33: | Line 35: | ||
<!--T:7--> | <!--T:7--> | ||
To sum up, you have already got a simple database with one table '''''Contacts'''''. | To sum up, you have already got a simple database with one table '''''Contacts'''''. | ||
<!--T:12--> | |||
{{Note|1=Check content at [https://www.zoho.com/creator/database-software-vs-spreadsheet.html www.zoho.com/creator/database-software-vs-spreadsheet.html]}} | |||
<!--T:8--> | <!--T:8--> | ||
Latest revision as of 17:01, 7 April 2012
What Is a 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:
| 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.
Note