Databases - Recap Week 1

Spaced repetition is a learning technique that involves:

• repeating information at increasing intervals

• studying continuously without breaks

• learning multiple subjects at once

• focusing on one topic for a long time

A database is

• A database is a structured set of data held in a computer, especially one that is accessible in various ways.

• A database is a type of software used for browsing the internet.

• A database is a hardware device used for storing files.

• A database is a programming language used for developing applications.

Define a Database

• A shared collection of logically related data, and a description of this data, designed to meet the information needs of an organisation.

• A random collection of unrelated data.

• A single table of data.

• A collection of unrelated files.

What are the main problems that file-based systems encountered and that databases solved?

• Data redundancy and inconsistency

• Difficulty in accessing data

• Data isolation

• All of the above

Why is cross-referencing considered difficult?

• Because it requires finding and linking related information across different documents or sections.

• Because it involves simple tasks that are easy to manage.

• Because it is a complex process.

• Because it is not necessary in most cases.

What is a challenge in processing information to produce reports?

• Data accuracy

• Time constraints

• Resource allocation

• All of the above

What happens when data becomes duplicated in more than one location?

• Data integrity is maintained

• Data becomes inconsistent

• Data retrieval is faster

• Data storage is reduced

The limitations of the file based approach include:

• Data redundancy and inconsistency

• Difficulty in accessing data

• Data isolation

• All of the above

What is meant by 'Separation and isolation of data'?

• It refers to the process of keeping data distinct and inaccessible to unauthorized users.

• It is a method of combining data from different sources.

• It involves sharing data across multiple platforms.

• It is a technique for encrypting data.

The issue of 'Duplication of data' is:

• A problem where the same data is stored in multiple places, leading to inconsistencies.

• A method to ensure data is backed up in multiple locations.

• A technique to improve data retrieval speed by storing copies.

• A strategy to enhance data security by duplicating sensitive information.