FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Database Processing

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 61

True/False

Review LaterAdd Note

Review Later

Minimum cardinalities represent the lower limit on the number of entities required in a relationship.

Correct Answer

verified

Show Answer

Question 62

True/False

Review LaterAdd Note

Review Later

NoSQL means nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud.

Correct Answer

verified

Show Answer

Question 63

True/False

Review LaterAdd Note

Browser-based applications are more dynamic and better suited to today's world than older database applications.

Users are the final judges as to what data the database should contain and how the records in that database should be related to one another.

What are the steps involved in transforming a data model into a relational database design?

A user does not need user account credentials to access and process a database.

Managing the impact of database structure changes on applications and users is an operational task for a database administrator.

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

The small oval on a line in an E-R diagram means that the relationship must have an entity of that type.

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

Explain the role of users in the database development process.

Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

When using the relational model to represent two tables, one must ________.

A data model describes data and relationships that will be stored in the database.

Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

Browser applications are thin-client applications that need to be pre-installed on the users' computers.

A group of similar rows or records in a table is called a field.

Columns that are keys to different tables than the ones in which they reside are called ________.

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

Identify the open source DBMS product among the following.