Computer
Architecture
Architecture
This part of the CPU performs calculations and logical comparisons
What is the ALU?
This type of attribute uniquely identifies each record in a table and cannot contain duplicate or null values, forming the foundation of relational integrity.
What is a primary Key?
This category of memory includes both volatile storage used for running programs and non-volatile storage containing essential startup instructions.
What is primary memory?
This structured process reduces redundancy and improves data integrity by decomposing large tables into smaller ones, typically progressing through 1NF, 2NF, and 3NF.
What is normalisation?
This particular type of primary memory comes in 3 different levels - and is in close proximity to the CPU.
What is cache memory?
This standard language allows users to retrieve, insert, update, and delete records; for example:
SELECT name FROM Students WHERE grade > 6;
What is SQL?
By allowing the CPU to fetch, decode, and execute multiple instructions simultaneously—each at a different stage—this technique increases instruction throughput without increasing clock speed.
What is pipe lining?
Range checks, type checks, and presence checks are examples of this process that ensures data entered into a database is accurate, sensible, and usable.
What is validation?
This type of system software converts low-level mnemonic instructions such as LOAD, ADD, and STORE into the corresponding machine code, enabling programmers to work with symbolic instruction sets rather than raw binary.
What is an assembler?
A table reaches this level of normalization when it is already in 2NF and all non-key attributes depend only on the primary key, not on other non-key attributes—eliminating transitive dependencies.
What is 3NF?