Database Software
Database software involves planning, creating, and modifying relational databases, entering and organising data, and using queries and reports. This topic covers database design, data manipulation, and reporting tools.
Assessment criteria
Topic Overview
The City & Guilds Level 2 Diploma in ICT Systems Support is a vocational qualification designed to equip students with the practical skills and knowledge needed to provide effective technical support in an IT environment. This diploma covers a broad range of topics including computer hardware, software installation, networking fundamentals, security, and customer service. It is ideal for those looking to start a career as an IT support technician, helpdesk analyst, or field service engineer.
Throughout the course, you will learn how to diagnose and resolve common hardware and software issues, set up and maintain computer networks, and ensure data security. The qualification emphasizes hands-on, real-world scenarios, preparing you for the demands of the workplace. By the end of the diploma, you will be able to confidently support end-users, manage IT assets, and contribute to the smooth running of an organisation's ICT systems.
This diploma fits into the wider subject of Computer Science by providing a practical foundation in systems support, which is essential for maintaining the infrastructure that underpins all digital activities. It complements theoretical knowledge with applied skills, making it a valuable stepping stone to further study or direct employment in the IT sector.
Key Concepts
Core ideas you must understand for this topic
- →Hardware components: Understanding the function and installation of CPUs, RAM, hard drives, motherboards, and power supplies.
- →Operating systems: Installing, configuring, and troubleshooting Windows and Linux OS, including command-line tools.
- →Networking basics: IP addressing, subnetting, configuring routers and switches, and troubleshooting connectivity issues.
- →Security principles: Implementing antivirus software, firewalls, user authentication, and data backup procedures.
- →Customer service skills: Effective communication, ticket management, and remote support techniques.
Learning Objectives
What you need to know and understand
- Plan, create and modify relational database tables to meet requirements, Enter, edit and organise structured information in a database, Use database software tools to create, edit and run data queries and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
Assessment Criteria
Key criteria assessors look for in your portfolio
- Plan and create relational database tables to meet requirements.
- Modify tables, including adding fields and setting relationships.
- Enter, edit, and organise structured information in a database.
- Create and run data queries using SQL or query tools.
- Produce reports to present data effectively.
- Enters and edits data accurately in a database.
- Organises data using tables, queries, and relationships.
- Uses query tools to extract specific information.
- Produces formatted reports from database data.
- Create and modify database tables with appropriate field types.
- Enter and edit data accurately using forms or datasheet view.
- Use queries to filter, sort, and retrieve specific information.
- Generate reports that present data clearly and professionally.
- Apply data validation rules to maintain data integrity.
- Enter and edit data in a database.
- Organise information using tables and queries.
- Extract information using filters and queries.
- Produce reports from database data.
- Enter and edit data accurately in a database.
- Organise data using tables and relationships.
- Use queries to extract specific information.
- Produce formatted reports from database data.
- Enters and edits data accurately in a database.
- Organises information using tables, queries, and forms.
- Uses database software tools to extract specific information.
- Produces formatted reports from database data.
- Demonstrates understanding of data validation and integrity.
- Create and modify database tables with appropriate fields.
- Enter and edit data accurately.
- Use queries to extract specific information.
- Generate reports from database data.
- Apply data validation rules.
Assessment Guidance
Guidance for achieving higher grades
- 💡Normalise data to at least 3NF.
- 💡Test queries with sample data.
- 💡Use report formatting to improve readability.
- 💡Plan your database structure before entering data.
- 💡Use parameter queries to make reports interactive.
- 💡Test queries with sample data to ensure accuracy.
- 💡Practice using query design view to build complex queries.
- 💡Learn to use wildcards and logical operators in criteria.
- 💡Understand how to group and summarise data in reports.
- 💡Practice using different query types.
- 💡Ensure data integrity.
- 💡Use report wizards for consistency.
- 💡Practice creating relational databases with multiple tables.
- 💡Learn SQL basics for complex queries.
- 💡Understand how to use forms for data entry.
- 💡Practice designing tables with appropriate field types.
- 💡Learn to use wildcards and logical operators in queries.
- 💡Always check report layout before printing or exporting.
- 💡Normalise data to avoid duplication.
- 💡Use wildcards in queries for flexible searching.
- 💡Practice sorting and grouping data.
- 💡Always read the question carefully and identify the command words (e.g., 'describe', 'explain', 'list'). For 'explain' questions, give reasons or causes, not just a description.
- 💡In practical assessments, show your working step-by-step. If you are troubleshooting, note down each test you perform and its result – this demonstrates methodical thinking.
- 💡Use correct technical terminology (e.g., 'POST' instead of 'startup beeps') to show depth of knowledge. Avoid vague terms like 'thingy' or 'stuff'.
Common Mistakes
Common errors to avoid in your coursework
- Poor table design leading to data redundancy.
- Incorrect use of primary and foreign keys.
- Writing queries that return incorrect results due to logic errors.
- Failing to set appropriate data types and validation rules.
- Creating queries without proper criteria leading to incorrect results.
- Neglecting to normalise data to avoid redundancy.
- Creating tables without defining primary keys.
- Using incorrect data types leading to data entry errors.
- Designing queries without proper criteria, returning too many records.
- Poor data validation leading to errors.
- Inefficient query design.
- Formatting reports poorly.
- Not setting appropriate data types for fields.
- Creating duplicate records due to poor design.
- Using incorrect criteria in queries.
- Creating duplicate records due to lack of primary keys.
- Using incorrect query criteria leading to wrong results.
- Failing to back up data regularly.
- Poor table design leading to data redundancy.
- Incorrect query criteria producing wrong results.
- Not formatting reports for readability.
- Misconception: 'All hardware problems require replacing the component.' Correction: Many issues can be resolved by reseating connections, updating drivers, or checking power supply voltages.
- Misconception: 'Networking is only about cables and routers.' Correction: Networking also involves protocols (TCP/IP), DNS, DHCP, and security measures like VLANs and VPNs.
- Misconception: 'Backups are only needed for important files.' Correction: Regular full system backups are crucial for disaster recovery, including OS and application settings.
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 Database Software
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 understanding of computer hardware (e.g., what a CPU and hard drive do).
- •Familiarity with Windows operating system (e.g., navigating files, using Control Panel).
- •Elementary maths skills for IP addressing and binary calculations.
Coursework AI Review
Paste your assignment brief and check your draft against its P/M/D criteria
Key Terminology
Essential terms to know
- Plan, create and modify relational database tables to meet requirements, Enter, edit and organise structured information in a database, Use database software tools to create, edit and run data queries and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
- Enter, edit and organise structured information in a database, Use database software tools to extract information and produce reports
Ready to learn?
AI-powered learning tailored to this unit