WorksheetsRevision Quiz 1
Total questions: 15
Worksheet time: 11mins
Put the key steps for decomposition into order
Identify and describe problems and processes
Break down problems into tasks and sub-tasks
Describe tasks and sub-tasks
Communicate
What is top-down decomposition?
Top-down decomposition is a problem-solving method that starts with the main problem
What is bottom-up decomposition?
Bottom-up decomposition is a problem-solving method that starts with the main problem
Bottom-up decomposition is a bottom-up approach to problem-solving.
Bottom-up decomposition involves solving problems from the middle outwards.
Bottom-up decomposition is a problem-solving method that starts with the smallest subproblems.
Which of these IS a benefit of modularisation when decomposing a task?
Increased complexity in maintenance
More code readability
Easier debugging, reusability of code
When tasks in a process are independent of each other this is called (a) . This is part of (b) . When doing this, (c) can often help speed up solutions.
Who does GDPR affect?
Businesses in the EU
Anyone in the world, holding any data
Only governments and public bodies
Any business holding data on EU citizens, regardless of location
What is a link entity in an ERD?
An entity that represents a website
An entity that represents a system
An entity to resolve many-to-many relationships
An entity to resolve 1-to-many relationships
Match the Database Model to the correct description
Conceptual model
A broad overview that is abstract
Logical model
Detailed view without technical info
Physical model
Detailed view containing technical info
Which of these is not a characteristic of Big Data?
Volume
Variety
Velocity
Value
Which of the following is not a challenge of Big Data?
Data Storage
Data Analysis
Data Security
Data Duplication
Why can big data not be stored in a database?
Which of these is not part of the structure of a relational database?
Field
Record
What is the process of breaking down database tables into two or more tables to reduce data redundancy called?
Transaction Processing
What does serialisation mean in the context of database operations and transactions?
Ensuring concurrent execution of transactions without effects on each
