Fundamentals of Database administration
CITY & GUILDS LIMITED
Vocational
Database administration involves managing and configuring databases. This unit covers core concepts, creating objects, manipulating data, storage, and administration tasks.
8
Learning Outcomes
26
Assessment Guidance
26
Key Skills
8
Key Terms
38
Assessment Criteria
Assessment criteria
City & Guilds Level 3 Certificate in ICT Systems and Principles
City & Guilds Level 2 Diploma in ICT Professional Competence
City & Guilds Level 2 Diploma in ICT Systems and Principles for IT Professionals
City & Guilds Level 3 Diploma in ICT Professional Competence
City & Guilds Level 3 Diploma in ICT Systems and Principles for IT Professionals
City & Guilds Level 2 Certificate in ICT Systems Support
City & Guilds Level 3 Diploma in ICT Systems Support
City & Guilds Level 2 Diploma in ICT Systems Support
Topic Overview
The City & Guilds Level 2 Diploma in ICT Systems and Principles for IT Professionals is a comprehensive vocational qualification designed to equip students with the fundamental knowledge and practical skills required for a career in IT. This diploma covers a wide range of topics including computer hardware, software, networking, database systems, and cybersecurity. It is structured to provide a solid foundation for further study or entry-level roles in IT support, technical services, or systems administration.
This qualification is particularly valuable because it balances theoretical understanding with hands-on application. Students learn how computer systems operate, how to install and configure hardware and software, and how to troubleshoot common issues. The course also introduces essential concepts in data management and network security, which are critical in today's digital workplace. By completing this diploma, students demonstrate to employers that they have a recognised standard of competence in ICT.
Within the broader subject of Computer Science, this diploma serves as a stepping stone. While A-Level Computer Science focuses more on computational thinking and programming, this vocational route emphasises practical IT skills and system maintenance. It is ideal for students who prefer a more applied approach to learning and want to enter the workforce or progress to higher-level IT apprenticeships or qualifications.
Key Concepts
Core ideas you must understand for this topic
- →Computer hardware components: Understanding the function of CPUs, RAM, storage devices, motherboards, and peripherals, and how they interact within a system.
- →Software installation and configuration: Knowing how to install operating systems (e.g., Windows, Linux), device drivers, and application software, and configure settings for optimal performance.
- →Networking fundamentals: Grasping IP addressing, subnetting, network topologies (star, bus, ring), and the OSI model, as well as setting up and managing local area networks (LANs).
- →Database concepts: Learning about relational databases, tables, primary keys, foreign keys, and using SQL to query and manipulate data.
- →Cybersecurity principles: Understanding threats like malware, phishing, and social engineering, and implementing basic security measures such as firewalls, antivirus software, and access controls.
Learning Objectives
What you need to know and understand
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
Assessment Criteria
Key criteria assessors look for in your portfolio
- Describe core database concepts like tables, queries, and relationships.
- Create database objects such as tables, views, and indexes.
- Manipulate data using SQL (SELECT, INSERT, UPDATE, DELETE).
- Explain how data is stored and organised.
- Configure a database and perform basic administration tasks.
- Understands core database concepts such as tables, queries, forms, and reports.
- Creates database objects including tables with appropriate data types.
- Manipulates data using SQL or graphical tools.
- Understands how data is stored and the role of database administration.
- Creates and configures a database to meet specified requirements.
- Define core database concepts like tables, queries, and relationships.
- Create database objects such as tables, views, and indexes.
- Manipulate data using SQL commands (SELECT, INSERT, UPDATE, DELETE).
- Explain how data is stored and organised in a database.
- Configure a database and perform basic administration tasks.
- Explain core database concepts such as tables, keys, and relationships.
- Demonstrate creation of database objects like tables and views.
- Use SQL to manipulate data (INSERT, UPDATE, DELETE).
- Describe how data is stored and indexed.
- Perform database administration tasks like backup and security.
- Define key database concepts like tables, queries, and relationships.
- Create tables with appropriate data types and constraints.
- Use SQL to insert, update, and delete data.
- Perform basic database administration tasks like backups.
- Define core database concepts such as tables, queries, and relationships.
- Create database objects like tables, views, and indexes.
- Demonstrate data manipulation using SQL commands.
- Explain how data is stored and organised in a database.
- Award credit for accurately explaining the relational database model, including concepts like entities, attributes, relationships, and keys (primary, foreign).
- Expect demonstration of creating a fully normalized database schema (up to third normal form) with clear documentation of table structures, constraints, and relationships.
- Assess the ability to write and execute SQL DDL statements (CREATE, ALTER, DROP) to build and modify database objects, and DML statements (INSERT, UPDATE, DELETE, SELECT) to manage data.
- Look for evidence of configuring database storage parameters, such as filegroups and transaction logs, and implementing basic security measures like user logins and role-based permissions.
- Check that the learner can perform and justify a backup and recovery strategy, demonstrating restoration steps in a controlled environment.
- Define core database concepts like primary key and foreign key.
- Create tables with appropriate data types.
- Write SQL queries to insert, update, and select data.
- Explain how data is stored and indexed.
- Configure a database with user permissions.
Assessment Guidance
Guidance for achieving higher grades
- 💡Practice writing SQL queries.
- 💡Understand normalisation to reduce redundancy.
- 💡Back up databases regularly.
- 💡Practice writing basic SQL statements (SELECT, INSERT, UPDATE, DELETE).
- 💡Ensure your database design follows normalisation rules (at least 3NF).
- 💡Test your database with sample data to verify functionality.
- 💡Practice writing SQL queries regularly.
- 💡Understand normalisation to avoid data redundancy.
- 💡Know the difference between DDL and DML commands.
- 💡Practice writing SQL queries.
- 💡Understand normalization forms up to 3NF.
- 💡Know common DBMS features like constraints.
- 💡Practice writing SQL queries regularly.
- 💡Understand normalisation forms (1NF, 2NF, 3NF).
- 💡Always test queries on sample data.
- 💡Practise writing SQL queries for common tasks.
- 💡Understand the purpose of each database object.
- 💡Use diagrams to illustrate database relationships.
- 💡For practical tasks, always script your database creation using SQL files rather than relying solely on graphical interfaces; this demonstrates a deeper understanding and allows for easier testing and version control.
- 💡When demonstrating database administration, explicitly show security considerations by creating separate user accounts with least privilege and explaining each permission granted.
- 💡In assignment write-ups, link your actions to business needs: e.g., ‘I created an index on the customer name field to speed up search queries, which is critical for the support department’s daily operations.’
- 💡Practice restoring a backup to a different server or instance to prove your recovery plan works; document every step with screenshots and clear annotations.
- 💡Use the marking criteria as a checklist: for each learning outcome, ensure you have included evidence of knowledge (explanation) and skill (practical output), with reflection on why certain choices were made.
- 💡Practice writing basic SQL statements.
- 💡Understand the purpose of each database object.
- 💡Use diagrams to show table relationships.
- 💡When answering questions about hardware, always use specific technical terms (e.g., 'SATA III' instead of 'hard drive cable') and explain the function of each component. This demonstrates depth of knowledge.
- 💡For networking questions, draw diagrams if possible. Even in written answers, describe the topology and data flow clearly. Examiners look for logical understanding of how data travels from source to destination.
- 💡In database questions, always include SQL syntax examples when asked. Show that you can write SELECT, INSERT, UPDATE, and DELETE statements correctly, and explain the purpose of each clause.
Common Mistakes
Common errors to avoid in your coursework
- Confusing DDL and DML statements.
- Forgetting to set primary keys or foreign keys.
- Poor indexing leading to slow queries.
- Choosing inappropriate data types for fields (e.g., text for numbers).
- Forgetting to set primary keys or relationships between tables.
- Not normalising data, leading to redundancy.
- Forgetting to define primary keys and relationships.
- Using incorrect SQL syntax for data manipulation.
- Neglecting backup and recovery procedures.
- Confusing primary and foreign keys.
- Forgetting to normalize data properly.
- Neglecting security permissions.
- Not normalising tables leading to data redundancy.
- Forgetting to set primary keys or foreign keys.
- Using incorrect SQL syntax for data manipulation.
- Confusing primary and foreign keys.
- Using incorrect SQL syntax for data manipulation.
- Neglecting normalisation principles when designing tables.
- Confusing the roles of a database administrator (DBA) with those of a database developer or data analyst, underestimating the administrative responsibilities like performance monitoring and security.
- Implementing a database design with redundant data or missing normalization, leading to update anomalies and inefficient storage.
- Writing SQL queries that lack proper filtering (WHERE clause) or joining criteria, resulting in Cartesian products or unexpected empty results.
- Overlooking the importance of indexing: either over-indexing or failing to create indexes on frequently queried columns, causing slow performance.
- Neglecting to set appropriate data types and constraints, such as not defining a primary key or allowing NULL in essential fields, which compromises data integrity.
- Confusing primary and foreign keys.
- Using incorrect SQL syntax.
- Not normalising tables properly.
- Misconception: 'All computer problems are hardware issues.' Correction: Many issues are software-related, such as driver conflicts, corrupted files, or misconfigured settings. Systematic troubleshooting should always start with software checks before assuming hardware failure.
- Misconception: 'Networking is just about connecting cables.' Correction: Networking involves complex protocols, addressing schemes, and security considerations. Understanding concepts like DHCP, DNS, and subnet masks is essential for effective network management.
- Misconception: 'Databases are just spreadsheets.' Correction: Databases are designed for efficient storage, retrieval, and manipulation of large datasets using structured query language (SQL). They enforce data integrity through relationships and constraints, unlike flat-file spreadsheets.
Frequently Asked Questions
Common questions students ask about this topic
Pass / Merit / Distinction Evidence Checklist
How your portfolio evidence is graded for CITY & GUILDS LIMITED Fundamentals of Database administration
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.
Pass (P)
Demonstrate baseline knowledge, accurate terminology, and core practical application.
Merit (M)
Provide detailed analysis, structured explanations, and clear workplace reasoning.
Distinction (D)
Deliver thorough evaluation, original problem solving, and fully justified recommendations.
Before You Start
Prior knowledge that will help with this topic
- •Basic computer literacy: Familiarity with using a computer, managing files, and navigating the internet.
- •Mathematics at Level 1 or GCSE grade D/3: Understanding of basic arithmetic and logic is helpful for topics like binary numbers and subnetting.
- •English at Level 1 or GCSE grade D/3: Ability to read and comprehend technical documentation and write clear answers.
Coursework AI Review
Paste your assignment brief and check your draft against its P/M/D criteria
Key Terminology
Essential terms to know
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
- Know core database concepts, Know how to create database objects, Know how to manipulate data, Know how data is stored in a database, Know database administration, Be able to create and configure a database
Ready to learn?
AI-powered learning tailored to this unit