Mind map
Computer Science 1.3.1

Map content
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.
Images and files in the map
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