Learn about the three main types of secondary storage - magnetic, optical and solid-state. Also, learn about the characteristics of secondary storage media including reliability and durability. Based on the J277 OCR GCSE Computer Science specification (first taught from 2020 onwards). 2.2: Secondary Storage Exam Board: OCR Specification: J277 Watch on YouTube : Secondary Storage Six Characteristics Magnetic Storage Optical Storage Solid State Storage Secondary storage is non-volatile storage used to save and store data that can be accessed repeatedly. Secondary storage is not directly embedded on the motherboard (and possibly even external ) and therefore further away from the CPU so it is slower to access then primary storage . Storage Characteristics you should know: CAPACITY : The maximum amount of data that can be stored on the device. DURABILITY : The strength of the device, to last without breaking . PORTABILITY : How easy it is to carry the device around . ACCESS SPEED : How quickly data on the device can be read or edited . COST : The average price it costs to purchase the storage device. RELIABILITY : The likelihood of the device continuing to perform well over time . Magnetic Storage A magnetic hard disk drive (HDD ) is the most common form of secondary storage within desktop computers. A read/write head moves nanometres above the disk platter and uses the magnetic field of the platter to read or edit data. An obsolete (no longer used) type of magnetic storage is a floppy disk but these have been replaced by solid state devices such as USB sticks which are much faster and have a much higher capacity. Another type of magnetic storage that is still used is magnetic tape . Magnetic tape has a high storage capacity but data has to be accessed in order (serial access ) so it is generally only used by companies to back up or archive large amounts of data . Magnetic Storage Characteristics (Hard Disk Drive): ✓ - Large CAPACITY and cheaper COST per gigabyte than solid state . ✓ - Modern external HDDs are small and well protected so they are DURABLE and PORTABLE , however because of the moving parts, they should not be moved when powered on because it can damage the device. X - Slower ACCESS SPEED than solid state but faster than optical storage . Optical Storage Optical storage uses a laser to project beams of light onto a spinning disc, allowing it to read data from a CD , DVD or Blu-Ray . This makes optical storage the slowest of the four types of secondary storage. Disc drives are traditionally internal but external disc drives can be bought for devices like laptops. Magnetic Disks are spelled with a k and Optical Discs have a c. Optical Storage Characteristics: X - Low CAPACITY : 700 MB (CD ), 4.7 GB (DVD ), 25 GB (Blu-ray ). X - Not DURABLE because discs are very fragile and can break or scratch easily. ✓ - Discs are thin and very PORTABLE . Also very cheap to buy in bulk. X - Optical discs have the Slowest ACCESS SPEED . Solid State Storage There are no moving parts in solid state storage. SSD s (Solid State Drives ) are replacing magnetic HDDs (Hard DIsk Drives) in modern computers and video game consoles because they are generally quieter , faster and use less power . A USB flash drive ( USB stick ) is another type of solid state storage that is used to transport files easily because of its small size. Memory cards , like the SD card in a digital camera or a Micro SD card in a smartphone , are another example of solid state storage. Solid State Characteristics: X - More expensive COST per gigabyte than magnetic . ✓ - Usually DURABLE but cheap USB sticks can snap or break . ✓ - The small size of USB sticks and memory cards mean they are very PORTABLE and can fit easily in a bag or pocket. ✓ - Solid State storage have a high CAPACITY and the fastest ACCESS SPEED because they contain no moving parts . Q uesto's Q uestions 2.2 - Secondary Storage: 1. Rank magnetic , optical and solid-state storage in terms of capacity , durability , portability , speed and cost . For example, magnetic has the highest capacity , then solid-state, then optical. This could be completed in a table . [15 ] 2. Justify which secondary storage should be used in each scenario and why it is the most appropriate: a. Sending videos and pictures to family in Australia through the post . [ 2 ] b. Storing a presentation to take into school . [ 2 ] c. Storing project files with other members of a group to work on together . [ 2 ] d. Backing up an old computer with thousands of files to a storage device. [ 2 ] 2.1 - Primary Storage Theory Topics 2.3 - Data Units

Learn about how to convert between the denary (decimal), binary and hexadecimal number systems. Based on the J277 OCR GCSE Computer Science specification (first taught from 2020 onwards). Exam Board: OCR 2.4a: Number Systems Specification: J277 Watch on YouTube : Binary and Denary Hexadecimal Number System Ranges Binary to Denary Denary to Binary Binary to Hexadecimal Hexadecimal to Binary Denary to Hexadecimal Hexadecimal to Denary What is binary? By now you should know that computer systems process data and communicate entirely in binary . Topic 2.3 explained different binary storage units such as bits (a single 0 or 1), nibbles (4 bits) and bytes (8 bits). Binary is a base 2 number system. This means that it only has 2 possible values - 0 or 1 . What is denary? Denary (also known as decimal ) is the number system that you've been using since primary school. Denary is a base 10 number system. This means that it has 10 possible values - 0, 1, 2, 3, 4, 5, 6, 7, 8, and 9 . Binary & Denary Convert from binary to denary: Convert from denary to binary: Hexadecimal What is hexadecimal? Hexadecimal is a base 16 number system. This means that it has 16 possible values - 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, A, B, C, D, E and F . Hexadecimal is used as a shorthand for binary because it uses fewer characters to write the same value . This makes hexadecimal less prone to errors when reading or writing it , compared to binary. For example, 100111101011 in binary is 9EB in hexadecimal. Hexadecimal only uses single-character values. Double-digit numbers are converted into letters - use the table on the right to help you understand. Binary to hexadecimal: Hexadecimal to binary: Converting from denary to hexadecimal / hexadecimal to denary To convert from denary to hexadecimal or from hexadecimal to denary , it is easiest to convert to binary first . However, it is possible to convert directly from denary to hexadecimal or directly from hexadecimal to denary . The videos below explain both methods . Denary to hexadecimal: Hexadecimal to denary: Watch on YouTube Watch on YouTube Watch on YouTube Watch on YouTube Watch on YouTube Watch on YouTube Q uesto's Q uestions 2.4a - Number Systems: 1. Explain why hexadecimal numbers are used as an alternative to binary . Use an example . [ 3 ] 2. Convert the following values from binary to denary : a. 00101010 b. 11011011 c. 01011101 d. 11101110 e. 01011111 [1 each ] 3. Convert the following values from denary to binary : a. 35 b. 79 c. 101 d. 203 e. 250 [1 each ] 4. Convert the following values from binary to hexadecimal : a. 11110101 b. 01100111 c. 10111010 d. 10010000 e. 11101001 [1 each ] 5. Convert the following values from hexadecimal to binary : a. C2 b. 8A c. DE d. 54 e. F7 [1 each ] 6. Convert the following values from denary to hexadecimal : a. 134 b. 201 c. 57 d. 224 e. 101 [1 each ] 7. Convert the following values from hexadecimal to denary : a. 32 b. A5 c. 88 d. C0 e. BE [1 each ] Click the banners below to try self-marking quizzes (Google Forms) on these topics. Binary to Denary: Denary to Binary: Binary to Hexadecimal: Hexadecimal to Binary: 2.3 - Data Units Theory Topics 2.4b - Binary Addition & Shifts

Learn about the main character sets - ASCII (American Standard Code for Information Interchange) and Unicode. Also, discover the five data types - character, string, integer, real and Boolean. Based on the 2020 Eduqas (WJEC) GCSE specification. 4.5: Character Sets & Data Types Exam Board: Eduqas Specification: 2020 What is a Character Set? A character set is a table that matches together a character and a binary value . Character sets are necessary as they allow computers to exchange data . Two common character sets are ASCII and Unicode . ASCII Unicode ( American Standard Code for Information Interchange ) 0100 0001 0100 0010 0100 0011 Uses Binary 128 Tiny Set of Characters Less Memory Required Per Character U+0042 U+0055 U+004E Uses Hexadecimal 36,536+ Large Set of Characters More Memory Required per Character What are the different data types? When programming, variables should be given appropriate data types . Character String Integer A single character , such as a letter, number or punctuation symbol. Examples: A sequence of characters , including letters, numbers and punctuation. Examples: A whole number . Examples: T 8 ? Harry Waters 14:50pm Ice Age 4 475 -8432 56732 Real Boolean Telephone numbers are always stored as a string , not an integer. True / False Yes / No 0 / 1 An answer that only has two possible values . Examples: A decimal number . Examples: 65.3 -321.1234 909.135 Be careful with punctuation. 32.10 is a real but £32.10 is a string. Q uesto's Q uestions 4.5 - Character Sets & Data Types: 1. What is a character set and why are they needed ? [ 2 ] 2. Describe 3 differences between ASCII and Unicode . [6 ] 3. State the 5 different data types . [ 5 ] 4. State which data type is most suitable for the following variables: a. Age [ 1 ] b. Surname [ 1 ] c. Height (in metres) [ 1 ] d. First Initial [ 1 ] e. Phone number [ 1 ] f. Right-Handed? [ 1 ] 4.4 Arithmetic Shift Theory Topics 4.6 - Graphical Representation

Learn how pseudocode and flowcharts are written as part of algorithms. This content is based on the 2016 Eduqas / WJEC GCSE Computer Science specification. Algorithms Pseudocode Pseudocode Pseudocode is not a specific programming language but a more general method of describing instructions . It should be unambiguous, and it should not resemble any particular kind of programming language (e.g. Python or Java), so it can theoretically be turned into real code in any language. Generally, pseudocode can be written in any way that is readable and clearly shows its purpose. However, the Eduqas exam board advises that pseudocode for the programming exam should follow the conventions below : Annotation { Write your comment in curly brackets} Define data type price is integer firstname is string Declare a variable's value set price = 100 set firstname = "Marcella" Input / output output "Please enter your first name" input firstname Selection (must have indentation) if firstname = "Steven" then output "Hello" + firstname elif firstname = "Steve" then output "Please use full name" else output "Who are you?" end if Iteration (while loop) while firstname ! = "Steven" output "Guess my name." input firstname repeat Iteration (for loop) for i in range 10 input item next i Define a subroutine Declare Sub1 [Subroutine content indented] End Sub1 Call a subroutine call Sub1 Flowcharts flowchart A flowchart can be used to visually represent an algorithm. The flowchart symbols are: Algorithm Example example Pseudocode {This is a program to see how many items you can buy in a supermarket before you spend over £100} total is integer, itemsentered is integer, itemprice is integer set total = 0 set itemsentered = 0 while total < 100 output "enter the price of the next item" input itemprice total = total + itemprice itemsentered = itemsentered + 1 repeat if itemsentered >= 20 then output "You are on your way to saving money." elif itemsentered => 30 then output "You're a real money saver." else output "Look for better deals next time." end if Stop Flowchart

Learn about troubleshooting tests and information to record when a hardware error occurs. Based on the 2016 OCR Cambridge Technicals Level 3 IT specification. 1.6 - Hardware Troubleshooting Exam Board: OCR Specification: 2016 - Unit 1 What is troubleshooting? Troubleshooting means to analyse and solve a problem with a computer system. Hardware troubleshooting refers to fixing an issue with the physical parts of the computer or any connected devices. Hardware issues might occur as a result of damage (intentional or accidental), power surges or malware . Steps to Take When an Error Occurs Try to identify the problem by looking for the simplest explanation first (e.g. checking the power supply) and ask the user questions about the issue. Create a theory about what the cause of the problem could be and prepare to test the theory using a series of troubleshooting tests . Create a troubleshooting plan and record the steps that are taken before moving on to the next test. Check the system works after each stage of the plan. Create a findings document that explains if and how the problem was fixed, for future reference if the problem occurs again. Documentation Technicians and help desk (see 3.5 ) staff should document , on a fault sheet , the following information regarding the issue: The fault itself (such as 'system not turning on'). The system in question. The user logged in at the time. Exact date & time the problem occurred. Symptoms of the issue (such as 'slow load times' or 'beeping'). Problem history - checking if it has happened to this system before. Back up documentation - Whether the data been backed up recently. Troubleshooting Tools The following tools can be used to identify an error so a technician has a greater understanding of the problem. Event Viewer Event Viewer is a type of utility software that lists detailed information about an error when one occurs. It can be used to work out how to fix the issue and will display both minor and major faults. Power On Self Test (POST) On start-up, a power on self test (POST) checks memory, power, hardware and cooling systems are all working properly. Beep codes signal if an error has been detected; 1 beep will sound for no error but if multiple beeps are heard then an error has been discovered. Ping Test This is a connectivity test between two computers. A message is sent to the destination computer and waits for a return message named the echo reply . This procedure can be repeated with other systems until the source of the problem is identified from a computer that does not reply . Q uesto's Q uestions 1.6 - Hardware Troubleshooting: 1. Summarise the 'Steps to Take when an Error Occurs ' section into your own top three tips for what to do when a hardware error happens . [3 ] 2. List 6 pieces of information that an IT technician should record when a hardware error has occurred . [6 ] 3. Briefly explain the purpose of three troubleshooting tools . [6 ] 1.5 - Communication Hardware 1.7 - Units of Measurement Topic List

Learn about the differences and characteristics of programs and applications. Resources based on Unit F160 (Fundamentals of Application Development) for the OCR Cambridge Advanced Nationals in Computing (H029 / H129) AAQ (Alternative Academic Qualification). Qualification: Cambridge Advanced National in Computing (AAQ) Unit: F160: Fundamentals of Application Development Certificate: Computing: Application Development (H029 / H129) 1.1 - Programs & Applications Watch on YouTube : Programs & Applications The terms 'program ' and 'application ' do not mean the same thing. A program performs individual operations while an application may use several programs together to create a functional tool for a user . For example, a program may calculate the total of a range of numbers . An example of an application is Microsoft Excel , which is spreadsheet software with a range of programs built in , including the ability to calculate totals , as well as many other functions . Programs and Applications Every topic in Unit F160 ( Fundamentals of Application Development ) comes with YouTube videos to help you learn . Some pages only have one video , while others have several . Programs Applications A program is a set of instructions that a computer can understand and execute to perform specific tasks . It is written in a programming language like Python or Java and instructs the computer how to perform individual operations . Programs can be simple (e.g. printing a message to the screen) or complex (e.g. managing a database or running a web server ). An application is a type of program designed to be user-friendly and help users complete specific tasks . Examples of applications include word processors (e.g. Microsoft Word), web browsers (e.g. Google Chrome) and mobile apps (e.g. Instagram). Applications are made up of one or more programs . Examples A program has a specific purpose , that is understood and executed by the computer . An example is a program that can sort data into alphabetical order . This may be used in an application like spreadsheet software . A video editing application may include several programs , each with a specific purpose , such as a program to import video , one to apply filters , another to edit audio and another to export the finished video . Characteristics Characteristics of a program: Programs are created using programming languages like Python or Java . They are translated into a format the computer understands and then run . Each program is designed to perform a specific function or set of functions . They may not have a user interface and may not require user interaction , such as an operating system's background processes . Programs may consist of smaller sub-programs that can be reused in different applications . Characteristics of an application: Applications are designed to meet user requirements . They are designed for specific tasks , such as editing photos or sending emails. Most have a user interface to provide a way for humans to interact with the application, e.g. menus and buttons . Applications may be designed to run on specific operating systems , such as an iPhone app designed for iOS. They may involve multiple programs working together . Devices that use Programs and Applications Every type of computer system will use programs and/or applications for different, specific purposes . Desktops and laptops run operating systems , software applications and utilities . Game consoles use applications for gaming , streaming and social features like group voice chats. Smart TVs use apps for streaming and browsing and programs for remote control . Smart speakers use programs to process voice commands , control smart home devices and play music based on user input . Smartphones and tablets use mobile apps for communication , games and productivity . AR (augmented reality ), VR (virtual reality ) and MR (mixed reality ) devices use programs to generate and manage 3D environments , track user movements and respond to inputs . Embedded systems like washing machines , smart fridges and cars use programs to manage their operations and interfaces . Q uesto's Q uestions 1.1 - Programs & Applications: 1. Explain the differences between a program and an application , using examples . [4 ] 2. Give 3 characteristics of a program and 3 features of an application . [6 ] 3. Briefly summarise how four different devices would use programs or applications . [4 ] As of 2025 , the Google Play Store has over 3.5 million apps and is close to reaching 150 billion downloads ! D id Y ou K now? Topic List 1.2 - Operating Systems

About CSNewbs Plus (CSN+) CSN+ is a premium collection of resources made for teachers that follows the Computer Science specifications covered on the website . Currently, these resources are in development , with the Eduqas GCSE resource pack arriving first, based on the Eduqas GCSE Computer Science 2020 specification . < Free zip folder download of all resources for Eduqas GCSE topic 1.1 (The CPU) *Updated Jan 2021* Resources included for each topic: Lesson Slides Starter activity (to print) Task resources (e.g. diagrams or worksheets to print) Task answers What is included in the CSNewbs+ GCSE collection? 39 presentation slides 39 starters 39 task answer documents 19 revision activity pages 7 topic tests & answers See below for more details: + Complete presentation slides for each of the 39 theory topics in the Eduqas GCSE 2020 specification . PowerPoint and Google Slides compatible. Activity resources to print . Including diagrams , tables and worksheets for lesson tasks . All answers included for teachers to use. Starter questions that recap the previous topic. For teachers to print before the lesson. All answers included in the lesson slides. 39 starters . Comprehensive answers for all lesson tasks . 39 task answer documents containing answers for over 100 lesson tasks for teachers to use . Revision templates for students to complete, to print on A3 paper . 19 pages and 7 revision lesson slides . Exercise book headings and the driving question (lesson focus) 7 end-of-topic tests with brand new questions . All answers included for teachers. What is included on the presentation slides? The following breakdown shows the presentation slides for 1.1 (The CPU): A title slide The content covered from the Eduqas GCSE specification Exercise book headings and the driving question (lesson focus) Answers to the starter activity questions Lesson objectives An explanation of the topic Clear explanations of the content First task. Students use slides or CSNewbs to complete. All answers on separate teacher document. Task 2. Table provided in teacher resource pack to print. Further explanations of the content Further explanations of the content with diagrams. Further explanations of the content with diagrams. Task 3. Answers in the teacher document. Plenary to check the students' understanding of the lesson topics. < Free zip folder download of all resources for Eduqas GCSE topic 1.1 (The CPU) *Updated Jan 2021*

Test your ability to create a more complex program in Python based on a given scenario. Perfect for students learning GCSE Computer Science in UK schools. Extended Task 2 Lottery 17 8 4 13 20 Create a program to simulate a lottery draw. First, create an appropriate print line to welcome the user to your lottery draw. Then let the user enter five numbers between 1 and 20. Next, randomise five numbers between 1 and 20. Check to see how many numbers match and output an appropriate response for each scenario (e.g. “You have not matched any numbers, better luck next time!”) Once you have made the base program implement subroutines and lists . Make it as efficient as possible and professional-looking. Use pauses to reveal each number one at a time like a real lottery draw to build suspense. For this task, you will need to create a document and include the following sections (with screenshots where appropriate): An introduction to explain the Purpose of your program . A List of Requirements for a successful program. Screenshots of your code (with comments in your code to show understanding). Testing – Create a plan to show how you will test your program and then explanations of any errors that you found and how they were fixed . An Evaluation of what worked, what didn’t, and how you met each of your requirements from your original list. Also, discuss further improvements that you could have made to improve your program. Example solution: Helpful reminders for this task: Inputting Numbers Random Numbers Logical Operators Subroutines ⬅ Extended Task 1 (Pork Pies) Extended Task 3 (Blackjack) ➡

Learn about the components of the Central Processing Unit (CPU) and Von Neumann architecture. Based on the J277 OCR GCSE Computer Science specification (first taught from 2020 onwards). Exam Board: Cambridge OCR 1.1a: The CPU Specification: GCSE - J277 Watch on YouTube : The CPU The function of each CPU component : Control Unit (CU ) Arithmetic Logic Unit (ALU ) Registers Cache What Von Neumann architecture is. What You Need to Know The Central Processing Unit The Central Processing Unit ( CPU ) is the most important component in any computer system. Like many computer components, it is attached to the motherboard . The purpose of the CPU is to process data and instructions by constantly repeating the fetch-execute cycle . CPU Components The Control Unit (CU ) sends signals to control hardware and coordinate the flow of data inside the CPU and across the computer . It also decodes instructions as part of the fetch-execute cycle . The Arithmetic Logic Unit (ALU ) performs mathematical calculations , logical operations and binary shifts . The results of calculations made by the ALU are stored in a register called the accumulator . A register is a temporary storage space for one piece of data , instruction or address . Different registers are used during the fetch-execute cycle . Cache memory stores frequently accessed data and instructions because it is much faster for the CPU to access (fetch from) than RAM . Computer Architecture The way a computer is designed and structured is known as its architecture . A common type of computer architecture is Von Neumann (pronounced Von Noy-man), named after mathematician John Von Neumann . Von Neumann Architecture Instruction Data RAM ADD 53 A computer with Von Neumann architecture stores both program instructions and data in the same memory (RAM ). This is different from other architectures that have an instruction memory and a separate data memory . Instructions (technically called the opcode ) and data (technically called the operand ) are not the same . An instruction is an action to perform and data is the value to be used. For example with the command 'ADD 43 ', ADD is the instruction and 43 is the data . Von Neumann architecture also contains the key CPU components of a control unit , arithmetic logic unit (ALU ), registers and cache memory . Q uesto's Q uestions 1.1a - The CPU: 1a. What does 'CPU ' stand for ? [1 ] 1b. What is the purpose of the CPU ? [ 2 ] 2. Draw a diagram of the CPU , and l abel the four main components . [ 4 ] 3. Describe the purpose of: a. The Control Unit [ 2 ] b. The ALU [ 2 ] c. The registers [ 2 ] d. Cache memory [ 2 ] 4a. Describe the key feature of Von Neumann architecture . [ 2 ] 4b. Explain how an instruction is different to data . [ 2 ] 1.1b - Fetch-Execute Cycle Theory Topics

Learn about the three elements of computational thinking - abstraction, decomposition and algorithmic thinking. Based on the J277 OCR GCSE Computer Science specification (first taught from 2020 onwards). 1.1: Computational Thinking Exam Board: OCR Specification: J277 There are three key components to computational thinking (smart problem solving): Abstraction is when you ignore unnecessary information and focus only on the important facts . Abstraction is used because it simplifies a problem to make it less complex . This makes it more straightforward to understand the problem and create a solution . Decomposition is when you break a problem down into smaller tasks so that it is easier to solve . Each individual problem can be separately tested and solved . Decomposition also enables different people to work on the different parts of a larger problem that can later be recombined to produce a full solution . Algorithmic thinking is the final stage as logical steps are followed to solve the problem . The problem is broken down using decomposition into smaller problems . The required data and relevant data structures are considered using abstraction . Watch on YouTube : Abstraction Decomposition Algorithmic Thinking Q uesto's Q uestions 1.1 - Computational Thinking: 1. What does the term 'abstraction ' mean? Why is it important ? [2 ] 2. What is meant by ' decomposition '? Why is it important ? [ 2 ] 3. What is algorithmic thinking ? What does it involve? [3 ] Theory Topics 1.2 - Designing Algorithms

A splash page for the previous Cambridge Technicals units - Unit 1 (Fundamentals of IT) and Unit 2 (Global Information). OCR Cambridge Technicals IT Level 3 These pages are based on content from the OCR Cambridge Technicals 2016 Level 3 IT specification . This qualification stopped in July 2025. The pages on the site will remain for at least two years. Unit 1 Fundamentals of IT Unit 2 Global Information

Learn database topics including entity relationships, keys, normalisation, capturing and exchanging data, SQL, referential integrity, transaction processing and ACID (atomicity, consistency, isolation, durability). Based on the OCR H446 Computer Science A-Level specification. Exam Board: OCR A-Level 3.2 - Databases Specification: Computer Science H446 Database Key Terms A database is an organised collection of data stored in tables , where each table represents an entity such as a customer or product . Each table is made up of records ( rows ), which store information about individual instances of that entity , and fields ( columns ), which hold specific attributes like names or prices . A primary key uniquely identifies each record , while a foreign key links records between tables to create relationships . Secondary keys use indexing to speed up searches and data retrieval . A flat file database stores all data in a single table or file , often in a simple format such as a spreadsheet or text file . It is easy to create and manage , making it suitable for small-scale applications . However, it can lead to data duplication and inconsistency because the same data may be repeated in multiple records . A relational database stores data in multiple related tables , linked together using primary and foreign keys . This design reduces data redundancy and improves data integrity by storing each piece of information only once . The main disadvantage is that relational databases are more complex to design and maintain , requiring more processing power and knowledge to manage effectively . ER Diagrams Relationships between entities are shown using an Entity–Relationship ( ER ) diagram , which illustrates connections between tables in a visual format . There are three types : many-to-many (e.g. Students to Teachers ) Capturing & Managing Data Data can be captured from sources such as forms , Optical Character Recognition (OCR ), Optical Mark Recognition (OMR ) and sensors . These methods allow information to be collected automatically or manually and entered into a computer system for processing . Data can be selected and filtered using tools like Query By Example (QBE ) or SQL commands . This allows users to retrieve only the specific records that meet certain criteria from a database . Data management involves manipulating stored information , such as performing arithmetic functions or adding , editing and deleting records . This ensures that the data remains accurate , up to date and useful for decision-making . Data can be exchanged (shared ) between systems using common file formats such as CSV and JSON . These formats make it easier to transfer data between different software applications or platforms while maintaining structure and meaning . Database Normalisation Database normalisation is the process of organising data in a database to reduce redundancy and improve data integrity . It ensures that each piece of data is stored only once , making updates and maintenance more efficient and reducing the risk of inconsistent data . Normalisation is measured in 'forms ': First Normal Form (1NF ): Ensures that all fields contain atomic (indivisible ) values and that there are no repeating groups in a table. Each table must have a primary key . Second Normal Form (2NF ): Builds on 1NF by ensuring that all non-key attributes depend on the entire primary key , removing partial dependencies . Third Normal Form (3NF ): Builds on 2NF by removing transitive dependencies , meaning non-key attributes depend only on the primary key and not on other non-key attributes . Flat File & Relational Databases one-to-one (e.g. Students to Lockers ) one-to-many (e.g. Tutor Group to Students ) Structured Query Language (SQL) SQL ( Structured Query Language ) is used to create , manage and manipulate data in databases . It allows users to retrieve specific data using commands such as SELECT , FROM and WHERE , often combined with logical operators like AND and OR to filter results . The LIKE command and wildcards such as * and % are used to search for patterns within text data . SQL also supports data modification through commands like INSERT (to add data ), DELETE (to remove data ) and DROP (to delete entire tables ). More advanced queries can use nested SELECT statements or JOIN commands to combine data from multiple tables for more complex analysis . Referential Integrity Referential integrity ensures that relationships between tables in a relational database remain consistent . It means that a foreign key in one table must always refer to a valid primary key in another table . Referential integrity is important as it: Prevents orphan records (e.g. doctors linked to a non-existent patient). Keeps relationships between tables valid . Ensures queries and reports remain accurate . ACID Rules Transaction processing refers to the handling of a sequence of database operations (a transaction ) that must be completed fully or not at all . It ensures that databases remain accurate and consistent even if errors or system failures occur during the process . The ACID rules define the key properties of reliable transactions : Atomicity : The transaction is all or nothing - it either completes fully or not at all . Consistency : The database must remain valid before and after the transaction by following the same rules . Isolation : Transactions are independent , so one cannot interfere with another . Durability : Once completed , a transaction’s changes are permanent , even if the system crashes . Watch on YouTube : Database key terms Flat File & Relational databases Entity relationship (ER) diagrams Capturing & managing data Database normalisation SQL Referential integrity Transaction processing (ACID) Q uesto's K ey T erms Database Keys & Relationships: field, record, table, primary key, composite key, secondary key, indexing, foreign key, entity relationship (ER) diagram, one-to-one, one-to-many, many-to-many, flat file database, relational database Capturing & Managing Data: form, OCR, OMR, sensor, query by example, SQL, CSV, JSON, electronic and non-electronic data transfer SQL: SELECT, nested SELECT, FROM, WHERE, LIKE, AND, OR, DELETE, INSERT, DROP, JOIN, *, % Normalisation: first normal form (1NF), second normal form (2NF), third normal form ( 3NF), partial dependency, non-key dependency Referential Integrity & ACID: referential integrity, transaction processing, ACID (atomicity, consistency, isolation, durability), record locking, redundancy D id Y ou K now? In 2013 the web portal / search engine company Yahoo! was hacked , with all 3 billion user accounts in their database compromised - the largest hack in history . Personal details such as names , email addresses and hashed passwords were taken , causing major reputational and financial damage to the company . 3.1 - Compression & Encryption A-Level Topics 3.3 - Networks