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

  Create program that uses functions and reference parameters

Create program that uses functions and reference parameters, and asks user for the outside temperature.

  Write a program using vectors and iterators

Write a program using vectors and iterators that allows a user to maintain a personal list of DVD titles

  Write the code required to analyse and display the data

Calculate and store the average for each row and column. Determine and store the values for the Average Map.

  Write a webservices application

Write a webservices application that does a simple four function calculator

  Iimplement a client-server of the game

Iimplement a client-server version of the rock-paper-scissors-lizard-Spock game.

  Model-view-controller

Explain Model-View-Controller paradigm

  Design a nested program

How many levels of nesting are there in this design?

  Convert celsius temperatures to fahrenheit temperatures

Write a C++ program that converts Celsius Temperatures to Fahrenheit Temperatures.

  Evaluate and output the value in the given base

Write C program that will input two values from the user that are a Value and a Base with which you will evaluate and output the Value in the given Base.

  Design a base class shape with virtual functions

Design a base class shape with virtual functions

  Implementation of classes

Implementation of classes Chart and BarChart. Class barChart chould display a simple textual representation of the data

  Technical paper: memory management

Technical Paper: Memory Management, The intent of this paper is to provide you with an in depth knowledge of how memory is used in executing, your programs and its critical support for applications.

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