FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Database Processing

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

One of the functions of a DBMS is to provide tools to assist in the administration of a database.

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

In an E-R diagram,a(n) ________ on a line means that at least one entity of that type is required.

A) small oval
B) vertical bar
C) arrow
D) triangular block

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

The general goal of normalization is to construct tables such that every table has a single topic or theme.

The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.

Brenda,the sales manager of a firm,wants to generate a particular report containing sales analyses of the second and third quarter of the year.She should use a ________ to obtain the information that she wants from the database.

A data model is a ________.

The format of metadata depends on the software product that is processing the database.

Describe a DBMS and its functions.List some of the popular DBMS products.

Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.

Identify the first step in transforming a data model into a relational database design.

A many-to-many (N:M)relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

The database administrator of an organization constantly manages the processing rights and responsibilities of employees.This is an example of a(n) ________ task.

Which of the following is an international standard language for processing a database?

A DBMS and database mean the same thing and are synonymous terms that can be used interchangeably.

A ________ is a collection of forms,reports,queries,and programs that serves as an intermediary between users and database data.

In a database,when data items disagree with one another,it leads to a(n) ________.

A foreign key is essential in relational databases to represent the relationship between two tables.

Which of the following is true of N:M relationships?

Special data that describes the structure of a database is called metadata.

Explain the role of users in the database development process.