ICT REVISION

The definition of Model / Data model is:

•  

  A search for data

•  

  A digital data representation of a real-life scenario

•  

  A field in a database that is unique

•  

  A model that is interactive

A block of code that is used to perform a single, related action (example max(), min(), etc.)

• Formula

• Query

• Report

• Function

Raw information, values, facts and figures.

• Model

• Data sheet

• Database

• Data

Why the Book Name field cannot be a primary key?

• Primary key only accepts the same value.

• Book Name can be duplicated.

• Because this is unusual in database.

• None of them.

IF function in a spreadsheet, this evaluates (calculates) a condition and returns different values depending on whether it was True or False. Select the correct function format below:

• =IF(B4>=100, big, small)

• =IF(B4>=100,"big","small")

• =IF(B4>=100,"big":"small")

• =IF(B4>=100 "big" "small")

Something that is checked to determine whether it is true or false.

• Condition

• Field

• Query

• Report

A computer application that is used to organise data that can then be stored, processed and accessed electronically.

• Data collection software

• Data entry application

• Database

• Data-capture form

A value that is unique for every record in a database and can be used to identify a record.

• Primary key

• Record

• Query

• Database

In a table, the primary key must be a number.

• True

• False

Which field should be used as a primary key.

• Date Published

• Book ID

• Book Name

• Author