Gestalte GoConqr mit. Was sollen wir als Nächstes hinzufügen?

Mindmap

Computer Science 1.3.1

Jamie Fisher Computing A level Englisch

Computer Science 1.3.1

Inhalt der Mindmap

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.

Bilder und Dateien der Mindmap

  • Computer Science 1.3.1

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

Feedback

Worum geht es?

Was sollen wir als Nächstes hinzufügen?