Relational database design
Relational database design involves planning, creating, testing, and evaluating database solutions. Learners will understand concepts like normalisation, relationships, and SQL, and apply them to practical scenarios.
Assessment criteria
Topic Overview
Data Analytics is a core component of the Cambridge OCR Level 3 Alternative Academic Qualification in IT, focusing on the systematic analysis of data to support decision-making. This topic covers the entire data analytics lifecycle: from defining business problems and collecting data, through cleaning and processing, to analysis, interpretation, and presentation of findings. Students learn to apply statistical methods, use tools like spreadsheets and databases, and understand ethical considerations such as data protection and bias.
In today's data-driven world, the ability to extract meaningful insights from raw data is a highly valued skill. This module equips you with practical techniques for handling real-world datasets, including identifying trends, patterns, and anomalies. You will also explore how data analytics is used across industries—from marketing and finance to healthcare and government—and how it informs strategic decisions.
This topic builds on foundational knowledge of databases and spreadsheets from earlier units. It prepares you for further study in data science, business intelligence, or related fields, and provides a strong basis for careers that require data literacy. Mastery of data analytics will enable you to critically evaluate data sources, apply appropriate analytical methods, and communicate findings effectively.
Key Concepts
Core ideas you must understand for this topic
- →Data lifecycle: Understand the stages from data collection, storage, cleaning, analysis, interpretation, to presentation and archiving.
- →Descriptive, diagnostic, predictive, and prescriptive analytics: Know the differences and when to apply each type.
- →Data quality: Assess accuracy, completeness, consistency, and timeliness; handle missing or erroneous data through cleaning techniques.
- →Statistical measures: Calculate mean, median, mode, range, standard deviation, and correlation to summarise and interpret data.
- →Data visualisation: Use charts (bar, line, scatter, pie) and dashboards to communicate insights clearly and effectively.
Learning Objectives
What you need to know and understand
- Relational database concepts, Plan relational database solutions, Create relational databases, Testing relational database solutions, Evaluate database solutions
Assessment Criteria
Key criteria assessors look for in your portfolio
- Explains relational database concepts (tables, keys, relationships).
- Plans a database solution meeting user requirements.
- Creates tables with appropriate data types and constraints.
- Tests database functionality and corrects errors.
- Evaluates the solution against criteria and suggests improvements.
Assessment Guidance
Guidance for achieving higher grades
- 💡Always normalise to at least 3NF.
- 💡Use entity-relationship diagrams to plan.
- 💡Test with sample data to verify integrity.
- 💡Always justify your choice of analytical method: Explain why you used a particular statistical test or visualisation, linking it to the data type and the question being asked.
- 💡Show your working: When calculating statistics, present the formula and intermediate steps to demonstrate understanding, even if you use a spreadsheet.
- 💡Discuss limitations: In your conclusions, mention any data quality issues, sample size constraints, or potential biases to show critical evaluation.
Common Mistakes
Common errors to avoid in your coursework
- Poor normalisation leading to data redundancy.
- Incorrect relationship types or foreign key usage.
- Insufficient testing or ignoring edge cases.
- Misconception: Correlation implies causation. Correction: Two variables may correlate without one causing the other; always consider confounding factors and avoid assuming cause-and-effect without further evidence.
- Misconception: More data always leads to better analysis. Correction: Quality matters more than quantity; poor-quality data can introduce bias and errors, so cleaning and validation are crucial.
- Misconception: Data analytics is only about using software tools. Correction: While tools are important, the analytical thinking, problem definition, and interpretation of results are equally critical for meaningful insights.
Frequently Asked Questions
Common questions students ask about this topic
Pass / Merit / Distinction Evidence Checklist
How your portfolio evidence is graded for CAMBRIDGE OCR Relational database design
Every vocational unit is marked against named criteria rather than an exam percentage. Your tutor's brief lists the exact codes for this unit — here is what each band is asking you to do.
Demonstrate baseline knowledge, accurate terminology, and core practical application.
Provide detailed analysis, structured explanations, and clear workplace reasoning.
Deliver thorough evaluation, original problem solving, and fully justified recommendations.
Before You Start
Prior knowledge that will help with this topic
- •Basic spreadsheet skills: Ability to use formulas, sort/filter data, and create simple charts.
- •Understanding of databases: Familiarity with tables, queries, and data types (e.g., text, numeric, date).
- •Fundamental statistics: Knowledge of mean, median, mode, and range from GCSE Mathematics.
Coursework AI Review
Paste your assignment brief and check your draft against its P/M/D criteria
Key Terminology
Essential terms to know
- Relational database concepts, Plan relational database solutions, Create relational databases, Testing relational database solutions, Evaluate database solutions
Ready to learn?
AI-powered learning tailored to this unit