Explore BrainMass

Explore BrainMass

    Setting up business rules in database layer

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

    A growing business's owners have identified only 2 perspective end-user roles for this project. Following an interview, you have assembled the following business rules:

    Function Clerk Store Manager
    1. View inventory item master Yes Yes
    2. Add, edit, delete inventory item master No Yes
    3. Add, edit, delete inventory transactions No No

    Discuss how these business rules could be set up in the database layer and reinforced using database control language (DCL).

    Assignment Guidelines:
    ? Analyze the business rules outline in the assignment description above.
    ? Post a new topic to the Discussion Board that contains your answer to the following question:
    o How could the above business rules be set up in a database and reinforced using DCL?
    ? Respond to 2 other students' posts on the Discussion Board.

    © BrainMass Inc. brainmass.com October 10, 2019, 2:56 am ad1c9bdddf

    Solution Preview

    The above business rules can be setup in the database layer using the DDL, DML and DCL commands. The DDL is the data definition language using which one can create the database schema and structures. There are 6 basic functions provided by this data definition language such as create, alter, drop, ...

    Solution Summary

    The solution provides a detailed description of setting up the business rules in database layer using DDL.