databases

For the past 10 years, a restaurant has been running a customer loyalty program, rewarding customers with discounts and treats. Records of these rewards have been kept in odd notes and multiple spreadsheets used in different ways by various employees who have come and gone over the years. Because of this, some customers are not getting their rewards, while others are receiving rewards they have not earned. Overall, the restaurant is losing money and business with this program. How can a database management system (DBMS) help with this problem?

A DBMS will help the owners manage the data they already have to run their customer loyalty program more efficiently.

What is the purpose of an SQL statement?

Answer questions about the database

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?

Crosstab queries SQL specific queries Action queries

What element of a database field specifies the data in a field such as text, numeric, or date/time?

Data Type

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 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.

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.

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

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

Which of the following are examples of data objects that a relational database management system (RDBMS) may include? More than one answer may be correct.

Names of customers and records of when merchandise was returned Addresses of the company's wholesalers and the number of items in a company's inventory

Which of the following is an example of an organization analyzing predictive behavior with the goal of creating new offerings? More than one answer may be correct.

Netflix tracks what users who viewed all three seasons of Stranger Things also had in their queues. An in-home healthcare provider tracks the hospital readmission rates of elderly people who live alone after they received care for falling in their homes.

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

Which of the following statements describe the capabilities of relational database management system (RDBMS)? More than one answer may be correct.

RDBMS have features that support the quality and security of data. RDBMS allow users to view, add, revise, and remove data.

Your college has a database with a Students table. Which two of the following could be a primary key in the table?

Student number Social Security Number

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

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

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.

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?

Update query Append query Delete query

Database management system (DBMS) make it easier to secure data and information because they ______.

allow for the creation of access constraints

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

In the ClassList table, the primary key is probably the __ field.

classnumber --This primary key field has a unique entry for each record.--

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

To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity

forms

A database management system (DBMS) is a computer program that is used to ______.

help organize the data found in a database

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a

record

In the datasheet view of a relational database (such as Microsoft Access), a row of information is called a ___ .

record

A link between tables in a relational database that defines how the data are related is called a _____.

relationship

A relational database management system (RDBMS) is a type of DBMS whose primary function is to ______.

show how data are connected through relationships

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

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