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

Mapa mental

Computer Science 1.3.1

Jamie Fisher Computing A level Inglês

Computer Science 1.3.1

Conteúdo do 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.

Imagens e arquivos do mapa

  • Computer Science 1.3.1

Informações

Descrição
A level Computing Mapa Mental sobre Computer Science 1.3.1, criado por Jamie Fisher em 20-04-2017.
Criado por
Jamie Fisher
Visualizações
0
Avaliação

Mais sobre Database Keys and Relationships

Fale Conosco

Sobre o que é sua mensagem?

O que a gente deve adicionar?