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

Mapa mental

Computer Science 1.3.1

Jamie Fisher Computing A level Inglés

Computer Science 1.3.1

Contenido del mapa

Computer Science 1.3.1

  1. Keys

    • Primary Key
      • The Primary Key in a relational database is a unique identifier within a record, and each database requires at least one.
      • Example: EmployeeID
    • Foreign Key
      • A Foreign Key is a primary key from another table that identifies a record in another table, as it has the same name.
      • Example: EmployeeID in a table named Employees and in another named Employee Details.
    • Secondary Key
      • The Secondary Key is made on a field that you want to be indexed for faster searches.
      • When a database fills with hundreds of thousands of pieces of information, a secondary key can help narrow down a search.
  2. Entity-Relationship Diagram

    • The 3 types of Entity-Relationship are: One-to-One One-to-Many Many-to-Many
    • Many-to-Many relationships do not work in a database, and therefore must be changed into two linked One-to-Many relationships.

Imágenes y archivos del mapa

  • Computer Science 1.3.1

Información

Descripción
A level Computing Mapa Mental sobre Computer Science 1.3.1, creado por Jamie Fisher el 20/04/2017.
Creado por
Jamie Fisher
Visitas
0
Valoración

Más sobre Database Keys and Relationships

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué deberíamos añadir?