Computer Science

DataBase Management System: a software package that allows a database administrator to maintain one or more databases

Entity Relationship Diagram: a diagram that shows the relationship between two or more entities

an entity is a single object, place, person or thing

Database design

Database fundamentals

SQL fundamentals

SQL searches

Data management with SQL statements

Data protection, copyright and the law

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

Which of the following is a main function of a DBMS besides storage?

A collection of related data arranged in rows and columns

A single category of data within a table, such as "Name"

All the data about one item, shown as a row in a table

A search or request to find or analyse specific data in a database

A formatted summary or printout of selected data

A user-friendly way to enter or view data in a database

Match each database term to its correct description:

What is the abbreviated name for the diagram used to represent how different parts of a database are linked?

Draw an entity-relationship diagram (ERD)

Put these steps in order for designing a relational database:

What is the name for a category heading in a database table?

An attribute that uniquely identifies a record

A field that links to a primary key in another table

Which of these could be a record in a database of books?

What is the main purpose of a primary key?

Database design

Lesson outcome