Databases

Databases

1. Databases and data capture

   • The key field is a unique identifier for each record.
     • A relational database has more than one table and the tables are linked using key fields.
       • A data capture from is designed to collect specific data. before setting up a database the data must be collected
         • we use databases to keep useful information like when you ordered something or when you go doctors or dentists so like your appointments
           • applications such as Microsoft access use query language to narrow down search results

2. Data, information and knowledge

   • A structure is needed in order for data on become information
     • knowledge is the ability to understand information and to then form judgements
       • Data is words, numbers, dates, images, sound etc without context

3. Data validation and verification

   • validation is an automatic computer check to ensure that the data entered is sensible and reasonable
     • verification is performed to ensure that the data entered exactly matches the original source

4. Data security

   • key threats to data security
     • keeping data secure measures that can be taken to keep data secure include

5. Data transfer

   • Data files are store in a number of formats, the formats depend on which application created the file to begin with. for example, Microsoft word stores files as ".doc but adobe Photoshop stores files in a different format-*.psd. The file extension identifies the files format