Please enable JavaScript.

Coggle requires JavaScript to display documents.

ch.8 Databases - Coggle Diagram

- - - - ● field
      - ● Record
      - ● table
      - ● Database
  - - - ● Driver’s licence number
      - ● Student identification number
      - ● bank account number
      - ● Product code
      - ● order number
- - - - Table:
        
        Tables are used to store the data. You can create as many tables as
        
        you need to store different types of data. Data in a table is arranged in
        
        rows and columns.
      - Forms:Forms are attractive or user-friendly interfaces that can be used to
        manipulate and display the data in a table.
      - Reports:Reports are used to present data in a professional and easy-to-read
        layout and they often contain summarized information.
      - Queries:
        
        Queries are used to perform an action on a table. For example, they
        
        can be used to return records that meet the specified criteria from
        
        one or more tables.
      - Macros: Macros are smiler programs used to automate certain tasks.
      - Module: Are programs that contain data management logic defined by users
  - - - Rearrange all the records in ascending or descending order according to a specified field
    - - Extract a subset of the records in the table according to specified
        criteria.
      - e.g. you can apply a filter on the ‘members’ table to obtain a list of members who.
        live in a certain district.
- - - - Personal phone book
      - Video or CD catalogue
      - Animal records of a vet clinic
      - Employee records of a company
      - Stock control of a shop
      - Club membership of a club house
      - Student records of a school