Higher+Database+Structure+Practical+Exercises


 * 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 **

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 Computing OneNote file.

Director Maria Hill has decide that their database could be simpler. She has found that a lot of her office staff get confused by their real names, often only knowing them by their codename only. She has suggested adapting the database to show the following:
 * Task 2**




 * Your Tasks:**

1. Create a data dictionary to show how you would adapt this database in your Computing OneNote file showing: File Name, Data Type, Primary Key or Foreign Key. 2. Take your database from Task 1 and adapt it to Director Maria Hill's requests. 3. Screenshot your evidence for this, placing it into your Computing OneNote file. 4. Create a relationship between the three tables using Director Maria's design. 5. Screenshot the relationship that you have created, placing it into your Computing OneNote file.