
07-16-2005, 06:18 AM
|
|
Junior Member
|
|
Join Date: Jul 2005
Posts: 6
|
|
For beginners
What is a Database?
A database is a structure that comes in two flavors: a flat database and a relational database. A relational database is much more oriented to the human mind and is often preferred over the gabble-de-gook flat database. MySQL is a relational database.
In a relational structured database there are tables that store data. Each table is made up of columns and rows. A table's columns define what kind of information is going to be stored. You need an individual column for each type of information you wished to store (i.e. Age, Weight, Height).
While columns define what kind of information is going to be stored, a row is the actual data that is stored. Each table row is an entry of that table and contains values for each of the table's columns (i.e. Entry Bob: 65 years old, 165 lbs, and 6'2"). If all this relational database talk is confusing, do not despair, we talk about and show a few table examples in future lessons.
Why Use a Database?
Databases are most useful when it comes to storing information that fits into logical categories. For example, say that you wanted to store information of all the employees in a company. With a database you can have tables for many similar tables. Example tables would be: logistics, managers, janitors, performance measurements, etc.
|