Help shape GoConqr. What should we add next?

Mind map

Computer Science 1.3.1

Jamie Fisher Computing A level English

Computer Science 1.3.1

Map content

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.

Images and files in the map

  • Computer Science 1.3.1

Information

Description
A level Computing Mind Map on Computer Science 1.3.1, created by Jamie Fisher on 20/04/2017.
Created by
Jamie Fisher
Views
0
Rating

More on Database Keys and Relationships

Feedback

What is it about?

What should we add next?