Data bases

Data bases

1. A table

   • The data is stored or organised on a table.

2. A database

   • A collection of related data in a way to make the data useful.

3. A Record

   • The row on a table that holds the same type of information.

4. A Field

   • Every column has information about multiple things in the table, these are called fields.

5. Data Types

   • Text
     • Sequences of letters, numbers and other symbols.
     • A, 3, $
   • Number
     • Is only numerical value, such as ages, prices, quantities etc.
   • Date/Time
     • Used when using dates in the year, or times of the day.
     • 5/3/2013
   • Logical
     • Also the Yes/No. Represents a value that is true or false.
     • Are you a current student at Brooksbank School?