CBIS 2220 PROF RUTNER GCSU EXAM 2
QUESTIONS 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
QUESTIONS 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
