MIS Databases Adaptive Learning Questions

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

Database management systems make it easier to secure data and information because they _________.

Allow for the creation of access constraints

Data integrity is increased when ____________.

Data are centralized

Database Management System (DBMS) is a computer program that is used to _____________.

Help organize the data found in a database

In contrast to computerized systems, traditional file management systems can create issues with _______.

Organization, repetition, and lack of consistency.

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

Record

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

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

Which of the following sets of characteristics specifically apply to relational databases?

• 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 describe the capabilities of relational database management systems (RDBMS)?

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