This digital student book offers comprehensive coverage of the Cambridge Advanced National in IT: Data Analytics Unit F203: Relational database design. Mapped to the OCR specification, this book has been designed to help students and teachers build the confidence, knowledge and skills needed to succeed in the new qualification. Ideal as both a learning and reference tool, it is structured to follow the order of the specification and unpack its content in an easy-to-follow, digestible way. It will help students learn key concepts and information, while providing teachers with guidance on the breadth and depth of content they're required to teach.Written by Alan Jarvis, an experienced teacher and practitioner, this book will help students develop the skills, knowledge and understanding they need to design, develop and test databases and use database technology to meet user needs. It will explore database theory and how to: develop database features such as queries, forms and reports; provide a user interface to allow convenient access to these facilities; and test and evaluate their completed database solution. This book is written to be engaging and motivating. “Learning in Context” examples help students relate the concepts they are learning to the real world, and worked examples guide their development of essential skills, step-by-step. Furthermore, frequent quick-check questions help them to assess their progress and understanding of each topic. We are working towards endorsement by OCR.
Features
- The book provides comprehensive coverage of the OCR specification and unpacks it in an easy-to-follow, digestible way. This supports students’ learning of key concepts and essential information, while providing teachers with comprehensive guidance on the depth of content they need to teach. We are working towards endorsement by OCR.
- Written for students, using accessible and appropriate language, short and focused paragraphs, as well as modern and useful contextual examples.
- Engaging “Learning in context” features highlight how concepts can be applied within the industry or role, helping students to make connections between what they are studying and the real world.
- Written by expert author Alan Jarvis, an experienced teacher and practitioner.
- Worked examples guide students' development of essential skills, step-by-step.
- Frequent quick check questions empower students to assess their progress and understanding of each topic. Answers to these can be found as a downloadable PDF within our online platform, Cambridge Go.
- Key words in bold and a glossary help students to grasp and master new vocabulary.
- Great for use in class, as well as for setting homework tasks or independent learning.
- Designed to better prepare students for and build confidence ahead of assessments.
- Digital format means content can be accessed anytime, anywhere – on a phone, tablet or computer.
Table of Contents
- Acknowledgements
- Introduction
- About the author
- How to use this book
- Unit F203: Relational database design
- TA1: Relational database concepts
- TA2: Plan relational database solutions
- TA3: Create relational databases
- TA4: Testing relational database solutions
- TA5: Evaluate database solutions
- Answers
- Glossary
Brighter Thinking Blog
Keep up to date with the latest classroom tips and educational trends from our brighter thinkers.
Visit the blogCatalogues and Ordering
Looking for something in particular or just browsing? View our catalogues to see our full range of print and digital books.
View and downloadAdvice on useful tools
Advice on useful tools, activities and timetabling from teachers experiencing school closures.
Cambridge GO
All our supporting resources have now moved to Cambridge GO – the new home for your Cambridge digital content.
Listen to our podcast
Listen to our podcast to discover teaching inspiration & advice from leading educational thinkers.