 |
Example - Setting up tables |   |
Software -
Databases
|
The first step towards creating a database is to set up the relevant tables of information. We will create a database that stores the names and examination results of a group of students. This will require two tables: a 'Student' table and a 'Subject/marks' table. First we need to create the fields for our tables, then we need to enter the data.
|
|||||
|
|
|||||
| We need to make sure to
provide a primary key for each table - we have
made the 'student ID' fields the primary
keys in our tables. |
