Ayúdanos a dar forma a GoConqr. ¿Qué deberíamos añadir?

Mapa mental

Lesson 11 - Data Storage

Ellen Greenough Inglés

Contenido del 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.

Información

Descripción
Mapa Mental sobre Lesson 11 - Data Storage, creado por Ellen Greenough el 21/06/2014.
Creado por
Ellen Greenough
Visitas
22
Valoración

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué deberíamos añadir?