Please enable JavaScript.

Coggle requires JavaScript to display documents.

Ch.8 Databases - Coggle Diagram

- - - - Key Field
        
        data is unique to a specific record
        
        can assign an identity number
      - Short, unique but Descriptive name
    - - Rules for data entry
      - Data Type of fields
    - - Accurate
      - Efficient
      - Effective
- - - - used to perform actions
    - - Present data in easy-to-read layouts
    - - Programs used to automate tasks
    - - used to manipulate and display data in table
    - - Programs contained Data Management Logic
    - - need to have one or more tables
      - Create or Edit Structure
        
        Datasheet View
        
        works like Spreadsheet
        
        will try to assign a data type
        
        Design View
        
        display the underlying structure of the table
        
        preferred way
  - - - Re-arranging records
    - - Extract specified records
  - - - long texts(65536)
    - - for calculations
    - - texts(256)
    - - money
    - - automatically assigned unique number
    - - yes/no, true/false, on/off
    - - your objects my objects
    - - hyperlinks