Ch 4 Flashcards

1
Q

Relational Databases

A

break data into separate tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

table

A

data organized into columns (fields)
and rows (records)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

fields

A

variables, columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

records

A

unique instances, ID, rows

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Entity Relationship (ER) diagrams

A

a graphical representation of relationships within an information system (how tables are connected)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Data integrity

A

truthful, relevant, faithfully represented (no error) data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Internal controls

A

checks that excel doesn’t offer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

preventative controls

A

implemented to ensure that suppliers receiving checks are verified in the company’s system

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the types of internal controls

A

preventative
access
reduced redundancy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

access controls

A

table level security to indicate which employees have read/edit/write permission

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

reduced redundancy controls

A

cut down on errors by making sure each observation is only stored in one place

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

primary key

A

Unique identifier in each table (required in every table)
ex: Transaction_ID in Transaction Table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

foreign key

A

Exist to create relationships or links between two tables (not necessarily required in every table but if there is one, there must be a matching primary key in another table)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

relevant data

A

has either predictive or confirmatory value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

faithfully represented data

A

free from error, complete, neutral

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How to connect data in excel (ETL)

A

Extract data from files, databases, the internet, and other sources
Transform data into different data types, clean data, and combine and filter data.
Load data into other tools for further analysis.