DBMS Concepts and Business Rule Identification from ER Diagrams

An example of a nonserialized item is:

A. computer

B. paper

C. laser printer

D. copier

Please explain.

The database is based on the ______ that are derived from the database
initial study.

A. mission statement

B. tables

C. systems procedures

D. business rules.

I believe this one to be business rules but I am not totally sure.

What is the business rule that the E-R model segment in the below figure
is illustrating?

----------------- -----------------

ORDER INV_TYPE

__________ ___________

ORD_ID TY_GROUP



---------------- ----------------

I I

T T

I I

I
I

I references

I I

I O

I ^

I -----------------------------I

Contains / ORDER_ITEM \

I_________________ -----------------------

<- OI_LINE

ORD_ID(FK)

TY_GROUP (FK)(IE)

\ /

------------------------------

Items above are in a box; all have an underscore except the ORDER.

a. Each inventory item corresponds to one inventory type, and

each inventory type can be referenced by one or many order

item lines.

b. Each inventory item corresponds to several inventory types,

and each inventory type can be referenced by only one item

line.

c. Each inventory type corresponds to one inventory item, and

each inventory item can be referenced by one or many order

inventory lines.

d. Each inventory item corresponds to several inventory types,

and each inventory type can be referenced by several order

inventory lines.

What is the business rule that the E-R model segment in the below figure
is illustrating?



----------------------

VENDOR

---------------------

VEND_ID

______________

---------------------

I

T

I I I receives I
O ^ -------------------- ORDER

--------------------

ORD_ID

_____________

VEND_ID (FK)(IE)

--------------------

a. An order references only one vendor, and each vendor can

have zero, one, or many orders.

b. An order references many vendors, and each vendor can have

only one order.

c. A vendor references only one order, and each order can have

zero, one, or many vendors.

d. An order references many vendors, and each vendor can have

only one order.

What is the business rule that the E-R model segment in the below figure
illustrating?

---------------------

ITEM

______________

ITEM_ID

______________

---------------------

I

I

Is located in

I O ^

---------------------- /STORAGE \

________________

ITEM_ID(FK)

LOC_ID(FK)

________________

\------------------------ /

V

O

Is found in

I

I

T

-------------------------

LOCATION

________________

LOC_ID ________________
------------------------

a. Items will not be stored in the locations.

b. Items will be stored in one location. Each storage location

will store only one item.

c. Some items may be stored in zero, one, or more locations.

Each storage location may store zero, one, or many items.

d. None of the above

What is the business rule that is being illustrated in the E-R model
segment in the below figure?

-----------------------

INV_TYPE

_______________

TY_Group

_______________

-----------------------

I

T

I

I

Includes

I

I

O

^

-------------------------

ITEM

________________

ITEM_ID

________________

TY_GROUP (FK)(IE)

-------------------------

a. Each item belongs to one or more inventory type.

b. Each inventory type belongs to one or more item.

c. Each item belongs to only one inventory type.

d. Each inventory type belongs to only one item.

Problems are solved within two sets of constraints: operation
constraints and ___________ constraints.

Economic

System

Security

access