Please enable JavaScript.

Coggle requires JavaScript to display documents.

IST YEARLY EXAM REVISION (DATABASES (Components of a database (File (File…

- - - - Flat File is 1 table only
      - Relational is 2 or more tables.
  - - - One row in the database (---)
    - - Form displays 1 record.
    - - Block containing all the information. Each table is called a file.
    - - Entry to the field name.
    - - Displays all records.
    - - Any letter number or symbol.
    - - File is the name given to the table.
    - - Unique identifier (PK) - HSC Student number
    - - Primary Key from another table.(Student ID and Class ID)(Join 2 tables together)
    - - Name of the column
    - - Is a search conducted in a database to find specific results.
    - - Record in a relational database.
  - - - Field Names (Last name, first name age etc)
    - - Criteria (Run Query of search) (Sports = Basketball)
    - - Table Name
    - - The Order arranged (Ascending)
  - - - 1 student to 1 timetable
    - - 1 Student to many subjects
    - - Many students to many sports
  - - - Files can corrupt, copies can be made.
    - - Data can be lost, caught on fire and no backups.
  - - - Ways to store a database:
      - Icloud
      - Saving Database on HDD
      - Saving database on SSD
      - Transferring database onto an external HDD
      - Transferring database onto an external SSD
      - Online storage
      - Desktop
      - Floppy Disk
      - Server
      - School Drive
      - Computer
      - Google Drive
      - Drop box
      - One Drive
      - Files/Folders
      - USB