ITCO333 – Data Modeling and Design
ITCO333 – Data Modeling and Design  Unit 2 Discussion Board 3-5 paraprahs no more then 1 page
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: How could the above business rules be set up in a database and reinforced using DCL?
