Info Systems and more!
Data? I just met her
Exam 1 Potpourri
Toxic Relationships
100
Wendy's makes cash deposits at the bank twice a day.  This is an example of what type of processing?

Batch processing

100
This type of data modelling starts with one big table then breaks it down into relational tables!
Normalization
100

Hi, I'm the unique identifier in a table!

Primary Key

100

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?

Insert Anomaly
200

Which cycle consists of - Give goods/services - Get Cash?

Revenue

200
Simply put, I'm data with context

Information

200

This type of schema is an enterprise wide view of the entire database

Conceptual Level Schema

200

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

300

I'm the type of journal that records routine sales transactions

Specialized Journal

300

Information is often stored in an ERP...What does ERP stand for?

Enterprise Resource Planning

300

The four types of processing are: (Hint CRUD!)

Creating new records
Reading existing data
Updating previous record or data
Deleting data

300

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

400

I'm a list of all of a company's financial accounts within in AIS.

Chart of Accounts

400

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

400

I'm the attribute that creates relationships in a relational database.  Show some respect.

Foreign Key

400

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

500

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

500

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

500

If a subsystems goals do not align with the goals of other subsystems or the system as a whole, this has occurred.

Goal Conflict

500

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

M
e
n
u