Ajude a dar forma ao GoConqr. O que a gente deve adicionar?

Mapa mental

Lesson 11 - Data Storage

Ellen Greenough Inglês

Conteúdo do mapa

Lesson 11 - Data Storage

  1. All the ways in which data is held, holding data on a computer system using databases (a simple collection of data organized)

  2. Database structure is made up of data about customers/products that are stored in a table. Every row in the table holds information about a single item (called a record). Every column holds information about a property of the items in the table, such as the customer's name or an item's price (called fields)

  3. Databases

    • Table
      • A representation of data in a database
    • Record
      • A group of selected data which are associated in some way
    • Field
      • A single piece of data within a record
    • Relationship
      • The link using a foreign key - a benefit of databases where the information they hold can be assessed.
    • Data Type
      • Each field in a set up to hold certain types of data
  4. Data types that are used in databases

    • Number (price)
    • Text (someone's name)
    • Date/time
    • Logical (true/false)
  5. Primary Key

    • A single unique key used to identify each record in a table
  6. Foreign Key

    • A field which can be used to cross-reference and access associated information across many tables
  7. Online databases are databases which are accessible using a network, including the internet. They are very different to local databases as they have to be accessed, and possibility updated, by millions of users. Normally, these databases will have thousands of rows of information. Usually information is found in online databases by using a search engine.

  8. Database Management Systems (DBMS)

    • Programs which allow you to create any database that you need and to use the databases you have created. The DBMS allows you to create, maintain, search and sort data on a database. It allows different users to access the database at the same time, and can provide different levels of access to the data.
  9. Common database management systems

    • Structured Query Language (SQL)
      • High level language used to undertake this management activity.
    • Data Definition Language (DDL)
      • Used to define the database structure.
    • Data Manipulation Language (DML)
      • Used to add, delete, change, and query the data which is held in the database structure.

Informações

Descrição
Mapa Mental sobre Lesson 11 - Data Storage, criado por Ellen Greenough em 21-06-2014.
Criado por
Ellen Greenough
Visualizações
22
Avaliação

Fale Conosco

Sobre o que é sua mensagem?

O que a gente deve adicionar?