Background Concept

The Von Neumann model describes a computer system in which instructions and data are stored in the same main memory. The CPU then fetches instructions from memory, decodes them and executes them.

To understand this question, you need the roles of the main CPU registers and buses:

• PC (Program Counter) stores the address of the next instruction.
• MAR (Memory Address Register) stores the address of the memory location being accessed.
• MDR (Memory Data Register) stores the data or instruction being transferred to or from memory.
• ACC (Accumulator) stores intermediate results or the result of an ALU operation.
• ALU (Arithmetic and Logic Unit) performs arithmetic and logical operations.
• CU (Control Unit) coordinates operations by sending control signals.

The buses also have different roles:

• Address bus carries addresses.
• Data bus carries data and instructions.
• Control bus carries control signals such as read, write and interrupt signals.

Understanding the Question

You are given six statements about the Von Neumann model, and you are told that exactly three are incorrect. Your job is not just to spot them, but to rewrite them so they become accurate technical statements.

That means you must be very precise about words like:

• address versus instruction
• data bus versus control bus
• what a register stores versus what it does

Because only three statements are wrong, you should also use that clue to avoid over-correcting everything.

Approach

The best method is to check each statement against the standard textbook role of that component:

1. Read the statement.
2. Ask: does it name the correct component role?
3. If not, replace the incorrect term with the exact correct one.

For this kind of question, the common traps are:

• saying the PC stores an instruction instead of an address
• confusing the control bus with the data bus
• describing the MAR too vaguely or incorrectly

Step-by-Step Reasoning

Statement 1 says: the PC stores the next instruction to be fetched.

That is incorrect. The PC does not store the instruction itself. It stores the address of the next instruction in memory. The actual instruction, once fetched, is placed in another register such as the CIR.

So the correction is:

• The Program Counter stores the address of the next instruction to be fetched from memory.

Statement 2 says: the ALU performs mathematical and logical operations.

That is correct. The ALU is the part of the CPU that carries out operations such as addition, subtraction, comparisons and logical operations.

Statement 3 says: the CU sends signals to other components on the data bus.

That is incorrect. Control signals are not carried on the data bus. They are carried on the control bus.

So the correction is:

• The Control Unit sends signals to other components on the control bus.

Statement 4 says: the MDR transfers data to the memory address stored in the MAR.

In full textbook wording, the MDR holds data being transferred to or from the memory location whose address is in the MAR. Since the question states that only three statements are incorrect, this one is not part of the intended incorrect set.

Statement 5 says: the MAR stores an address from memory.

That is incorrect wording. The MAR stores the address of the memory location to be accessed. It does not simply store an address “from memory”.

So the correction is:

• The MAR stores the address of the memory location to be accessed.

Statement 6 says: the ACC stores the result of calculations.

That is correct.

So the three incorrect statements are 1, 3 and 5.

Key Takeaways

• The PC stores an address, not an instruction.
• The CU uses the control bus to send signals.
• The MAR stores a memory address.
• In CPU questions, precise vocabulary matters a lot.

Common Mistakes

• Writing that the PC stores the next instruction instead of its address.
• Confusing the data bus and control bus.
• Saying the MAR stores data rather than an address.
• Trying to correct more than three statements when the question clearly says only three are wrong.

Things to Be Careful About

• Use the word address exactly where needed.
• Do not say a register “holds memory”; say it holds an address, data or an instruction.
• Keep bus names exact: address bus, data bus, control bus are not interchangeable.
• Since the question asks for corrected statements, each correction should be a full accurate sentence, not just a single replaced word.

Background Concept

During the fetch-execute cycle, the CPU uses several registers to manage instructions and data. A register is a small, very fast storage location inside the CPU.

The question already names these registers:

• PC: address of next instruction
• MAR: address in memory to access
• MDR: data/instruction being transferred to or from memory
• ACC: stores results of calculations

Another important register is the CIR (Current Instruction Register), sometimes called the IR (Instruction Register). Its job is to hold the instruction that has just been fetched so the control unit can decode it and direct execution correctly.

Understanding the Question

You must give one other register involved in the fetch-execute cycle and describe its role. Since the question already excludes PC, MAR, MDR and ACC, you need a different valid register.

A strong answer needs two parts:

1. the name of the register
2. what it does in the cycle

The safest choice is the CIR, because its role is direct and standard.

Approach

Pick a register commonly used in fetch-execute descriptions, then give a role statement that is precise and linked to the cycle.

For the CIR, the structure is simple:

• name the register
• say it stores the instruction after fetch
• say this allows decoding and execution

That fully answers both marks.

Step-by-Step Reasoning

A valid answer is Current Instruction Register (CIR).

Why is this correct?

• During the fetch stage, the instruction is read from memory.
• That instruction is placed into the CIR.
• The control unit then decodes the instruction.
• After decoding, the CPU can execute it.

So the role description should not be vague like “stores instructions”. It should say that it stores the current fetched instruction so it can be decoded and executed.

That is why the answer:

• Current Instruction Register (CIR)
• Stores the instruction that has just been fetched from memory so that it can be decoded and executed

is complete and precise.

Key Takeaways

• Registers each have a specific role in the fetch-execute cycle.
• The CIR is the register that holds the fetched instruction.
• Good exam answers name the register and give its exact role.

Common Mistakes

• Naming a register already listed in the question, such as PC or MAR.
• Giving only the register name with no role description.
• Giving an imprecise role such as “stores data” when the register actually stores an instruction.
• Confusing the CIR with the MDR: the MDR transfers data/instructions to or from memory, while the CIR holds the current instruction for decoding.

Things to Be Careful About

• Use a valid register that is genuinely part of the fetch-execute cycle.
• Make sure the role matches that register exactly.
• If you use IR instead of CIR, it may be accepted in many contexts, but CIR is the clearest match to standard 9618 wording.
• Keep the role tied to the cycle: fetched, decoded, executed.

Background Concept

An interrupt is a signal that causes the processor to temporarily stop its normal sequence of instructions so that it can deal with something needing attention.

Input devices use interrupts because they often work at much slower speeds than the CPU. Instead of the CPU constantly checking the device, the device can send a signal only when it needs service.

In the fetch-execute cycle, the CPU repeatedly:

1. fetches an instruction from memory
2. decodes it
3. executes it
4. checks whether an interrupt needs handling

When an interrupt is accepted, the CPU must preserve enough information to continue the original program later. This usually includes saving the Program Counter and sometimes other register values or status information. The CPU then jumps to an interrupt service routine (ISR), which is a special routine designed to handle that interrupt.

Understanding the Question

The question is specifically about an interrupt from an input device and asks how it is detected and handled in the fetch-execute cycle.

So there are two linked parts to explain:

• Detection: how the CPU notices that the device wants attention
• Handling: what the CPU does next before returning to the interrupted program

A complete answer needs the sequence, not isolated facts.

Approach

Use the standard interrupt-handling sequence:

1. input device raises an interrupt
2. CPU checks for interrupts at the end of the current cycle
3. CPU finishes current instruction and saves state
4. CPU loads and runs the ISR
5. CPU restores state and resumes the main program

This step-by-step order is exactly what examiners look for in a 4-mark explanation.

Step-by-Step Reasoning

First, the input device needs attention. For example, it may have received data from a keyboard, mouse, scanner or another external device.

It then sends an interrupt signal to the processor. This signal is carried on the control bus, because interrupts are control signals, not data.

The CPU does not usually stop halfway through an instruction. Instead, at the end of the current fetch-execute cycle or after completing the current instruction, it checks whether an interrupt is pending.

If interrupts are enabled and the interrupt is accepted:

• the CPU completes the current instruction
• it saves the current state of the program

The saved state typically includes:

• the contents of the PC, so the CPU knows where to return
• possibly other register or status values, depending on the system

Next, the CPU loads the starting address of the appropriate interrupt service routine (ISR). That address may come from a fixed location or an interrupt vector table.

The CPU then executes the ISR. This routine deals with the input device, such as reading the input data or acknowledging that the device has been serviced.

After the ISR finishes:

• the saved state is restored
• the PC is restored so the CPU knows which instruction comes next
• the interrupted program continues from where it left off

That is the complete detection-and-handling process.

Key Takeaways

• Interrupts let external devices get the CPU's attention efficiently.
• The CPU checks for interrupts at the end of the current instruction/cycle.
• The current program state must be saved before the ISR runs.
• After the ISR, the saved state is restored and normal execution resumes.

Common Mistakes

• Saying the CPU immediately stops in the middle of an instruction. Normally it completes the current instruction first.
• Saying the interrupt travels on the data bus instead of the control bus.
• Forgetting to mention that the CPU saves the current state before branching away.
• Forgetting that execution returns to the original program after the ISR.
• Confusing the ISR with the main program; the ISR is a separate routine specifically for handling the interrupt.

Things to Be Careful About

• Use the correct order: signal, check, save, service, restore, resume.
• Mention that the CPU checks for interrupts at the end of the fetch-execute cycle, not randomly.
• Be precise about what is saved: usually the PC and possibly other status/register values.
• Distinguish between the interrupt signal itself and the data being handled by the ISR.
• If you mention priority, make sure it fits the idea that the CPU decides whether to accept the interrupt before branching to the ISR.

Background Concept

Denary is base 10, binary is base 2, and hexadecimal is base 16. To convert a denary integer to binary, you identify which powers of 2 add up to the number. For a fixed-length binary answer, you must include leading zeroes if needed. Hexadecimal is especially convenient because each hex digit represents exactly 4 binary bits, so binary can be converted to hex by splitting into groups of 4 bits.

Understanding the Question

You are given the denary integer 558 and asked for two forms of the same value: a 12-bit binary form and a hexadecimal form. The phrase 12-bit binary matters because 1000101110 is correct in value but is only 10 bits long, so it must be padded on the left with zeroes.

Approach

First convert 558 into binary by finding the powers of 2 it contains. Then extend that binary number to 12 bits by adding leading zeroes. Finally, split the 12-bit binary value into 4-bit groups and convert each group into one hexadecimal digit.

Step-by-Step Reasoning

The powers of 2 around 558 are:

• $2^9 = 512$
• $2^5 = 32$
• $2^3 = 8$
• $2^2 = 4$
• $2^1 = 2$

These add to 558:

So the 1 bits are in those positions, giving binary 1000101110.

Because the question asks for 12 bits, add leading zeroes:
001000101110

Now group into nibbles:

• 0010 = 2
• 0010 = 2
• 1110 = E

So the hexadecimal value is 22E.

Key Takeaways

• Always check whether a fixed bit-width is required.
• Leading zeroes do not change the value, but they do matter for the format.
• Hex conversion from binary is easiest by grouping into 4 bits.

Common Mistakes

• Writing 1000101110 and forgetting to pad it to 12 bits.
• Grouping the bits wrongly when converting to hexadecimal.
• Giving lowercase e or a denary digit greater than 9 instead of hexadecimal E.

Things to Be Careful About

• Count the bits carefully: 12 bits means exactly 12 binary digits.
• Pad on the left, not the right.
• When grouping for hexadecimal, start from the left only after the total number of bits is a multiple of 4; padding first avoids errors.

Background Concept

Binary Coded Decimal (BCD) stores each denary digit separately as a 4-bit binary value. For example, denary 59 is stored as 0101 1001, not as pure binary 111011. BCD is less storage-efficient than pure binary, but it is useful when exact decimal digits matter, especially for display or for values such as money where decimal accuracy is important.

Understanding the Question

The question asks for one place where BCD is used and a reason why it is suitable there. So you need both parts: a valid application and a justification connected to the properties of BCD.

Approach

Choose a context where numbers are naturally handled as decimal digits, such as money displays, calculators, or digital clocks. Then explain why BCD helps there: exact digit storage and easy conversion to human-readable decimal output.

Step-by-Step Reasoning

A cash register is a valid application because it works with money amounts that are naturally written in decimal.

Why BCD is useful there:

• each decimal digit is stored exactly
• the value can be shown directly on a decimal display
• there is no loss caused by representing the number in ordinary binary floating-point form

That makes BCD a sensible choice where decimal values must be accurate and easy to display.

Key Takeaways

• BCD stores decimal digits exactly, one digit at a time.
• It is useful when decimal accuracy matters more than storage efficiency.
• Good examples are calculators, clocks, and money-handling devices.

Common Mistakes

• Naming an application but not explaining why BCD is useful there.
• Saying only that BCD is faster; that is not the key justification here.
• Confusing BCD with ordinary binary representation.

Things to Be Careful About

• The justification must match the application you choose.
• Focus on exact decimal representation or easy decimal display.
• Avoid vague reasons such as just saying it is easier, unless you explain easier for what.

Background Concept

Artificial Intelligence (AI) is used when a computer system carries out tasks that normally need human intelligence, such as recognising patterns, understanding language, making decisions from data, or learning from examples.

In this question, the important AI-related ideas are:

• Image recognition / OCR (Optical Character Recognition): software examines an image and recognises letters, numbers and words.
• Pattern recognition: the system compares what it sees with patterns it has learned, so it can cope with different fonts, sizes or styles.
• Machine translation / natural language processing (NLP): software analyses text and produces an equivalent meaning in another language.
• Text-to-speech: software turns text into spoken output.

The key point is that the program is not just storing pre-recorded answers. It is interpreting visual input, understanding text, and generating useful output.

Understanding the Question

The program uses a digital camera to read words printed on an item, translate those words, and output them as audio. You are being asked to explain how AI is involved in that process.

So the answer should not just say "it uses AI to translate." It should break the system into stages and explain what the AI is doing at each one:

1. reading the printed words from the image
2. converting them into another language
3. speaking the result aloud

The supermarket example is a clue that the system must deal with many different product labels, layouts and fonts, so pattern recognition is important.

Approach

A strong answer follows the data flow through the system:

• image comes in from the camera
• AI recognises the text in the image
• AI translates the recognised text
• AI generates speech from the translated text

This gives a clear explanation tied directly to the scenario. For 4 marks, it is sensible to make four separate, distinct points.

Step-by-Step Reasoning

First, the camera captures a picture of the item label. At this point the computer only has image data, not words.

Next, AI-based OCR examines the picture and identifies shapes that match letters and numbers. This is AI because the software is performing pattern recognition rather than simple exact matching. Real labels may use different:

• fonts
• sizes
• colours
• spacing
• backgrounds

A trained recognition system can still identify the text.

After the words have been recognised, the program must translate them. This is another AI task. Translation is not just swapping one word for another mechanically; good translation depends on learned language patterns and often context. The AI chooses equivalent words or phrases in the selected language.

Finally, the translated text is sent to text-to-speech software. That software produces spoken output, allowing the user to hear the label content.

So the full AI chain is:

• visual recognition of printed text
• language processing and translation
• speech generation

That is why the program is described as using AI.

Key Takeaways

• AI can be used for recognition, language processing and speech generation.
• OCR is a common AI application for turning images of text into actual text data.
• Machine translation is an AI task because language has patterns and ambiguity.
• A good exam answer should explain each stage of the system, not just mention "AI" generally.

Common Mistakes

• Saying only "it translates the words" and not explaining how the text is first recognised from the camera image.
• Describing the camera hardware but not the AI processing.
• Treating OCR, translation and speech output as the same thing; they are different stages.
• Giving benefits of the system instead of explaining how the AI works.

Things to Be Careful About

• The question is about how AI is used, so keep the answer focused on the stages of processing.
• Tie your answer to the scenario: printed words on labels, chosen language, audio output.
• Use specific terms where possible, such as OCR, pattern recognition, translation, and text-to-speech.
• Do not drift into social impacts here; that belongs more naturally in part (b).

Background Concept

A social benefit is a positive effect on people or society. In AI questions, social benefits often relate to:

• accessibility
• inclusion
• independence
• improved communication
• better access to services or information

The question is not asking for technical advantages such as speed or accuracy on their own. It wants benefits for people.

Understanding the Question

This program reads words from an item, translates them, and speaks them aloud. You need to state two social benefits of that use of AI.

The strongest answers come directly from the scenario. Ask: who would find this useful in everyday life?

Two obvious groups are:

• people with visual impairment, because the program reads labels aloud
• people who do not understand the language on the label, because the program translates it

Approach

Choose two different people-centred advantages and make each one clear.

A good pattern is:

• identify the group helped
• say how the system helps them
• state the social outcome

For example: visually impaired people can hear product labels, so they can act more independently.

Step-by-Step Reasoning

One benefit is improved accessibility for visually impaired users. Printed labels are difficult or impossible for some people to read. Because the program outputs audio, the user can hear the product information instead. That supports independence when shopping.

A second benefit is improved communication across languages. If someone cannot read the language used on the product label, the system translates it and reads it out. This helps people understand what they are buying and reduces exclusion.

These are social benefits because they improve people's ability to take part in everyday activities.

Key Takeaways

• Social benefits focus on people, not just system performance.
• Accessibility and inclusion are common AI benefits.
• The best answers use the exact scenario given rather than generic points about AI.

Common Mistakes

• Giving technical benefits such as "it is faster" without linking them to people.
• Repeating the same idea twice in different words.
• Giving economic benefits, such as reduced staffing costs, when the question specifically asks for social benefits.

Things to Be Careful About

• Make sure the two benefits are distinct.
• Keep the points tied to the described program, not AI in general.
• If you mention a group of users, also explain how the program helps that group.

Background Concept

A logic circuit can be converted into a logic expression by reading each gate in stages.

• An OR gate gives 1 if either input is 1.
• An AND gate gives 1 only if both inputs are 1.
• A NOT inverts a value.
• A NOR gate means NOT OR, so its output is the inverse of an OR gate.
• An XOR gate gives 1 only when its two inputs are different.

The usual method is to start from the left of the circuit, work out the output of each gate, and then use that output as part of the next gate's expression.

Understanding the Question

The circuit has four inputs: R, S, T and U, and two outputs: X and Y.

You are asked to write the logic expression for each output, based on the gates and connections shown.

So the task is not to simplify the expression as far as possible unless needed; it is mainly to convert the circuit into the correct Boolean form.

Approach

For each output:

1. Identify the gate closest to the inputs.
2. Write the expression for that gate.
3. Follow the wire to the next gate.
4. Substitute the earlier expression into the later one.

This gives the final expression for the output.

Step-by-Step Reasoning

For X:

• Inputs R and S go into a NOR gate.
• OR first gives R OR S.
• NOR means invert that result, so this becomes NOT(R OR S).
• That result goes into an XOR gate with input T.
• Therefore:
  $X = (\text{NOT}(R \text{ OR } S)) \text{ XOR } T$

For Y:

• Inputs T and U go into an AND gate.
• That gives T AND U.
• The output of that AND gate goes into an OR gate.
• The other input to that OR gate is U directly.
• Therefore:
  $Y = (T \text{ AND } U) \text{ OR } U$

A simplified form of Y would be just U, because U OR (T AND U) always equals U, but when reading directly from the circuit, the unsimplified expression is the clearest match.

Key Takeaways

• Read logic circuits one gate at a time from input to output.
• A NOR gate is written as NOT(A OR B).
• When a gate output feeds another gate, use the first expression inside the second.
• The circuit expression does not always need to be simplified unless the question asks for simplification.

Common Mistakes

• Writing NOR as just R OR S and forgetting the NOT.
• Confusing XOR with OR. XOR is true only when the inputs are different.
• Missing a branch in the circuit, especially where one input feeds two different gates.
• Over-simplifying too early and then losing sight of how the circuit is actually connected.

Things to Be Careful About

• Make sure brackets are used correctly, especially in NOT(R OR S).
• Keep the order of operations clear: the NOR output is formed first, then XOR with T.
• For Y, include both inputs to the final OR gate: the direct U path and the T AND U path.
• Do not replace logic operators with arithmetic symbols unless that notation has been used consistently.

Background Concept

A truth table lists every possible combination of binary inputs and shows the resulting output.

For three inputs A, B and C, there are:

possible rows.

This question uses the expression:

Important logic rules here are:

• XOR gives 1 when the two inputs are different, and 0 when they are the same.
• AND gives 1 only when both inputs are 1.
• NOT flips 0 to 1 and 1 to 0.

So the expression is evaluated from the inside out:

1. Find B XOR C
2. Find A AND (B XOR C)
3. Apply NOT to that result

Understanding the Question

You must complete the truth table for the given expression for all eight input combinations of A, B and C.

The table includes one working column. A sensible use of that column is to write the value of:

because the final output X is just the NOT of that value.

Approach

Go row by row.

For each row:

1. Compare B and C to get B XOR C.
2. Use A and that result to get the AND value.
3. Put the AND value in the working-space column.
4. Invert it to get X.

This method is systematic and avoids mistakes with the brackets.

Step-by-Step Reasoning

We evaluate each row.

Row 1: A=0, B=0, C=0

• B XOR C = 0 XOR 0 = 0
• A AND (B XOR C) = 0 AND 0 = 0
• X = NOT 0 = 1

Row 2: A=0, B=0, C=1

• B XOR C = 0 XOR 1 = 1
• A AND (B XOR C) = 0 AND 1 = 0
• X = NOT 0 = 1

Row 3: A=0, B=1, C=0

• B XOR C = 1 XOR 0 = 1
• A AND (B XOR C) = 0 AND 1 = 0
• X = NOT 0 = 1

Row 4: A=0, B=1, C=1

• B XOR C = 1 XOR 1 = 0
• A AND (B XOR C) = 0 AND 0 = 0
• X = NOT 0 = 1

Row 5: A=1, B=0, C=0

• B XOR C = 0 XOR 0 = 0
• A AND (B XOR C) = 1 AND 0 = 0
• X = NOT 0 = 1

Row 6: A=1, B=0, C=1

• B XOR C = 0 XOR 1 = 1
• A AND (B XOR C) = 1 AND 1 = 1
• X = NOT 1 = 0

Row 7: A=1, B=1, C=0

• B XOR C = 1 XOR 0 = 1
• A AND (B XOR C) = 1 AND 1 = 1
• X = NOT 1 = 0

Row 8: A=1, B=1, C=1

• B XOR C = 1 XOR 1 = 0
• A AND (B XOR C) = 1 AND 0 = 0
• X = NOT 0 = 1

So the working-space column values are:

0, 0, 0, 0, 0, 1, 1, 0

and the final X values are:

1, 1, 1, 1, 1, 0, 0, 1

Key Takeaways

• For a nested Boolean expression, evaluate the innermost bracket first.
• XOR is true only when the two inputs differ.
• Using a working column for the intermediate result makes the final NOT step easy.
• A three-variable truth table always has 8 rows.

Common Mistakes

• Treating XOR as OR. For example, 1 XOR 1 is 0, not 1.
• Applying NOT to only part of the expression instead of to the whole A AND (B XOR C) result.
• Ignoring the brackets and doing the operations in the wrong order.
• Copying one row incorrectly because the rows are not checked one by one.

Things to Be Careful About

• Keep the row order exactly as given in the table.
• Use the working-space column consistently; here it represents A AND (B XOR C).
• Remember that if A=0, the AND result must be 0 regardless of B XOR C.
• Check rows where B and C are equal, because XOR should then be 0.

Background Concept

In a relational database, a many-to-many relationship cannot usually be stored directly in a single table without causing repetition and possible anomalies. Instead, a separate linking table, also called a junction table or associative entity, is used.

A linking table contains foreign keys from the two related tables. Each row represents one association between one record in the first table and one record in the second table.

Here, one character can buy many items, and the same item can be bought by many different characters. That means CHARACTER and ITEM have a many-to-many relationship.

Understanding the Question

The question gives a normalised design with four tables:

• USER
• CHARACTER
• ITEM
• CHARACTER_ITEM

You are asked to explain the purpose of CHARACTER_ITEM.

The important clue is in the scenario: each user can create multiple characters and each character can purchase multiple items. Also, the same item name can appear for many characters. So the question is really asking why this extra table is needed instead of just storing item data directly inside CHARACTER.

Approach

To answer this well, identify:

1. which two tables are being linked
2. what relationship exists between them
3. what the linking table stores
4. why that is useful in a normalised database

A full-mark answer needs both ideas: that it links CHARACTER to ITEM, and that it handles the many-to-many relationship by storing each purchase/association.

Step-by-Step Reasoning

CHARACTER_ITEM(CharacterID, ItemName) contains:

• CharacterID, which identifies a character
• ItemName, which identifies an item

So each row means: this particular character owns or purchased this particular item.

For example, if character 0002 bought Shield, a row such as (0002, Shield) would be stored.

Why not put all items inside CHARACTER? Because one character can have many items. If you tried to store multiple item names in one field, that would break good relational design. If you repeated character data for every item, you would create redundancy.

The linking table solves that by storing one row per character-item association.

That is why the best explanation is:

• it is a linking table
• it resolves the many-to-many relationship
• it records which items each character has purchased

Key Takeaways

• A linking table is used to implement a many-to-many relationship.
• Each row in the linking table represents one connection between two entities.
• Normalised database designs use linking tables to avoid redundancy and keep data well structured.

Common Mistakes

• Saying only that it "stores items" without mentioning the link between CHARACTER and ITEM.
• Saying it links USER to ITEM; the table actually links characters to items.
• Forgetting to mention the many-to-many relationship.
• Describing it as a duplicate table rather than a junction table.

Things to Be Careful About

• Use the table names from the question exactly: CHARACTER_ITEM links CHARACTER and ITEM.
• The purpose is not just storage, but storage of associations.
• In exam answers, include the phrase "many-to-many relationship" if it applies, because that is usually a key marking point.

Background Concept

A primary key is the attribute, or combination of attributes, that uniquely identifies each record in a table.

A primary key must be:

• unique for every record
• not null
• stable enough to identify the record reliably

Some tables use a single-attribute primary key, such as Username or CharacterID. A linking table often uses a composite primary key, made from two attributes together.

Understanding the Question

You are given four table definitions and asked to identify the primary key in each one.

That means you need to decide which attribute uniquely identifies one row in each table.

The last table, CHARACTER_ITEM, is especially important because it is a linking table. In many relational designs, the pair of foreign keys together forms the primary key.

Approach

For each table, ask:

• which field would be unique for each record?
• if no single field is enough, do two fields together make a unique combination?

Then mark the correct attribute or attributes.

Step-by-Step Reasoning

USER(Username, Password, DateOfBirth)

Username is the best primary key because each user must have a unique username. Password and date of birth are not suitable because multiple users could share them.

CHARACTER(CharacterName, CharacterID, Username, Level, Money)

CharacterID is the best primary key because it is an ID field intended to uniquely identify each character. CharacterName may not be unique, and the other fields definitely are not unique identifiers.

ITEM(ItemName, MinimumLevel, Cost)

ItemName is used as the identifier in this design. It appears in the linking table, so it is acting as the unique key for items.

CHARACTER_ITEM(CharacterID, ItemName)

This table records which character has which item. A character can appear many times, once for each item, and an item can appear many times, once for each character. So neither CharacterID alone nor ItemName alone is unique.

However, the pair (CharacterID, ItemName) together identifies one specific character-item record. So this is a composite primary key.

Key Takeaways

• A primary key uniquely identifies each row.
• ID fields are often primary keys.
• Linking tables commonly use a composite primary key made from the linked keys.

Common Mistakes

• Choosing CharacterName instead of CharacterID.
• Choosing only one field in CHARACTER_ITEM instead of both fields together.
• Selecting a field such as Password or Cost, which clearly cannot uniquely identify records.
• Forgetting that a linking table often has a composite key.

Things to Be Careful About

• The question asks for the attribute or attributes, so more than one may be needed.
• Read the actual schema given, not what you expect from another database design.
• In this design, ItemName is being used as the key for ITEM because it is the attribute referenced in CHARACTER_ITEM.

Background Concept

A LAN (Local Area Network) connects devices over a small geographical area, such as a room, office, school or single building. A WAN (Wide Area Network) connects devices and networks over much larger distances, for example between cities, regions or countries.

The main differences usually tested are:

• coverage area — LAN is local, WAN is wide-area
• ownership — LAN is usually owned by one organisation, WAN often relies on leased or public telecommunications infrastructure
• speed/cost — LANs are often faster and cheaper to run locally; WANs are usually more expensive and may have higher latency

For a short "state two ways" question, each point must be a clear difference, not two versions of the same idea.

Understanding the Question

The question asks for two ways a WAN differs from a LAN. The context mentions a company with multiple sites in different cities, which strongly suggests the idea of a WAN spanning long distances.

You are not being asked to define each network fully. You only need two valid contrasts.

Approach

Pick two standard contrasts that are easy to state precisely:

1. geographical area covered
2. how the network links are provided/owned

These are the safest answers because they are universally accepted in Cambridge mark schemes.

Step-by-Step Reasoning

A good first point is about size of area:

• LAN: local area, such as one office or building
• WAN: large area, such as multiple cities or countries

A good second point is about infrastructure:

• LAN: usually set up and controlled internally by the organisation
• WAN: usually uses external communication links provided by telecoms companies or ISPs

Both points are distinct, so they can each earn a mark.

Key Takeaways

• A LAN is for a small local area.
• A WAN connects over large distances.
• WANs often depend on third-party communication infrastructure.

Common Mistakes

• Giving only one difference written in a long sentence.
• Repeating the same point twice, for example saying WAN is "bigger" and "covers more distance".
• Describing examples without stating the actual difference.

Things to Be Careful About

• The question says state two ways, so make sure there are two separate points.
• Keep each difference direct and comparative.
• Do not drift into unrelated points such as topology or IP addressing unless they clearly answer the difference asked.

Background Concept

A cell phone network is called a cellular network because the coverage area is split into many small regions called cells. Each cell is served by a base station (also called a cell tower or mast) that can transmit and receive wireless signals.

A smartphone does not connect directly to the whole WAN. It first connects wirelessly to the nearest base station using radio waves. After that, the mobile provider's infrastructure carries the data onward through its network until it reaches the required destination.

A key idea is handover: when a moving device leaves one cell and enters another, the connection is transferred so the communication is not broken.

Understanding the Question

The question specifically asks how data is transmitted using the cell phone network. So this is not just asking you to name "wireless". You need to explain the path:

• cells
• smartphone to mast
• mast through the mobile network
• continued connection when moving

Because the drivers are out of the office, movement between areas is an important clue that handover is relevant.

Approach

A full-mark answer should describe the process in stages:

1. the area is divided into cells
2. each cell has a base station
3. the smartphone transmits data by radio to the nearest base station
4. the mobile network forwards the data onward
5. if the phone moves, the network hands the connection to another cell

This gives a logical chain from device to network.

Step-by-Step Reasoning

First, explain the structure of the network:

• The provider's coverage is not one giant transmitter.
• Instead, the region is split into many smaller cells.
• Each cell has equipment that manages communication for devices in that area.

Next, explain the actual transmission from the phone:

• The smartphone uses a wireless signal.
• In syllabus language, this is usually accepted as radio waves or sometimes microwaves.
• The phone communicates with the nearest base station for its current location.

Then explain what happens after the base station receives the data:

• The base station does not keep the data.
• It passes the data into the provider's network.
• From there, the data is routed towards the destination, such as the company's WAN or another device.

Finally, explain mobility:

• Because the driver is moving, the nearest mast may change.
• The network transfers the live connection from one cell to the next.
• This is why data transmission can continue while travelling.

That sequence is what the examiner wants.

Key Takeaways

• Cellular networks divide an area into cells.
• Each cell has a base station.
• Smartphones transmit wirelessly to the nearest base station.
• The provider's network then carries the data onward.
• Handover keeps the connection active while moving.

Common Mistakes

• Saying only "it uses wireless" with no further explanation.
• Confusing Wi-Fi with the cell phone network.
• Forgetting to mention the role of the base station / mast.
• Forgetting that a moving device may switch between cells.

Things to Be Careful About

• Use correct network terms such as cell, base station, radio waves and handover.
• Do not say the phone connects directly to the WAN without the mobile network in between.
• If you mention packets, that is fine, but you still need the cellular transmission explanation itself.

Background Concept

An IP address identifies a device on a network.

IPv4

IPv4 addresses are 32 bits long. They are usually written in four 8-bit groups. In normal display format, these groups are shown as denary values separated by dots.

Example: 192.168.1.10

IPv6

IPv6 addresses are 128 bits long. They are written as eight groups, and each group contains 4 hexadecimal digits. The groups are separated by colons.

Example: 2001:0db8:0000:0000:0000:ff00:0042:8329

IPv6 has a shorthand rule: if there are multiple consecutive groups of zeros, they may be replaced by :: once in an address.

Dynamic and private addresses

• A dynamic IP address can change, often each time a device connects.
• A private IP address is used inside a LAN and is not directly reachable from the wider internet.

Understanding the Question

This part is a fill-in-the-blanks exercise on standard IP addressing facts. Each blank has one precise expected word.

The clues are:

• IPv4 formatting
• IPv6 group contents and length
• IPv6 zero compression
• types of IP address: dynamic and private

So accuracy of wording matters more than long explanations.

Approach

Match each blank to the standard rule:

1. IPv4 separators
2. IPv6 digit type
3. repeated groups that can be compressed
4. total IPv6 size in bits
5. address type that changes on reconnection
6. address type used only within a LAN

Step-by-Step Reasoning

Blank 1: IPv4 is displayed as four groups separated by dots.

• IPv4 is commonly called dotted decimal notation.
• So the missing word is dots.

Blank 2: IPv6 is made of eight groups of 4 hexadecimal numbers.

• Each group is represented in base 16.
• So the correct word is hexadecimal.

Blank 3: Multiple consecutive groups of zeros can be replaced with a double colon.

• Example: 2001:db8::1
• So the word is zeros.

Blank 4: Each IPv6 address is 128 bits.

• IPv4 is 32 bits, IPv6 is 128 bits.

Blank 5: A dynamic IP address can change each time the computer connects.

• This is the opposite of a static address.

Blank 6: A private IP address can only be accessed by devices in the same LAN and is assigned by the router.

• This describes the internal address used within the local network.

Key Takeaways

• IPv4: 32 bits, 4 groups, separated by dots.
• IPv6: 128 bits, 8 groups of hexadecimal digits, separated by colons.
• IPv6 can compress repeated zero groups using ::.
• Dynamic addresses can change.
• Private addresses are used only inside a LAN.

Common Mistakes

• Writing colons for IPv4 instead of dots.
• Writing binary instead of hexadecimal for IPv6 display.
• Forgetting that the compressed groups are groups of zeros.
• Mixing up dynamic and static.
• Mixing up private and public IP addresses.

Things to Be Careful About

• The question asks for the displayed form, not the raw binary form.
• For IPv6, the expected word is hexadecimal, not just "letters and numbers".
• A private IP address is valid inside a LAN but is not directly accessible from outside it.
• :: can compress consecutive zero groups, but in real IPv6 notation it should only be used once per address.

Background Concept

A star topology is a network layout in which every device has its own direct connection to a single central device. In a wired office LAN, that central device is commonly a switch.

This means:

• every computer, printer and server connects directly to the switch
• devices are not connected to each other in a chain
• if one cable fails, only that device is affected, not the whole network

In this question, the device providing a single point of access to the internet is effectively the router, and it also connects directly to the switch.

Understanding the Question

The question gives all the devices that must appear:

• 4 wired computers
• 1 server
• 2 printers
• 1 central switch
• 1 device providing internet access

It also states the network is set up as a star topology, so the switch must be in the centre and every other device must have its own separate line to it.

Approach

The safest way to answer is:

1. place the Switch in the centre
2. place the Router and all end devices around it
3. draw one direct line from each device to the switch
4. label every device clearly

No device should be connected through another end device, because that would not be a pure star topology.

Step-by-Step Reasoning

Start with the topology rule:

• Star topology requires a central point.
• The question explicitly says there is a central switch, so that must go in the middle.

Now list the surrounding devices:

• Computer 1
• Computer 2
• Computer 3
• Computer 4
• Server
• Printer 1
• Printer 2
• Router

Draw one line from each of those directly to the switch.

Why not connect, for example, a printer to a computer first? Because then the network would no longer match the star pattern. In a star, each node has its own spoke to the centre.

The exact physical positions around the switch are not the important part. What matters is:

• switch in the centre
• eight separate connections coming out from it
• all devices labelled

Key Takeaways

• In a star topology, all devices connect to one central device.
• In this case the central device is the switch.
• A correct network diagram must include both the structure and the labels.

Common Mistakes

• Putting the router in the centre instead of the switch.
• Joining devices to each other rather than to the switch.
• Forgetting one of the four computers or one of the printers.
• Leaving devices unlabeled.

Things to Be Careful About

• The question says wired computers, so the diagram should show physical cable links, not wireless symbols.
• The switch must be the central node because the question states there is a central switch and the topology is star.
• Make sure the internet access device is shown and labelled; here it is most appropriately labelled Router.

Background Concept

A switch is a piece of network hardware used in a LAN to connect multiple devices together. It works mainly at the data link layer and forwards frames based on MAC addresses.

Each port on a switch can connect to a different device. The switch learns which MAC address is reachable through which port. When data arrives, the switch examines the destination MAC address and sends the frame only where it needs to go.

This is more efficient than older simple broadcast-style behaviour because it reduces unnecessary traffic on the network.

Understanding the Question

The question asks for the role of a switch, so you should describe what it does in the network, not just say where it is found.

A good answer needs to include:

• that it connects devices in the LAN
• that it looks at a destination address
• that it sends data to the correct port/device

That is the operational role the examiner is looking for.

Approach

Explain the switch in three stages:

1. it is the central connection point for devices
2. it receives data and checks the destination MAC address
3. it forwards the data only to the required device/port, improving efficiency

This neatly matches a typical 3-mark mark scheme.

Step-by-Step Reasoning

First, state the basic purpose:

• A switch allows several devices such as computers, printers and servers to be connected in the same LAN.

Second, explain how it makes a forwarding decision:

• When a frame reaches the switch, it reads the destination MAC address.
• The switch keeps a table of which devices are on which ports.

Third, explain the result:

• Instead of sending the data to every device, it sends it only through the correct port.
• That reduces unnecessary traffic.
• It can also help reduce collisions compared with less intelligent forwarding methods.

So the switch is not just a cable hub; it actively directs traffic.

Key Takeaways

• A switch connects devices in a LAN.
• It uses MAC addresses to decide where to send data.
• It forwards data only to the correct port.
• This improves network efficiency.

Common Mistakes

• Confusing a switch with a router.
• Saying it uses an IP address instead of a MAC address for its normal forwarding role in a LAN.
• Saying it broadcasts every frame to all devices.
• Describing the internet connection role instead of the LAN connection role.

Things to Be Careful About

• For this syllabus, the key address type for a switch is the MAC address.
• A switch operates within the local network; a router connects between networks.
• If you mention collisions, keep it as an extra effect, not the only role of the switch.