Explore BrainMass

Setting up business rules in database layer

This content was STOLEN 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 17, 2018, 2:53 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.

Similar Posting

Relational Database Limitations

Object-Oriented (OO) development is by far the most popular in the development arena today, however, object-oriented databases are not. Relational databases still rule the roost, however, this causes some headache for OO developers.

A concept that many of the major database vendors have come up with is a hybrid database that integrates the concepts of both OO and Relational databases.

What can you tell me about hybrid databases? What are the positives and negatives? Are they better than using a OO or Relational database specifically? (Research will be necessary and do not rely solely on Wikipedia)

View Full Posting Details