Databases -MIS adaptive reading
Which of the following sets of characteristics specifically apply to relational databases? More than one answer may be correct.
- A relational database organizes data in tables composed of records or objects (the rows), and fields (the columns). - Data tables in a relational database are linked by the fields they have in common.
Which of the following statements describe the capabilities of relational database management system (RDBMS)? More than one answer may be correct.
- RDBMS allow users to view, add, revise, and remove data. - RDBMS have features that support the quality and security of 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
Which statement explains the difference between a database and a database management system (DBMS)?
A DBMS is a software program designed to organize and administer 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
In the ClassList table, the primary key is probably the __ field.
Classnumber
What element of a database field specifies the data in a field such as text, numeric, or date/time?
Data Type
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.
In the relationship shown in the image, the Owners table is linked to the Pets table by a one-to-many relationship. This means that each entry in the OwnerID field can be linked to many ___.
Pets
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 contrast to computerized systems, traditional file management systems can create issues with ______.
organization, repetition, and lack of consistency
In a relational database, an important field that contains a unique value that identifies each record as individual is the____ key
primary
To search a database for information, create a ___. Multiple choice question. field
query
Analytic platforms are designed to ______.
quickly gather and analyze specific organizational data to provide information that guides decision making
Forms structure data input to help ensure data_____ , meaning the information entered is accurate, timely, and useful.
record
Select all that apply 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.
- Action queries - SQL specific queries - Crosstab queries
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.
- Addresses of the company's wholesalers and the number of items in a company's inventory - Names of customers and records of when merchandise was returned
Which statement best summarizes the primary advantages of performing a data quality audit?
The audit recommends ways the organization can improve its data quality and reduce costs through increasing data consistency.
Which statement best explains why traditional file systems have certain issues?
Which statement best explains why traditional file systems have certain issues?
Forms structure data_____ input to help ensure data , meaning the information entered is accurate, timely, and useful.
accuracy
Database management system (DBMS) make it easier to secure data and information because they ______.
allow for the creation of access constraints
The four steps in a data quality audit are ______.
assessment, design, transformation, and monitoring
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 a relational database, such as Microsoft Access, a collection of related fields in a data file is called a
record
In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a ______
record
A link between tables in a relational database that defines how the data are related is called a _____.
relationship
Forms allow data to go into a database, ___ displays information coming out of a database.
reports
To display or distribute information from a database, programmers or database administrators create ___.
reports
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
