National+5+Database+Practical+Task+1


 * Your teacher will show you how to create a relational database within Microsoft Access. **

For the following tasks, under the section ISDD, create the page "Relational Databases".
 * Computing OneNote Instructions **


 * Task 1**

Forrester Game Studios would like to create a relational database to sort data they have on the employees in their company. They currently have the following flat file database:


 * Your tasks:**
 * 1) Complete the following **data dictionary** in your Computing OneNote file, showing how you would split the above data into two **tables** as well as identifying the **Primary** and **Foreign Keys**.



2. Create the two tables using Microsoft Access and using the design you have created in step 1.

3. Screenshot both tables in design view and table view and place this into your Computing OneNote file.

4. Create a relationship between the two tables.

5. Screenshot the relationship that you have created.


 * Task 2**

S.H.I.E.L.D would like to create an on-line database that their agents can access all over the world. Below is the data they would like to store on their agents and their current targets:



Director Maria Hill has indicated that the data needs to be split into two tables and made into a relational database. She has given the following information to their technical department of how she would like the database tables to look. This is shown below:




 * Your Tasks:**

1. Create a data dictionary in your Computing OneNote file showing: File Name, Data Type, Primary Key or Foreign Key. 2. Create the S.H.I.E.L.D database using Director Maria Hill's instructions on how to create your tables and using your data dictionary from task 1. 3. Director Maria Hill has decided that Agents will need photographic ID of the Heroes and their targets, Add an additional field to each of the tables that would include a photograph. (Use the internet to find photos for your database). 4. Screenshot both tables in design view and table view and place this into your Computing OneNote file. 5. Create a relationship between the two tables. 6. Screenshot the relationship that you have created, placing it in your OneNote file.