Share
Explore BrainMass

Business Rule Identification from ER Diagrams

DBMS Concepts and Business Rule Identification from ER Diagrams.
See attached file for full problem description.

Attachments

Solution Preview

Please see the attached file.

An example of a nonserialized item is:
A. computer
B. paper
C. laser printer
D. copier

Please explain.

Each ITEM may be a SERIALIZED ITEM, which is an item that is tracked individually (e.g., a computer server) or a NON-SERIALIZED ITEM, which is an item that is maintained as a group (e.g., screws in a bin). Therefore, the quantity on hand is maintained for the SERIALIZED ITEMs, and a serial number is maintained for non-serialized items.

Paper we generally don't refer singly, we refer to set of papers in reams etc..

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 ...

Solution Summary

Solution shows the identification of Business Rules from ER Diagrams.

$2.19