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

something about which data will be stored, e.g. a customer or booking

Database design

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?

This lesson will be removed by end of Summer Term 2025.

Database design

Lesson outcome

This lesson will be removed by end of Summer Term 2025.