Databases

Databases

1. Information

   • Rich
     • Someone who is information rich has access to a wide range of media.
   • Poor
     • Someone who is information poor has no or limited access to media and the world wide web

2. File Types

   • Text
     • Text fields will store characters or words.
     • Can be a combination of text and numbers such as a postcode or an address with a street number (PH33 7BP or 14 High Street)
     • A telephone number would be a text field. This is because it starts with a 0.
   • Number
     • Number field types can store whole numbers (integers) such as 8,99,236 or numbers with decimal places (real numbers) such as 76.33, 2.11, 4.5.
   • Date
     • This field type will store dates. These can be stored in different formats. You will decide when you design the table what format you would like to choose.
   • TIme
     • A time field stores the time of day. This will normally be in 24 hour format such as 15:30

3. Database Types

   • Flat File
     • Only have one table and each row of the table is unique.
     • Problem: Data can be duplicated.
   • Relational
     • Tables are linked to prevent duplication of data within a row of a table.