Chapter 2 Flashcards
(18 cards)
Critical Thinking
Analyzing and effectively breaking down an issue to make a decision or find a solution
Aspects of Critical Thinking (READ)
Hold hypotheses loosely and be willing to change them
Listen more than you talk (active listening)
Leave questions open ended
Be willing to challenge conventional thinking
Think on problems for a while
Ask deep follow up questions
Types of Systems (READ)
Accounting Information Systems
Supply Chain Management Systems
Customer Information Management Systems
Human Resources Management
Enterprise Resource Planning
Enterprise Resources Planning (ERP)
Systems that integrate core business processes into a single system to improve efficiency and decision making
4 Main Attributes in databases
Primary Keys
Foreign Keys
Composite Keys
Descriptive Attributes
Primary Keys
Columns that uniquely identify each record/row in a table
3 aspects of primary keys (READ)
They are unique
They cannot have null values
They should not change over time
Foreign Keys
Columns that reference the primary key in another table, establishing a relationship between the two tables
3 aspects of foreign keys (READ)
They link tables together
They must match an existing primary key
They do allow null values if the relationship is optional
Composite Key
A primary key that is made up of two or more columns/attributes in a table that when combined uniquely identify records in the table
When are composite keys necessary?
When there is no single column that can provide uniqueness on its own
ETL Definition
Extract
Transform
Load
Flat Files
Keeps all necessary data in one place
What are Flat Files inefficient for?
Complex Processes
What do Relational Databases ensure?
Ensure data integrity and consistency across multiple processes
4 reasons structured data should be kept in Relational Databases (READ)
Completeness
No redundancy
Enforcement of internal controls
Ease of communication and integration
Data Dictionary
Centralized file of descriptions for all of the data attributes of the data set
Key Ethical Issues for data collection and use (READ)
Privacy and consent
Data security
Responsible data use
Proper Risk Assessment
Quality safeguards and auditing
Third party compliance
