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

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

Correct Answer

verified

Show Answer

Question 62

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 63

Multiple Choice

Review LaterAdd Note

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

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

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

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

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.

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

Explain the role of users in the database development process.

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

Identify the open source DBMS product among the following.

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?

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.

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

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

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

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

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