databases

databases

1. key terms

   • table
     • A database term. A table contains a set of records. Tables can be permanent or they can be created by a query for temporary use. You set up relationships between tables in order to create a relational database.
   • primary key
   • field
     • record
       • A database term. A record is all of the data about one person or one thing. A record is made up of one or more 'fields'. For example a name and address database could have one record such as this: "Joe Blogs", "34 Wyvern Road" , "Manchester", "UK", "MN253PE" This is a complete record, with each field separated by a comma.
     • A field is a single piece of data about one person or one thing. Many fields make up a record. A field is usually a single column within a multi-column table

2. Examples

   • online examples
     • yell
       • facebook
       • facebook
         • google
         • argos

3. computerised

4. paper-based

5. data types

   • text
   • date
   • time
     • number
       • logical
         • yes/no
           • boolean

6. definiton of a database