Skip to content

CMA Intermediate · Financial Management and Business Data Analytics · Data Processing, Organisation, Cleaning and Validation

A finance team stores each customer as one row, with columns for Customer ID, Name, Credit Limit and Region. In the language of data organisation, each column in this table is best described as a:

Each column in a table is a field, also called an attribute, because it holds one kind of information for every record. The rows are the records. A primary key is only one special field, and the schema is the whole structure.

  1. ARecord
  2. BField (attribute)Correct
  3. CPrimary key
  4. DDatabase schema

Explanation

In a table, a row is a record (one entity) and each column is a field or attribute holding one type of information. A primary key is a specific field that uniquely identifies records, so it does not describe every column. A schema is the overall structure of the database.

Did you get it right without looking?

One question tells you little. A timed set on Data Processing, Organisation, Cleaning and Validation shows your real accuracy, how long you take and where you lose marks.

Practise Data Processing, Organisation, Cleaning and ValidationFree diagnostic mock

More Data Processing, Organisation, Cleaning and Validation questions