GVSU MGT 268 exam 2 UPDATED ACTUAL Questions And Correct Answers
Terms in this set (98)
Adviser and Student relationship An N:M relationship
Structure of a database Metadata
Collection of forms, reports, queries, and application Database application
programs
Purpose of a database Is to keep track of things
Logical representation of the data in a database Data model
Database management system Is a program used to create, process, and administer a database
Process of converting poorly structured tables Normalization
Lists that involve data with multiple themes Database
Components of an entity-relationship data model Attributes describe the characteristics of entities
Relationship between Student and Locker 1:1
Tables not normalized Tables have a format that could cause data integrity problems
Keys that reside in a table Primary keys cannot be duplicated in a table
Relationship between Department and Adviser 1:N relationship
Program used to create, process, and administer a Database Management System (DBMS)
database
Logical representation of data and relationships Data model
Used to read, insert, modify, and delete data Data entry forms
Best describes reports Show data in a structured context
Request executed to retrieve data from a database Query
Used to create databases and database structures Structured Query Language (SQL)
Miles requested sales data for market-basket analysis Granularity
Data sorted, grouped, and averaged Descriptive analytics
, Digital replication of an object using real-time data Digital twin
Main problem with NoSQL databases Data redundancy
Process of acquiring, analyzing, and publishing data Analytics
Dataset listing '12345' as a person's name Dirty data
NOT part of data acquisition Reporting data
A measure A data item that can be summed, averaged, or otherwise processed
Information system supporting acquiring, analyzing, and Information system
publishing data
The five components of an analytics information system Hardware, software, data, procedures, people
are _____ _.
A facility for managing an organization's analytics data is a Data warehouse
__________.
Analytics IS user challenges exclude _____ _. Failure to define project objectives
Analytics aim to discover patterns in data that aid True
decision processes.
An effective analytics process informs business people Efficient analytics
within time and cost constraints.
Analytics pursues what objective besides effectiveness Efficiency - time and cost constraints
(informing)?
Analytics means _____ _. Acquiring, analyzing, and publishing data to discover useful patterns
Main activities in analytics process sequence are ______ _. Acquire data → Analyze data → Communicate results
Retailer analyzing why profits fell last quarter is using Diagnostic analytics
______ analytics.
Analytics provides competitive advantage because It enables data-driven strategies that outperform intuition-based decisions
__________.
StudentID is an example of a(n) ______. Identifier
Before developing a database design, create a _____ _. Data model
Forked lines on an ERD relationship represent _____ _. Crow's feet notation (showing cardinality)
Terms in this set (98)
Adviser and Student relationship An N:M relationship
Structure of a database Metadata
Collection of forms, reports, queries, and application Database application
programs
Purpose of a database Is to keep track of things
Logical representation of the data in a database Data model
Database management system Is a program used to create, process, and administer a database
Process of converting poorly structured tables Normalization
Lists that involve data with multiple themes Database
Components of an entity-relationship data model Attributes describe the characteristics of entities
Relationship between Student and Locker 1:1
Tables not normalized Tables have a format that could cause data integrity problems
Keys that reside in a table Primary keys cannot be duplicated in a table
Relationship between Department and Adviser 1:N relationship
Program used to create, process, and administer a Database Management System (DBMS)
database
Logical representation of data and relationships Data model
Used to read, insert, modify, and delete data Data entry forms
Best describes reports Show data in a structured context
Request executed to retrieve data from a database Query
Used to create databases and database structures Structured Query Language (SQL)
Miles requested sales data for market-basket analysis Granularity
Data sorted, grouped, and averaged Descriptive analytics
, Digital replication of an object using real-time data Digital twin
Main problem with NoSQL databases Data redundancy
Process of acquiring, analyzing, and publishing data Analytics
Dataset listing '12345' as a person's name Dirty data
NOT part of data acquisition Reporting data
A measure A data item that can be summed, averaged, or otherwise processed
Information system supporting acquiring, analyzing, and Information system
publishing data
The five components of an analytics information system Hardware, software, data, procedures, people
are _____ _.
A facility for managing an organization's analytics data is a Data warehouse
__________.
Analytics IS user challenges exclude _____ _. Failure to define project objectives
Analytics aim to discover patterns in data that aid True
decision processes.
An effective analytics process informs business people Efficient analytics
within time and cost constraints.
Analytics pursues what objective besides effectiveness Efficiency - time and cost constraints
(informing)?
Analytics means _____ _. Acquiring, analyzing, and publishing data to discover useful patterns
Main activities in analytics process sequence are ______ _. Acquire data → Analyze data → Communicate results
Retailer analyzing why profits fell last quarter is using Diagnostic analytics
______ analytics.
Analytics provides competitive advantage because It enables data-driven strategies that outperform intuition-based decisions
__________.
StudentID is an example of a(n) ______. Identifier
Before developing a database design, create a _____ _. Data model
Forked lines on an ERD relationship represent _____ _. Crow's feet notation (showing cardinality)
