Study Hub

Study Guides

This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.

Back to Study HubBrowse Year 11 Computing Guides

Year 11 - Computing

Database design

Databases and SQL

Unit Summary

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.

Lesson Summary

You will learn to design a relational database structure for a given scenario.

Key Notes

  • A DBMS is a software application that allows a database administrator to maintain one or more relational databases.
  • A data model helps visualise how data is structured for a given scenario, including the relationships between elements.
  • One of the easiest ways to show how data is organised is by using an entity-relationship diagram (ERD).

Vocabulary To Learn

  • DBMS: DataBase Management System: a software package that allows a database administrator to maintain one or more databases
  • ERD: Entity Relationship Diagram: a diagram that shows the relationship between two or more entities
  • entity: an entity is a single object, place, person or thing

Common Mistakes To Avoid

  • A DBMS is only used for storing data.

3 Quick Questions (With Answers)

1. Describe the system or process from this lesson in clear steps.

A DBMS is a software application that allows a database administrator to maintain one or more relational databases. A data model helps visualise how data is structured for a given scenario, including the relationships between elements.

2. Define this computing term and give one practical example. 'DBMS'

DataBase Management System: a software package that allows a database administrator to maintain one or more databases. Add one real device or system example to prove understanding.

3. Correct this common computing misconception.

Mistake: A DBMS is only used for storing data. Correction: While storage is a major function, a DBMS also provides data security, integrity and querying capabilities.

More Lessons In This Unit

Browse all guides in the Year 11 Computing guide library.