MIS ch.4 quiz

Lists that involve data with multiple themes​ (i.e., students and​ advisors) require​ a(n)

Database

The​ __________ data model is excellent for modeling​ entities, attributes, and relationships.

E-R

​Microsoft's SQL Server is an example of​ a(n) ____________ DBMS.

Enterprise

StudentID is an example of​ a(n) __________, whose value is associated with only one entity instance.

Identifier

When creating a​ database, information that helps create the tables​ (i.e., data​ types) is called​ __________.

Metadata

Most​ commonly, NoSQL stands for​ __________.

Not only SQL

MySQL is a popular​ __________ database management system.

Open source

SELECT​ * FROM STUDENT WHERE LastName equals= ​'McKinney' is an example of​ ________

SQL

A group of similar rows​ (i.e., student​ information) is called a​ __________.

Table

A database application includes​ __________.

a collection of​ forms, reports,​ queries, and application programs that use the DBMS to process a database

Having both the accounting and MIS department listed as Department 101 is an example of​ a(n) __________ problem.

data integrity

In simple​ terms, the purpose of a database is to​ __________.

keep track of things

As of​ 2018, __________ databases are considered an emerging market.

noSQL

Poorly designed databases can be improved through a process of​ __________.

normalization