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 1

Multiple Choice

Review LaterAdd Note

Review Later

In a data model, a(n) ________ is something that a user wants to track.

A) record
B) byte
C) entity
D) primary key

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

Charles and Irene are editors at a content development firm. Both of them, unknowingly, are working on the same copy of the annual report. Irene finishes editing the report and saves her copy; Charles saves his report an hour after Irene. Charles's report overwrites Irene's, and her changes are lost. This scenario is an example of the ________.

A) lost-update problem
B) crow's-foot paradigm
C) bullwhip effect
D) update query problem

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

The columns in a database are called ________.

________ is the process of converting a poorly-structured table into two or more well-structured tables.

Each table in a database must have two or more primary keys.

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. The "Employee Number" column is referred to as a ________.

Owen, the database administrator for a shipping company, is responsible for checking the data model, which is to be used in the database management system, for accuracy and completeness. This is an example of Owen's ________ tasks.

Define the symbols and terms used in entity-relationship (E-R)diagrams.

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.

An identifier is an attribute or a group of attributes whose value is associated with one and only one entity instance.

Which of the following is a developmental task of database administration?

Describe entities in the context of data models.

The accuracy of a database design is not dependent on the corresponding data model.

What is a database application?

SQL is an international standard language for processing a database.

Which of the following statements correctly describes the relationship between drones and videos in Falcon Security's database?

________ is the process of converting a data model into tables, relationships, and data constraints.

Each entity in a database has a unique attribute called a(n) ________.

Identify an open source DBMS product.

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