Spreadsheets, Databases (chapter 2)

Question 1

Primary Key

Answer 1

Primary keys in databases uniquely identify each record (row) in a table

Question 2

Foreign Key

Answer 2

A foreign key is when a primary key is refernecd to a different table. This is known as a foreign key, and creates a relationship between the tables.

Question 3

Data Redundancy

Answer 3

When data is repeated, e.g. names

Question 4

Cell

Answer 4

The intersection of a row and a column, holds one item of information

Question 5

Features of a spreadsheet

Answer 5

Cells, formulas, functions, fields, records, data.

Question 6

Formulas

Answer 6

Used to perform calculations in excel. type in “=” to activate. Can call other cells

Question 7

Functions

Answer 7

Functions are prebuilt formulas built into excel. e.g SUM, AVERAGE, COUNT, MEDIAN etc

Question 8

Fields

Answer 8

The columns in a spreadsheet (vertical)

Question 9

Records

Answer 9

The rows in a spreadsheet (horizonral)

Question 10

Query

Answer 10

Structured Query language (SQL). Used in web development, and establishing connections between data or information

Question 11

Data visualization

Answer 11

Used to present data in a graphical form, and help identify patterns and relationships in a large amount of data. Charts, graphs, histograms, tables

Question 12

Formats

Answer 12

Formats are related to the font type and size selected, background colour used and any other change of appearance.

Question 13

Convections

Answer 13

Conventions are general rules that are followed when using a particular format. The are standard rules (conventions) that need to be followed.

Question 14

Relationship Diagram

Answer 14

I have no idea (update)

Question 15

Chart drawing and analysis

Answer 15

Know how to draw and analyze a column chart, pie chart, line chart, scatterplot