Mindmap
Computer Science 1.3.1

Inhalt der Mindmap
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.
Bilder und Dateien der Mindmap
Informationen
- Beschreibung
- A level Computing Mindmap am Computer Science 1.3.1, erstellt von Jamie Fisher am 20/04/2017.
- Erstellt von
- Jamie Fisher
- Aufrufe
- 0
- Bewertung
Mehr zu Database Keys and Relationships