Exam (elaborations)
CBIS 2220 PROF RUTNER GCSU EXAM 2 QUESTIONS AND ANSWERS WITH VERIFIED SOLUTIONS 2024
- Course
- Institution
CBIS 2220 PROF RUTNER GCSU EXAM 2 QUESTIONS AND ANSWERS WITH VERIFIED SOLUTIONS 2024
[Show more]
Seller
Follow
Content preview
CBIS 2220 PROF RUTNER GCSU EXAM 2QUESTIONS AND ANSWERS WITH VERIFIED
SOLUTIONS 2024
what are the five components of an information system? - ANSWER hardware, software, data,
procedures, and people
what is a database? - ANSWER a self-describing collection of interrelated, shared, and controlled data,
can be processed by one or more application systems, used to support the activities of a particular
organization, can be viewed as a repository of data (representing real-world things) that has a defined
structure and can be accessed by various users
what is a relational database? - ANSWER a type of database that stores data in tables (relations), each
table is composed of rows (tuples, records) and columns (fields, attributes), similar to a spreadsheet,
each row of a table has data about a particular occurrence or instance of the entity of interest, each
column of a table stores a characteristic or attributes common to all rows
what does a relational database store? - ANSWER a relational database not only stores data, but also
stores relationships
what is a database management system (DBMS)? - ANSWER a computer program used to create,
process, and administer one or more databases
ex: Microsoft Access, OpenOffice Base, MySQL, SQLServer, and lots more
what is a structured query language (SQL)? - ANSWER the internationally recognized standard database
language used to communicate with a DBMS, a programming sublanguage used within an application to
communicate with a DBMS
what are database applications? - ANSWER a set of one or more computer programs that serves an
intermediary between the user and the DBMS ex: web server
what is a foreign key? - ANSWER a designated field in one table that connects to the primary key in
another table
, what are some relationships? - ANSWER - One record in the _COURSE_ table can be related to _many_
record(s) in the _GRADE_ table.
- One course in the _COURSE_ table can have _many_ grades in the _GRADE_ table.
- One record in the _GRADE_ table can be related to _one and only one_ record(s) in the _COURSE_
table.
- One grade in the _GRADE_ table can be for _one and only one_ course in the _COURSE_ table.
what is data? - ANSWER means raw figures, metadata
what is information? - ANSWER means with context data become information, reveals relationships
between entities
what is knowledge? - ANSWER means with added meaning, reveals trends and patterns
what is wisdom? - ANSWER reveals ideas, principles, biases
what is a decision? - ANSWER course of action, implementation, monitoring, correction
what is data analytics? - ANSWER the scientific process of transforming data into insights for making
better business decisions
what are diagnostics? - ANSWER why did it happen? Analytic dashboards with drilldown capability,
correlations, regression models, cluster analysis
what does predictive mean? - ANSWER what is going to happen? Forecasting models, machine learning
models
what does prescriptive mean? - ANSWER what should we do? optimization, simulation
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller PASSINGPOINT. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.09. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
73091 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now