Skip to content

GoConqr has a new look! Let us know what you think.

Sign up free

Mind map

Database Tools & Techniques

11dvincent English

Map content

Database Tools & Techniques

Table characteristics
- rows and columns
- Columns=fields
  - Field types
    - Numerical data
    - Text
    - currency
    - Date
    - Web
    - Boolean
      - Yes/No
      - True/False
    - Numerical Data
  - Field Size
    - Double
    - Decimal
    - Single
    - Byte
    - Integer
    - Long integer
Validations
- To check for errors
- Applies to range
- Correct format
  - Postcode
    - Input mask
  - Correct field size
  - Correct date type
Records
- Delete
- Add
  - Manually
  - External Source
- Delete
Indexing
- Primary key
- Secondry Key
Rlationships
- One to many
- Many to many
- One to one

Information

Description: Mind Map on Database Tools & Techniques, created by 11dvincent on 04/11/2014.
Created by: 11dvincent
Views: 7
Rating