Section 6: Data

Question 1

Database research

Answer 1

The act of analyzing and converting data into information that can be used in decision making

Question 2

Database table/ data sheet

Answer 2

Holds data in records and fields. Records are considered rows and fields are columns

Question 3

Y2K Problem

Answer 3

Dates had years stored as two digits in order to save space but with the year 2000 approaching all the years had to be converted to four digits to prevent mass malfunction of computers

Question 4

Primary key

Answer 4

Each record’s unique ID

Question 5

Foreign key

Answer 5

When a primary key has a different ID on another table

Question 6

Structured query language (SQL)

Answer 6

Includes queries to identify what data should be retrieved or how data should be manipulated

Question 7

Selection operation( SQL)

Answer 7

Takes rows from one table and creates a new table

Question 8

Union Operation (SQL)

Answer 8

Combines fields from multiple tables with the same data type

Question 9

Product Operation (SQL)

Answer 9

Creates a result operation with all attributes from two tables

Question 10

Join Operation (SQL)

Answer 10

Combines two tables with records with matching criteria

Question 11

Object database

Answer 11

A collection of objects each with two components: data and instructions. (“methods”)

Question 12

Key value database

Answer 12

Items are stored as an attribute name(“key”) together with its value

Question 13

Data lake

Answer 13

A system of data stored in raw format