Info Systems and more!
Batch processing
I'm one of the 5 V's of big data. I represent the trustworthiness of data, i.e. Garbage in is Garbage out!
Hi, I'm the unique identifier in a table!
Primary Key
Help! I need to add a new product to the product table but I can't without it being associated with a product yet. What type of anomaly is this?
I'm the type of analytic that will make a recommendation on what to do next!
Prescriptive Analytic
Which cycle consists of - Give goods/services - Get Cash?
Revenue
Information
This type of schema is an enterprise wide view of the entire database
Conceptual Level Schema
Billy has created a customer table in a relational database. He says the Customer ID will be the primary key, but when I look at the table, there are some primary keys that don't have values. He broke this rule:
Entity Integrity - Primary Key cannot be null
You determined the total sales revenue for 2022! You must have done this type of analytic?
Descriptive Analytic
I'm the type of journal that records routine sales transactions
Specialized Journal
I'm data that probably hangs out in a data lake. Specifically I'm a tweet that contains a meme.
Unstructured Data
The four types of processing are: (Hint CRUD!)
Creating new records
Reading existing data
Updating previous record or data
Deleting data
For some reason, Jenny, one of our new employees, has multiple cities in the same field for her home address. This table has broken the rule of:
Atomicity - Every row in a column must be single valued
Your boss wants you to find out why there was a 32% increase quarter over quarter in marketing expense. You should run this type of analytic.
Diagnostic Analytic
I'm a list of all of a company's financial accounts within in AIS.
Chart of Accounts
I'm one of the 14 characteristics that makes data useful. Specifically, my characteristic means that two independent people can produce the same information
Verifiable
I'm the attribute that creates relationships in a relational database. Show some respect.
Foreign Key
For some reason Tina Treford shows up three times in my customer table. Once as Tina Treford, once as T. Treford and once as Teena Treford. This is what type of anomaly issue?
Update Anomaly
Your boss wants you to evaluate a new supplier. He wants you use past data to determine if you think the new vendor will be a good vendor, an okay vendor, or a bad vendor. You should run this type of analytic.
Predictive Analytic
Data languages:
Creating an empty table in a relational database requires the use of a ___________, and filling the table with data requires the use of a ___________________
DDL, DML
I'm one of the 14 characteristics that makes data useful. Specifically, my characteristic means that the data does not omit important aspects of events or activities
Complete
If a subsystems goals do not align with the goals of other subsystems or the system as a whole, this has occurred.
Goal Conflict
Invoice #35343 says that it is related to customer #118, however, there is no customer #118 in the customer table. This has broken which rule?
Referential Integrity
Edward notices that his total sales are down quarter over quarter so he drills down into the sales journal to see what transactions are driving the reduction.