What is the business rule in the e-r model segment

Assignment Help C/C++ Programming
Reference no: EM13939543

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.

A. Economic

B. System

C. Security

D. access

Reference no: EM13939543

Questions Cloud

Benefits of expanding sentencing options : Benefits of expanding sentencing options, such as intermediate sanctions, include all of the following EXCEPT
What is the book value of the equipment : A company has just completed the third year of a five-year MACRS recovery period for a piece of equipment it originally purchased for $303,000. What is the book value of the equipment?
Linguistic genius of babies : Watch the talk by Patricia Kuhl, entitled The Linguistic Genius of Babies. How do her findings support language acquisition in regard to phonology as it is described in Chapter Six of your text?
Capital expenses debt and debt principal payments : A company has EAT, depreciation expense, capital expenses, debt and debt principal payments of $9m, $2.8m, $1.3m, $40m and $1.5m respectively. Between the first and the second years, it has current assets of $11m and $13.4m and current debts of $5m a..
What is the business rule in the e-r model segment : What is the business rule that is being illustrated in the E-R model segment in the below figure?
Illustrates the relationship between bens total costs : Prepare a graph that illustrates the relationship between Ben's total costs (the sum of the costs of giving opening shows and running the gallery) and the number of opening shows given
Problem regarding the effective property tax rate : The most important parts is the effective property tax rate in district A and the following question. Consider the following scenarios for the fictional state of Inequity which consists of five local districts. Assume that Inequity has a gaurantee..
Using arithmetic and geometric growth rates : Suppose Powers Ltd. just issued a dividend of $2.62 per share on its common stock. The company paid dividends of $2.12, $2.19, $2.36, and $2.46 per share in the last four years. If the stock currently sells for $81, what is your best estimate of the ..
Introduction of the country and company : To write about a company and country with introduction of the country and company, with pestle, porters five force , strategic 4 strategic recommendations and conclusion with references list.

Reviews

Write a Review

C/C++ Programming Questions & Answers

  Why is exception handling important to software development

Please respond to all of the following prompts: Why is exception handling important to software development? Can there be such a thing as too much exception handling? How does exception handling affect performance of code execution?

  How many times will the inner loops s be executed

How many times will the inner loop's S be executed? Show HOW you got that answer.

  A minivan has two sliding doors

A minivan has two sliding doors.  Each door can be opened by either a dashboard switch, its inside handle, or its outside handle. However, the inside handles do not work if a child lock switch is activated.  In order for the sliding doors to open, th..

  Use example of polymorphically processing employee objects

Modify your Account superclass so that it is abstract and contains the abstract method, computeSales(). If you added default behavior in the earlier task for computeSales(), remove this default behavior.

  The multi-purpose sorting program that function pointers

3.  Take the multi-purpose sorting program that uses function pointers. Create a new auxiliary function such that the routine will sort numbers in ascending order, but all zeros will be placed at the end of the list. For example, an array with 3, 0, ..

  Develop a simple poker game

Develop a simple poker game

  Write an ascending function to test

Write an ascending function to test whether a list of integers is in strict ascending order.

  Only letters are affected

You are to write a ROT13 (for "rotate 13") decoder to translate a secret message from its encoded state to something readable. In a ROT13 code, 'a' is shifted 13 letters to 'n', 'B' to 'O', 'c' to 'p', 'D' to 'Q', ..., 'N' to 'A', 'o' to 'b', 'P' ..

  Suitable examples using the basic operations

Briefly review Regular Expressions - the notation and the languages they represent with suitable examples using the basic operations - namely, concatenation, union , Kleene Closure.

  Hierarchical control using player/stage simulator

In the Nested Hierarchical Controller, the PLAN module consists of a Mission Planner, a Navigator, and a Pilot. The Pilot connects with the ACT module to execute the drive and steering commands that cause the robot to move along a path segment.

  Generate a random number and guess what the number is

Prepare a program in c++ that generates a random number and asks the user to guess what the number is. If the user's guess is higher than the random number, the program should display "Too high, try again."

  Develop a basic temperature class

You have to develop a basic temperature class

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd