Tag: Databases
Year 8 – European Database
Countries of Europe project
You will create a database of the countries in Europe. For each country you need to find the following infromation.
-
Country name
-
Capital
-
Population
-
Area (sq km)
-
Currency
-
Time zone
Record the information in the MS Excel File below:
European Countries
Year 8 – European Database
Lesson Aim
- Gather information for creating a database of European Countries
Main Task
Your task is to gather information about the countries in Europe and store it in MS Excel. You need to gather the following information:
- Name (Country)
- Area
- Population
- Capital
- Language spoken
- Currency
Extension
If you complete the gathering of all the information for all the European countries. Create a presentation about one of the countries in MS Powerpoint.
Databases – GCSE Computing
Lesson Aim
- Define the term Database
- Understand what a database
- Know different ways to validate a database
Starter
Main
Read the database notes below:
Now you have read the notes complete the questions below:
Plenary
Create a tweet about what you learnt in todays lesson
Databases II – GCSE Computing
Lesson Aim
- Know the role of the DBMS
- Understand the need for relational databases
- Know what a primary key and foreign key are
Starter
Main
Take 15 minutes to read the notes below:
Now complete the questions sheet below:
Plenary
Click on the link below and add three things you learnt this lesson
Year 8 – World Record Database
Lesson Aim:
- Create Reports using Microsoft Access
Main Task
Your task today is to ensure that you have completed the queries for the task week and then create reports for each of your queries.