Explore BrainMass
Share

Explore BrainMass

    Business Rule Identification from ER Diagrams

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

    © BrainMass Inc. brainmass.com October 9, 2019, 7:24 pm ad1c9bdddf
    https://brainmass.com/computer-science/c/business-rule-identification-er-diagrams-117005

    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