Database design
Lesson details
Learning outcome
I can design a relational database structure for a given scenario.
Key learning points
- 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).
Keywords
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 misconception
A DBMS is only used for storing data.
While storage is a major function, a DBMS also provides data security, integrity and querying capabilities.
Teacher tip
This lesson introduces learners to the concept of a DBMS. You may wish to demonstrate the functionality of a DBMS by using an open source system such as MySQL or DB Browser for SQLite.
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.What is a database?
Q2.What is the name for a category heading in a database table?
Q3.Match the term to its meaning:
A set of related fields for one object
A category heading in a table
An attribute that uniquely identifies a record
A field that links to a primary key in another table
Q4.Which of these could be a record in a database of books?
Q5.Why do databases use fields?
Q6.What is the main purpose of a primary key?
Assessment exit quiz
6 Questions
Q1.What does DBMS stand for?
Q2.Which of the following is a main function of a DBMS besides storage?
Q3.What is an entity in a database?
Q4.Match each database term to its correct description:
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
Q5.What is the abbreviated name for the diagram used to represent how different parts of a database are linked?
Q6.Put these steps in order for designing a relational database:
To help you plan your 11 computer science lesson on: Database design, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your 11 computer science lesson on: Database design, download all teaching resources for free and adapt to suit your pupils' needs.
The starter quiz will activate and check your pupils' prior knowledge, with versions available both with and without answers in PDF format.
We use learning cycles to break down learning into key concepts or ideas linked to the learning outcome. Each learning cycle features explanations with checks for understanding and practice tasks with feedback. All of this is found in our slide decks, ready for you to download and edit. The practice tasks are also available as printable worksheets and some lessons have additional materials with extra material you might need for teaching the lesson.
The assessment exit quiz will test your pupils' understanding of the key learning points.
Our video is a tool for planning, showing how other teachers might teach the lesson, offering helpful tips, modelled explanations and inspiration for your own delivery in the classroom. Plus, you can set it as homework or revision for pupils and keep their learning on track by sharing an online pupil version of this lesson.
Explore more key stage 4 computer science lessons from the Databases and SQL unit, dive into the full secondary computer science curriculum, or learn more about lesson planning.