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

In an entity-relationship (E-R) diagram, an entity is represented by a triangle, and the relationships between entities are represented by dotted lines.

A) True
B) False

Correct Answer

verified

Show Answer

Question 62

Multiple Choice

Review LaterAdd Note

Review Later

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

A) representing the entity relationships
B) normalizing the data and files
C) creating foreign keys
D) creating a table for each entity

E) C) and D)
F) None of the above

Correct Answer

verified

Show Answer

Question 63

True/False

Review LaterAdd Note

Database applications must present data to the users in the same format as the database table.

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

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

What is a database application?

Define primary key, foreign key, and metadata.

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

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

Which of the following notations in an E-R diagram means that the entity is optional and a relationship need not have an entity of that type?

A database is a self-describing collection of integrated records.

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

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

Which of the following is a nonrelational data store developed by Google?

________ in an E-R diagram refer to the least number of entities required in a relationship.

Relational databases represent relationships using ________.

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

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 DBMS and database are synonymous terms that can be used interchangeably.

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