Databases-tools and techniques

Databases-tools and techniques

1. Tables

2. Table characteristics

   • Rows and columns
   • Columns=fields
   • Rows=records
   • Field types
     • Text
     • Numbers
     • Currency
     • Dates
     • Times
     • Booleans
       • Yes/no
       • True/false

3. Validation

   • To check for errors
   • Apply to range
   • Correct format
     • Postcode
     • Input mask
     • Correct field size
     • Correct data type

4. Records

   • Add
     • Manually
     • Spreadsheet
   • Edit
   • Delete

5. Indexing

6. Relationships

   • One to one
   • One to many
   • Many to many