MSIS 2103 Exam 2 COMPREHENSIVE questions
answered, 2025 verified graded A+ already passed!
entity relationship diagram - (ANSWER)shows the relationships between the
tables in a database
primary key - (ANSWER)a unique identifier of every row or record in the table
record primary key - (ANSWER)normally assigned sequentially by the database as
a new record is input into the table
relational database can have - (ANSWER)one to one relationship or a one to
many
metadata - (ANSWER)defines what can go into a particular field and how it has to
be formatted
database management system (DBMS) - (ANSWER)a software that is used to
create a database, define fields formatting, define database business rules, and
modify the database structure
enterprise system - (ANSWER)have a single database and each application
accesses the same database
Enterprise Resource Planning (ERP) system - (ANSWER)often used by businesses
that manufacture products
, customer relationship management (CRM) - (ANSWER)Service companies and
sales companies often use CRM systems
supply chain management (SCM) - (ANSWER)Companies that are involved in
logistics and distribution would often use an SCM
distributed file system (DFS) or NoSQL database - (ANSWER)server-based system
that allows for massive amounts of data
A relational database cannot have a many to many relationship between entities.
- (ANSWER)False
Because a properly designed relational database only has single data entry,
variables that can be calculated are not in the database. - (ANSWER)False
The DBMS is used to create database business rules - (ANSWER)True
A manufacturing company that uses an enterprise information system will likely
use - (ANSWER)ERP
Heuristics are - (ANSWER)qualitative methods that are experience based
answered, 2025 verified graded A+ already passed!
entity relationship diagram - (ANSWER)shows the relationships between the
tables in a database
primary key - (ANSWER)a unique identifier of every row or record in the table
record primary key - (ANSWER)normally assigned sequentially by the database as
a new record is input into the table
relational database can have - (ANSWER)one to one relationship or a one to
many
metadata - (ANSWER)defines what can go into a particular field and how it has to
be formatted
database management system (DBMS) - (ANSWER)a software that is used to
create a database, define fields formatting, define database business rules, and
modify the database structure
enterprise system - (ANSWER)have a single database and each application
accesses the same database
Enterprise Resource Planning (ERP) system - (ANSWER)often used by businesses
that manufacture products
, customer relationship management (CRM) - (ANSWER)Service companies and
sales companies often use CRM systems
supply chain management (SCM) - (ANSWER)Companies that are involved in
logistics and distribution would often use an SCM
distributed file system (DFS) or NoSQL database - (ANSWER)server-based system
that allows for massive amounts of data
A relational database cannot have a many to many relationship between entities.
- (ANSWER)False
Because a properly designed relational database only has single data entry,
variables that can be calculated are not in the database. - (ANSWER)False
The DBMS is used to create database business rules - (ANSWER)True
A manufacturing company that uses an enterprise information system will likely
use - (ANSWER)ERP
Heuristics are - (ANSWER)qualitative methods that are experience based
