Gestalte GoConqr mit. Was sollen wir als Nächstes hinzufügen?

Mindmap

Lesson 11 - Data Storage

Ellen Greenough Englisch

Inhalt der Mindmap

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.

Informationen

Beschreibung
Mindmap am Lesson 11 - Data Storage, erstellt von Ellen Greenough am 21/06/2014.
Erstellt von
Ellen Greenough
Aufrufe
22
Bewertung

Feedback

Worum geht es?

Was sollen wir als Nächstes hinzufügen?