Boats, Boats, Boats

Now that you have learned all about database you are going to modify a database about a company called Boats, Boats, Boats to show evidence of your skills

Your teacher will give you a copy of the Boats, Boats, Boats worksheet via Google Classroom.  Alternately, you can make a copy of the file below and upload it to your teacher, including screenshots of your work

In order to achieve level 3 you will need to show that:

• You can identify rights under GDPR

• You can identify suitable primary keys

• You can identify suitable fields and types for a database table

• You can create a table, including a primary key

• You can carry out simple searches

• You can carry out complex searches

In order to achieve level 4 you will need to show that:

• You can complete most of the level 3 outcomes above

• You can comment on the implications of GDPR for organisations

• You can create foreign key fields

• You can link tables with the relationship tool

• You can design and implement queries to solve a problem