T-Level DBS RCE 3 - Revision Quiz No 1

Deal with data for mapping and navigation

• Numeric

• Geospatial

• Logical

• Media

A data type for storing a single Yes or No Value

• Geospatial

• Numeric

• Boolean

• Temporal

Output from an information system that is returned to senior management

• Input

• Output

• Feedback Loop

• Storage

Used to convert the data into output that is meaningful

• Input

• Output

• Feedback Loop

• Processing

ERD stands for?

• Entity Relationship Diagram

• Entity Reality Diagram

• Entity Relational Diagram

• Erroneous Relationship Diagram

A field in a table that allows each record to be uniquely identified

• Foreign Key

• Primary Key

• Composite Key

• Master Key

Validation where the data is cross checked against a list to make sure the data is valid

• Format Check

• Length Check

• Type Check

• Lookup Table

Checks that the data being entered into the digital system is sensible and reasonable.

• Verification

• Validation

• Cross Checking

• Type Checking

calculated using a set of numbers and then added to the end of them

• Check Digit

• Length Check

• Format Check

• Range Check

What data format is held in one file

• Directory Based

• File Based

• RDBMS

• ERD