100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Information Systems Exam 1 University of Iowa Question and answers already passed 2024 R254,43   Add to cart

Exam (elaborations)

Information Systems Exam 1 University of Iowa Question and answers already passed 2024

 6 views  0 purchase
  • Course
  • Lowa
  • Institution
  • Lowa

Information Systems Exam 1 University of Iowa Question and answers already passed 2024 Information Systems Exam 1 University of Iowa Information systems - correct answer Technology that collects, processes, stores, analyzes, and disseminates info for a specific purpose Information Technolo...

[Show more]

Preview 3 out of 22  pages

  • August 30, 2024
  • 22
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • Lowa
  • Lowa
avatar-seller
Information Systems Exam 1 University
of Iowa
Information systems - correct answer ✔Technology that collects, processes,
stores, analyzes, and disseminates info for a specific purpose


Information Technology (IT) - correct answer ✔the hardware, software, and
media used to store, organize, retrieve and communicate info


Information system(IS) - correct answer ✔an organized combo pf hardware,
software,, infrastructure,, data and people that is used to accomplish a
specified organizational or personal objective


Transaction processing systems(TPS) - correct answer ✔monitors, collects,
and stores transaction data in real time


Capture and process detailed data necessary to update the organization's
records about fundamental business operations
Include order entry, inventory control, payroll, accounts payable, accounts
receivable, general ledger, etc.
TPS provides valuable input to :data analytic efforts
Management info systems
Decision support systems
Knowledge management systems


Business Intelligence systems (BI) - correct answer ✔analyze info for
complex,, non-routine decisions

,Dashboard - correct answer ✔provide up-to-date summaries of important
info for all levels of management


Decision support system (DSS) - correct answer ✔simulate multiple
scenarios to select best outcome ("what-if" analysis)


Online transaction processing(OLTP) - correct answer ✔Data processing in
which each transaction is processed immediately
At any time, the data in an online system reflects the current status


Structured Data - correct answer ✔Info that is easily displayed in titled
columns and rows which can easily be ordered and processed
This could be visualized,, as a perfectly organized filing cabinet where
everything is identified, labeled and easy to process
TPS data (often) stored in relational DB
Database software, often called a database management system (DBMS)
Oracle
SQL server
Access-- desktop


CRUD - correct answer ✔Create, Retrieve, Update, Delete


data storage - correct answer ✔Involves updating one or more databases
with new transactions
After being updated, this data can be further processed and manipulated by
other systems or modules


Tables - correct answer ✔Things we store info about

, Master data: customers, products
Transaction data: orders, receipts, deliveries
Collection of records


Attributes/fields - correct answer ✔pieces of info about an entity


Row/record/instance - correct answer ✔group of fields that describe some
object/person/event


Strengths of a database - correct answer ✔You can query in a database
Can sort,, filter, find and do calculations
Can do CRUD
SQL used for relational DBS
You can look up data from a database relatively rapidly
You can create meaningful reports from data in a database
Your data has a built-in structure to it
Information of a given type is always stored only once
Databases are concurrent: multiple users can use them at the same time
without corrupting data


The hierarchy of a relational database - correct answer ✔Database
A Datatable is a collection of related records
A Record is a group of related fields
A primary key is a type of attribute that uniquely identifies each record
An Attribute/field


Relational Database - correct answer ✔stores data in connected tables

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying this summary from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Academia199. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy this summary for R254,43. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

84190 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy summaries for 14 years now

Start selling
R254,43
  • (0)
  Buy now