Exam (elaborations)
BCOR 2020 EXAM 2 Questions and Correct Answers 2024/2025 | Graded A+
- Course
- Institution
BCOR 2020 EXAM 2 Questions and Correct Answers 2024/2025 | Graded A+
[Show more]
Content preview
BCOR 2020 EXAM 2What are what-if models? - ANSwhat if models are spreadsheets used for decision making;
mathematical and logic based models
Building good spreadsheet models - ANSinfluence diagrams; building a mathematical model;
spread sheet design and implementing the model in a spreadsheet
Data - ANSraw facts; numbers, letters, etc; audio video, image
Information - ANSa collection of data organized in such a away that they have value beyond the
facts themselves
Knowledge - ANSawareness and understanding of a set of information and the ways it can be
made useful to support a task
Value of information - ANSthe value of information is directly linked to how decision makers
achieve organizational needs
Characteristics of Quality information - ANSinformation should be accurate or complete
What is IS? - ANSan information system is a single set of hardware, software, databases,
networks, people and procedure that collect, manipulate, store, and process data into
information
What are the three types of information systems - ANS- Personal IS
- Group IS
- Enterprise IS
Value Chains - ANSA series of activities that an organization performs to turn inputs into outputs
Supply Chain - ANSkey value chain in a manufacturing organization
What is a database? - ANSan organized collection of data
What does DBMS stand for? - ANSDBMS stands for data base management system
What is DBMS? - ANSa group of programs that manipulate the database and provide an
interface between the database and its users and other application processes
Hierarchy of data - ANSbit -> byte/characteristic -> field -> record -> file
, byte - ANSmade up of 8 bits
field - ANSname, number, or combination of characters that describes an aspect of a business
object or activity
record - ANSa collection of related data fields
file - ANSa collection of related records
Data entities - ANSa person, place, or thing for which data is collected, stored, and maintained
Attributes - ANSa characteristic of an entity
Keys - ANSa field or set of fields that uniquely identifies the record
Data Item - ANSthe specific value of an attribute
The database approach - ANSinformation systems share a pool of related data, offers the ability
to share data and information resources, a database management system is required
Data modeling - ANSa diagram of data entities and their relationships
Relational database model - ANS- a simple but highly useful way to organize data into collection
of two-dimensional tables called relations;
- columns - (vertical) represents an attribute of an entity
- rows - (horizontal) represents an entity
Database administration - ANSskilled and trained information system professionals
What does the database administration do? - ANSworks with users to define their data needs,
applies database programming languages to craft a set of databases to meet those needs, tests
and evaluates databases, implements changes to improve their databases performances, &
assures that data is secure from unauthorized access
Big Data - ANSextremely large and complex data collections
Characteristics of Big Data - ANSvolume, velocity, and variety
Challenges of Big Data - ANS- how to choose what subset of the data to store
- where and how to store the data
- how to find the nuggets of data that are relevant to the decision making at hand
- how to derive value from the relevant data
- how to identify which data needs to be protected from unauthorized access
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 QualityPDF. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81531 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now