N5CS: Database Analysis

By the end of this topic, what should you be able to identify and define from a description of a database problem?

• The programming language used

• The end user requirements

• The type of database management system

• The network infrastructure

Answer explanation

The end user requirements are what should be identified and defined from a description of a database problem.

What should you be able to define regarding a database problem by the end of this topic?

• The hardware requirements

• The software lifecycle

• The functional requirements

• The data analysis methods

Answer explanation

By the end of this topic, you should be able to define the functional requirements regarding a database problem.

What is a program in a database context?

• An ordered set of instructions for performing tasks using data

• A collection of data about one type of thing

• An organized collecton of data for easy access

• A user interface for managing documents and images

Answer explanation

An ordered set of instructions for performing tasks using data is what a program is in a database context.

What does data refer to in a computing context?

• Only numerical and statistical information

• Instructions for computer operations

• Anything that can be used by a computer and isn't a program

• The physical components of a computer

Answer explanation

In a computing context, data refers to anything that can be used by a computer and isn't a program, making this the correct choice.

What is a database?

• A program that manages computer hardware

• An unorganized collection of random data

• An organized store of data for easy access, management, and updates

• A tool for creating visual presentations

Answer explanation

A database is an organized store of data for easy access, management, and updates, making it the correct choice.

What is a table in the context of databases?

• A graphical representation of data

• A set of instructions for database management

• A single collection of data about one type of thing

• The physical place where a database is stored

Answer explanation

A table in the context of databases is a single collection of data about one type of thing.

What is an attribute in a database table?

• A set of related data about an entity

• A type of database

• A single piece of data about an entity

• The title of the table

Answer explanation

An attribute in a database table refers to a single piece of data about an entity, making it the correct choice among the options provided.

What represents information on a record in a database table?

• A column

• A row

• A table title

• A database name

Answer explanation

A row represents information on a record in a database table. Each row contains data related to a specific record.

What are rows in a table also called?

• Fields

• Records

• Attributes

• Tables

Answer explanation

Rows in a table are also called records. Records represent individual entries in a table, each containing a set of related data.

What are columns in a database table also called?

• Fields

• Records

• Attributes

• Tables

Answer explanation

Columns in a database table are also called Fields, which represent the individual pieces of data stored in the table.