MGMT 2303: Week 10 Databases

Which of the following sets of characteristics specifically apply to relational databases? More than one answer may be correct.

-Data tables in a relational database are linked by the fields they have in common. -A relational database organizes data in tables composed of records or objects (the rows), and fields (the columns).

Which of the following statements correctly describes referential integrity? More than one answer may be correct.

-For referential integrity to exist, data on both sides of the table relationship must be present. -Referential integrity applies to data quality within the structure of a relational database.

What is the purpose of an SQL statement?

Answer questions about the database

In analyzing transactions, Walmart discovered that many people who buy Children's Tylenol in their stores also buy orange juice in the same transaction. They used this information to discount Children's Tylenol but raise the price of orange juice during flu season. What is the name of the approach Walmart used to discover this information? Multiple choice question.

Big data

Which of the following are advantages of cloud databases over a traditional database? More than one answer may be correct.

Can support both SQL and NoSQL databases Can be accessed through an application programming interface (API) Are maintained by an external provider, such as Amazon or Oracle

Which type of database maintains the hardware and operating system offsite and is accessed via Internet-based applications?

Cloud database

Which of the following tasks are NoSQL databases designed to do? More than one answer may be correct.

Create queries from the data created from web apps Analyze nonstructured data Manage large datasets across different platforms

Which statement most accurately describes the value of data integrity to an organization?

Databases and database management system (DBMS) with a high level of data integrity enable more efficient data maintenance in support of organizational goals.

For which of the following tasks would it be more appropriate to use a NoSQL database than a SQL database?

Organizing user-generated comments from your company's Twitter, Facebook, and Instagram pages Analyzing large volumes of data that are stored in the cloud

A query is a request for information stored in a database. One of the benefits of using a database to store information is the ability to run a query. In relational database management systems (RDBMS), there are a variety of query tools that are used to execute and run queries. Which of the following are tools used to run queries in an RDBMS? More than one answer may be correct.

SQL specific queries Crosstab queries Action queries

From the following list, select all of the examples of a relationship that an entity-relationship diagram (ERD) could be used to describe.

The courses a student is taking Products a customer has ordered The employees who report to a specific manager in an organizational chart

Which of the following statements correctly describes a defining characteristic of Big Data?

The data are from structured and unstructured sources and exist in multiple forms. -The data are measured in terabytes (trillions of bytes) or even larger units.

A mid-sized independent hardware store has recently merged with a large national chain. The local owners have long used a reliable database to manage inventory. Their database has been essential in balancing orders for seasonal merchandise with the problem of limited shelf space. The merger will soon entail managing many more types of data, as the national chain has approved lists of suppliers, precise requirements for recording transactions, specific human resources procedures, and more. Which statement best summarizes what the local managers will be able to do for the first time when they start using the parent company's database management system (DBMS)?

The managers will be able to create, edit, and store data in a secure manner across all data types required by the parent company.

Referential integrity states that structural relationships in relational databases must ______.

be consistent: a foreign key field that references a primary key field must agree with that primary key

Data integrity is increased when ______

data are centralized

Organizing data so that data are in simple tables without any redundancies is known as __________.

data normalization

So that users can find specific information quickly by using filters based on specific criteria, databases allow the creation of ___.

queries

To search a database for information, create a ___.

query

Which of the following is a task that an SQL statement would be expected to perform?

retrieve data

The primary characteristic of a relational database is that it ______.

stores and allows access to data objects that are related to one another

Relational database management systems (RDBMS) have a variety of tools that can be used to execute/run queries. One of these query tools is the ability to execute/run action queries. Which of the following are common types of action queries?

Append query Update query Delete query