Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
24 Cards in this Set
- Front
- Back
What is Data |
raw unorganized Facts |
|
What is Information |
Transformation of Data into meaning |
|
Examples of Data |
Orders processed How much of x is in stock Quantity Sold course enrollment customer name discounts |
|
Examples of Information |
-Using Ballpark data to send out personalized promotions -using crime stats to deploy law enforcement to high crime areas |
|
What is a transaction |
An exchange between actors |
|
What is transactional data |
Data that explains an event in real time Used for everyday events supports management of an organizations data |
|
Relational Paradigm |
How transactional data is collected and stored |
|
Primary goal of Relational Paradigm |
Reduce Errors and use less space Using less space less of an issue |
|
Dimensional Paradigm |
Data stored around an event and then summarized |
|
Characteristics of an operational Data store |
Store real time data Based off of relational paradigm optimize data for storage and efficiency support day to day operations |
|
Analytical Data Store and Goal |
Based on dimensional paradigm Storage of historical transactional data optimized for data retrieval and summerization GOAL Supports managerial decision-making for periodical analysis |
|
Relationship between operational and analytical data store |
Operational data store retrieves and organizes data for day to day activities analytical data store analyzes that data and puts it to use |
|
What does a model do, describe, and explain |
It is a representation of the information to be captured describes the data contained in the database Describes how the data interrelates |
|
System Analysis |
Process of modeling the problem Requirements oriented Define and Understand |
|
Question we are asking ourselves when performing system analysis |
What should we do? |
|
Systems Design |
Process of modeling a design Funcationality oriented Where we implement a design |
|
Question we ask ourself when performing a system design |
How should we do it |
|
Normalization |
Organizing data to reduce redundency |
|
Why is Normalization good? 5 reasons |
Reduces redundencies Data takes up less space Makes data easier to navigate Fewer inconsistencies Easier to make changes to data |
|
Atomic |
Can't break up data anymore |
|
1 to many rule |
Primary key from one goes into many entity as foreign key |
|
Many to many rule |
Create new table Primary keys in both tables are foreign keys in new table one to many relationships with original table |
|
one to one rule |
Primary keys in other fields as foreign key |
|
Example of many to many: Order many to product many, what is the new table and cardinality between the two? |
New table is order-product
one to many towards new table, one to one on old tables |