Database Design & Development in the Cloud
Database design and development in the cloud focuses on creating relational databases using cloud services. It includes design, implementation, testing, and documentation for hosting.
Assessment criteria
Topic Overview
Cloud Computing is a paradigm that enables on-demand access to a shared pool of configurable computing resources (e.g., networks, servers, storage, applications, and services) that can be rapidly provisioned and released with minimal management effort or service provider interaction. In the Pearson BTEC Level 5 HND in Cloud Computing, this topic forms the foundation for understanding how modern IT infrastructure is delivered and managed. You will explore the essential characteristics of cloud computing—such as on-demand self-service, broad network access, resource pooling, rapid elasticity, and measured service—and learn how these differentiate cloud from traditional IT models.
This unit is critical because cloud computing is now the dominant model for IT service delivery, used by organisations of all sizes to reduce costs, increase agility, and scale globally. As a cloud computing professional, you will need to understand the deployment models (public, private, hybrid, community) and service models (IaaS, PaaS, SaaS) to design and implement solutions that meet business requirements. The topic also covers key enabling technologies like virtualisation, containerisation, and orchestration, which are essential for building and managing cloud infrastructure.
Within the wider HND programme, this topic connects to modules on networking, security, and systems architecture. It provides the conceptual framework for later units on cloud security, DevOps, and cloud-native development. Mastering these fundamentals will prepare you for industry certifications such as AWS Certified Cloud Practitioner or Microsoft Azure Fundamentals, and for roles like cloud engineer, solutions architect, or cloud consultant.
Key Concepts
Core ideas you must understand for this topic
- →Essential Characteristics: Understand the five essential characteristics defined by NIST: on-demand self-service, broad network access, resource pooling, rapid elasticity, and measured service. These are the defining features that make a service truly 'cloud'.
- →Service Models: Know the three main service models: Infrastructure as a Service (IaaS) provides virtualised computing resources; Platform as a Service (PaaS) offers a platform for developing and deploying applications; Software as a Service (SaaS) delivers software over the internet. Each model shifts responsibility from the customer to the provider.
- →Deployment Models: Differentiate between public cloud (shared infrastructure, accessible over the internet), private cloud (dedicated to a single organisation), hybrid cloud (combination of public and private), and community cloud (shared by several organisations with common concerns).
- →Virtualisation and Containerisation: Virtualisation allows multiple virtual machines to run on a single physical server, while containerisation (e.g., Docker) packages applications with their dependencies for consistent deployment. Both are key enablers of cloud resource pooling and elasticity.
- →Metering and Billing: Cloud services use a pay-as-you-go model, where usage is metered (e.g., CPU hours, storage GB, data transfer). Understanding how costs are calculated and optimised is crucial for cost-effective cloud management.
Learning Objectives
What you need to know and understand
- 1. Design a cloud based relational database system using appropriate design tools and methods for a substantial problem.2. Develop a fully functional relational database system, based on an existing system design and host it in the cloud.3. Perform system testing against user, technical and hosting requirements.4. Produce documentation to support the system and manage the hosting of it in the cloud.
- 1. Design a cloud based relational database system using appropriate design tools and methods for a substantial problem.2. Develop a fully functional relational database system, based on an existing system design and host it in the cloud.3. Perform system testing against user, technical and hosting requirements.4. Produce documentation to support the system and manage the hosting of it in the cloud.
Assessment Criteria
Key criteria assessors look for in your portfolio
- Design a normalised relational database schema for a given scenario.
- Implement the database using a cloud-based DBMS.
- Perform testing against user and technical requirements.
- Produce user and technical documentation for the system.
- Award credit for demonstrating the application of appropriate design tools and methods (e.g., ERDs, normalization, data flow diagrams) to create a robust relational database design that addresses all requirements of the given substantial problem.
- Verify that the developed database is fully functional, hosted on a cloud platform (e.g., AWS RDS, Azure SQL), and faithfully implements the design, including tables, relationships, constraints, and any required views or stored procedures.
- Check for systematic testing evidence: test plans covering user acceptance, technical performance, and cloud hosting criteria, with documented results and corrective actions taken for any failures.
- Assess the quality of documentation: it should include a data dictionary, ERD, hosting architecture diagram, deployment steps, security configuration, backup strategy, and a maintenance plan, all clearly written and tailored for ongoing cloud management.
Assessment Guidance
Guidance for achieving higher grades
- 💡Use entity-relationship diagrams to model data clearly.
- 💡Familiarise yourself with cloud database services like AWS RDS.
- 💡Document test cases and results thoroughly.
- 💡Integrate cloud-native design patterns from the start—consider sharding, read replicas, or geo-redundancy—to demonstrate an advanced understanding of cloud database architecture and score higher marks.
- 💡When selecting cloud hosting options, use pricing calculators or Total Cost of Ownership (TCO) tools to justify decisions; this commercial awareness is highly regarded by assessors.
- 💡Perform and document performance testing under realistic workloads using cloud monitoring tools (e.g., AWS CloudWatch, Azure Monitor) to provide concrete evidence that the system meets technical and hosting requirements.
- 💡Structure documentation as if handing over to a future operations team: include clear troubleshooting guides, scaling procedures, and a maintenance schedule to showcase professionalism and thoroughness.
- 💡Use the NIST definition as your framework: When answering questions about cloud computing, always refer to the NIST definition (SP 800-145). It provides a clear, standardised structure for explaining essential characteristics, service models, and deployment models. Examiners look for this precise terminology.
- 💡Compare and contrast: Be ready to compare cloud models (e.g., IaaS vs PaaS, public vs private) in terms of control, flexibility, and responsibility. Use a table or bullet points in your answer to show clear distinctions.
- 💡Real-world examples strengthen your answer: Mention specific providers (AWS, Azure, Google Cloud) and their services (e.g., EC2 for IaaS, Azure App Service for PaaS, Office 365 for SaaS). This shows practical understanding and application of concepts.
Common Mistakes
Common errors to avoid in your coursework
- Failing to normalise tables properly leading to redundancy.
- Ignoring cloud-specific security and scalability considerations.
- Inadequate testing of data integrity and performance.
- Confusing logical and physical design stages, particularly failing to adapt the design for cloud-specific considerations such as choosing correct service tiers, storage types, and network security groups.
- Inadequate testing: focusing solely on functionality and neglecting hosting requirements like latency under load, failover testing, backup integrity, or cost implications of query patterns.
- Producing documentation that is either too generic or incomplete, such as omitting crucial cloud management details like region selection justification, instance sizing rationale, or disaster recovery procedures.
- Overlooking cloud-specific security features, for example, not encrypting data at rest, misconfiguring access policies, or failing to use managed identities, which can lead to non-compliance with requirements.
- Misconception: Cloud computing is just virtualisation. Correction: While virtualisation is a key enabler, cloud computing includes additional features like self-service, elasticity, and measured service. Virtualisation alone does not provide a cloud experience.
- Misconception: Public cloud is always cheaper than on-premises. Correction: For predictable, steady-state workloads, on-premises can be more cost-effective. Cloud is often cheaper for variable or growing workloads due to its elasticity and pay-as-you-go model.
- Misconception: Once data is in the cloud, it is automatically secure. Correction: Security is a shared responsibility. The provider secures the infrastructure, but the customer must secure their data, applications, and access controls (e.g., encryption, IAM policies).
Frequently Asked Questions
Common questions students ask about this topic
Pass / Merit / Distinction Evidence Checklist
How your portfolio evidence is graded for PEARSON Database Design & Development in the Cloud
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 understanding of computer networks (e.g., IP addressing, protocols, client-server model) is helpful for grasping how cloud resources are accessed over the internet.
- •Familiarity with operating systems (especially virtualisation concepts) will aid in understanding how hypervisors and containers work.
- •A general awareness of IT service delivery models (e.g., on-premises, hosted) provides context for why cloud computing emerged as a paradigm shift.
Coursework AI Review
Self-check your coursework evidence against P/M/D criteria
Key Terminology
Essential terms to know
- 1. Design a cloud based relational database system using appropriate design tools and methods for a substantial problem.2. Develop a fully functional relational database system, based on an existing system design and host it in the cloud.3. Perform system testing against user, technical and hosting requirements.4. Produce documentation to support the system and manage the hosting of it in the cloud.
- 1. Design a cloud based relational database system using appropriate design tools and methods for a substantial problem.2. Develop a fully functional relational database system, based on an existing system design and host it in the cloud.3. Perform system testing against user, technical and hosting requirements.4. Produce documentation to support the system and manage the hosting of it in the cloud.
Ready to learn?
AI-powered learning tailored to this unit