Complete the below:
1. An example of a nonserialized item is:
A. computer
B. paper
C. laser printer
D. copier
Please explain.
2. 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.
3. 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)
\ /
------------------------------
4. 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.
5. 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.
6. 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
7. 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.
8. Problems are solved within two sets of constraints: operation constraints and ___________ constraints.
A. Economic
B. System
C. Security
D. access