Ch 4 Flashcards
Relational Databases
break data into separate tables
table
data organized into columns (fields)
and rows (records)
fields
variables, columns
records
unique instances, ID, rows
Entity Relationship (ER) diagrams
a graphical representation of relationships within an information system (how tables are connected)
Data integrity
truthful, relevant, faithfully represented (no error) data
Internal controls
checks that excel doesn’t offer
preventative controls
implemented to ensure that suppliers receiving checks are verified in the company’s system
What are the types of internal controls
preventative
access
reduced redundancy
access controls
table level security to indicate which employees have read/edit/write permission
reduced redundancy controls
cut down on errors by making sure each observation is only stored in one place
primary key
Unique identifier in each table (required in every table)
ex: Transaction_ID in Transaction Table
foreign key
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)
relevant data
has either predictive or confirmatory value
faithfully represented data
free from error, complete, neutral