MSIS 2103 Exam 2 questions with
verified answers
entity relationship diagram - correct answer ✔✔shows the relationships between the tables in a
database
primary key - correct answer ✔✔a unique identifier of every row or record in the table
record primary key - correct answer ✔✔normally assigned sequentially by the database as a
new record is input into the table
relational database can have - correct answer ✔✔one to one relationship or a one to many
metadata - correct answer ✔✔defines what can go into a particular field and how it has to be
formatted
database management system (DBMS) - correct answer ✔✔a software that is used to create a
database, define fields formatting, define database business rules, and modify the database
structure
enterprise system - correct answer ✔✔have a single database and each application accesses the
same database
Enterprise Resource Planning (ERP) system - correct answer ✔✔often used by businesses that
manufacture products
, customer relationship management (CRM) - correct answer ✔✔Service companies and sales
companies often use CRM systems
supply chain management (SCM) - correct answer ✔✔Companies that are involved in logistics
and distribution would often use an SCM
distributed file system (DFS) or NoSQL database - correct answer ✔✔server-based system that
allows for massive amounts of data
A relational database cannot have a many to many relationship between entities. - correct
answer ✔✔False
Because a properly designed relational database only has single data entry, variables that can be
calculated are not in the database. - correct answer ✔✔False
The DBMS is used to create database business rules - correct answer ✔✔True
A manufacturing company that uses an enterprise information system will likely use - correct
answer ✔✔ERP
Heuristics are - correct answer ✔✔qualitative methods that are experience based
insensitive to prior outcomes - correct answer ✔✔Your resume showed that you had been a top
performer in your current job for several years and the interviewer formed an opinion based on
whom you reminded him of
insensitivity to prior probabilities - correct answer ✔✔This bias comes from forming an opinion
about group membership based on information given and not using information about the prior
probability of group membership
verified answers
entity relationship diagram - correct answer ✔✔shows the relationships between the tables in a
database
primary key - correct answer ✔✔a unique identifier of every row or record in the table
record primary key - correct answer ✔✔normally assigned sequentially by the database as a
new record is input into the table
relational database can have - correct answer ✔✔one to one relationship or a one to many
metadata - correct answer ✔✔defines what can go into a particular field and how it has to be
formatted
database management system (DBMS) - correct answer ✔✔a software that is used to create a
database, define fields formatting, define database business rules, and modify the database
structure
enterprise system - correct answer ✔✔have a single database and each application accesses the
same database
Enterprise Resource Planning (ERP) system - correct answer ✔✔often used by businesses that
manufacture products
, customer relationship management (CRM) - correct answer ✔✔Service companies and sales
companies often use CRM systems
supply chain management (SCM) - correct answer ✔✔Companies that are involved in logistics
and distribution would often use an SCM
distributed file system (DFS) or NoSQL database - correct answer ✔✔server-based system that
allows for massive amounts of data
A relational database cannot have a many to many relationship between entities. - correct
answer ✔✔False
Because a properly designed relational database only has single data entry, variables that can be
calculated are not in the database. - correct answer ✔✔False
The DBMS is used to create database business rules - correct answer ✔✔True
A manufacturing company that uses an enterprise information system will likely use - correct
answer ✔✔ERP
Heuristics are - correct answer ✔✔qualitative methods that are experience based
insensitive to prior outcomes - correct answer ✔✔Your resume showed that you had been a top
performer in your current job for several years and the interviewer formed an opinion based on
whom you reminded him of
insensitivity to prior probabilities - correct answer ✔✔This bias comes from forming an opinion
about group membership based on information given and not using information about the prior
probability of group membership
