An Informative Quiz On Database Management.

1. Definitions

can be either zero or one, depending upon whether the relationship between the two entities is optional or mandatory

can be either one or many, depending upon whether each instance of entity A can be liked to at most one instance or potentially many instances or entity B

are those things that have economic value to the organization

are the various business activities about which management wants to collect information for planning or control purposes

are the peopl and organizations that participate in events

is the process of defining a database so that is faithfully represents all aspects of the organization, including its interactions with the external environment

is anything about which the organization wants to collect and store information

is a graphical technique for portraying a database schema

Submit

4. One of the basic type of Entities that have economic value to the organization is called a ?

Agents

Event

Resource

Diagram Variation

5. One of the basic types of Entities represent the people and organiations that participate in events and about whom information is desired for planning, control, and evaluation purposes.

Events

Resources

Agents

Attribute

6. Which of the following statements about the REA data model is true

Every event must be linked to at least 2 agents

Every resource must be linked to at least two agents

Every agent must be linked to at least two events

7. Every event entity must be linked to at least

One resource entity, one other event entity , and at least two participating agents

One event entity and at least two participating agents

Two event entities and at least one participating agent

8. What is known as a graphical technique for portraying a data base schema?

Data modeling

System Analysis

Entity- relationship diagram

DBMS

9. Accounts receivable would appear in an REA diagram as a example of which kind of entity?

Resource

Event

Agent

None

accounts receivable would not appear as an entity in an rea diagram because it represents the difference between two events

Explanation

accounts receivable would not appear as an entity in an rea diagram because it represents the difference between two events

10. In most cases, the relationship between agent entities and event entities is

1:1

1:N

M:N

0:N

Each sales transaction is linked to only one payment (no installments) and each payment is linked to only one sales transaction( separate checks)

Explanation

Each sales transaction is linked to only one payment (no installments) and each payment is linked to only one sales transaction( separate checks)

11. Data modeling occurs during which stages of database design?

System analysis and physical design

System analysis and conceptual design

Conceptual design and implementation and conversion

Phsical design and implementation and conversion

12. Which of the following is not likely to be depicted as an entity in the REA data model?

Customers

Invoices

Sales

Delivery trucks

Invoices- Invoices are paper outputs of a database they do not meet the definition of being either a resource, an event, or an agent, and therefore, are not modeled as an entity in a REA diagram

Explanation

Invoices- Invoices are paper outputs of a database they do not meet the definition of being either a resource, an event, or an agent, and therefore, are not modeled as an entity in a REA diagram

13. Which of the following most accurately models the sales of low cost, mass produced items by a retail store.

Sales = 0 to many inventory and inventory equals one to many sales

Sale= 0 to many inventory and inventory equals 0 to many sales

Sale= 1 to many inventory and inventory equals 0 to many sales

Sale = o to many inventory and inventory equals 1 to many sales