Mapa mental
Computer Science 1.3.1

Conteúdo do mapa
Computer Science 1.3.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.
- Primary Key
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
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