Computer Science

a legal right that gives an inventor the exclusive right to make, use or sell their invention for a certain number of years

software for which the program source code is made available to the general public

software that is owned by a company or person. You are not allowed to change, copy or share it without permission. Sometimes called closed source software

Data protection, copyright and the law

Database fundamentals

Database design

SQL fundamentals

SQL searches

Data management with SQL statements

Data and privacy

Big data

The environmental impact of data systems

This unit introduces pupils to databases and SQL, they will explore the key terms used in a database and why relational databases are used to eliminate the redundancy that can occur in a flat file database. They will explore SQL commands to retrieve, update, and delete data in a relational database.

Databases and SQL

What type of information may a database contain?

Proprietary software is usually sold, but sometimes it is free.

Proprietary software can always be edited by anyone.

Which statement about proprietary software is correct?

What term describes software that allows anyone to view and modify its code?

What is the term for a legal right that gives inventors exclusive control over their inventions?

sets rules for collecting and using personal data in the UK

European regulation protecting individuals’ personal data

UK law protecting original creative work and inventions

allows creators to give permission for others to use their work

Match each law or licence to its correct description:

facts about a person that can identify them

Which of these is an example of creative work?

What is the term for a programme that tells a computer what to do?

facts or information stored and used by a computer

the ability to do something or have certain permissions

the person or group who controls something

Match each term to its correct description:

Data protection, copyright and the law

Lesson outcome