Setting up business rules in database layer
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
The solution provides a detailed description of setting up the business rules in database layer using DDL.
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, ...
Purchase this Solution
Free BrainMass Quizzes
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Javscript Basics
Quiz on basics of javascript programming language.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.