Mapa mental
Computer Science 1.3.1

Contenido del 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.
Imágenes y archivos del mapa
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