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

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

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?