Specification Reference
- understand the basic concepts of a relational database as a data store
- be able to explain the terms record, fi eld, table, query, primary key, relationship, index and search criteria
Supporting Resources
Introduction to Databases
Learning Cycle Objectives:
- Understand what a database is
- Know how to design a table
- Understand what a database is
- Know how to design a table
Resources
Creating Tables
Learning Cycle Objectives:
- Know how to access MySQL
- Understand how to create a table and set the correct datatypes
- Know how to access MySQL
- Understand how to create a table and set the correct datatypes
Resources
Relationships
Learning Cycle Objectives:
- Know how to create a relationship in a database
- Understand the need for relationships, and data redundancy
- Know how to create a relationship in a database
- Understand the need for relationships, and data redundancy
Resources
Querying
Learning Cycle Objectives:
- Understand that querying asks questions of the database
- Know how to run Select, Insert, Update & Delete queries.
- Understand that querying asks questions of the database
- Know how to run Select, Insert, Update & Delete queries.
Resources
Reports/Interfaces
Learning Cycle Objectives:
- Understand how the data returns from a database
- Know how to use the data in a user friendly way
- Understand how the data returns from a database
- Know how to use the data in a user friendly way
