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 |
||
2. Add, edit, delete inventory item master |
|||
3. Add, edit, delete inventory transactions |
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?