Question: Consider a database for a business organisation that stores the data in five tables named Product, Order, OrderItem, Inventory and Supplier. Prepare a security model

Consider a database for a business organisation that stores the data in five tables named Product, Order, OrderItem, Inventory and Supplier. Prepare a security model for this database by filling the given table. You can include database operations such as Insert, Update, Delete, Query, Modify structure, Grant and Revoke etc to complete this table. One cell is filled for an idea: (6 marks)

	Product	Order	OrderItem	Inventory	Supplier
Marketing Staff
Management
Administration Staff	Insert, Update, Delete, Query
System Administrator

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Modify and test an HTML document from Exercise 2.9 that adds a secondlevel column label, Tree, and a second-level row label, Characteristics. Data from exercises 2.9 Create and test an HTML document...

Consider a database for a business organisation that stores the data in five tables named Product, Order, Orderltem, Inventory and Supplier. Prepare a security model for this database by filling the...

Consider a database for an academic institute that stores the data in five tables named Student, Staff, Course, Enrolment and Department. Prepare a security model for this database by filling the...

The Telecoms supply chain This article illustrates how a more dynamic supply chain can place pressures on business within the supply chain. Ever shorter product cycles and intense competition in the...

Buff Tech, Inc. sells computer components and plans to borrow some money to expand. The company has a 12/31 year-end. After reading about earnings management (refer back to Chapter 4), Bucky, the...

Paragraph Styles Cheddy Project Description and Requirements Zchedar Cheddr Background Mr. Z (real name Josh Zubkoff) runs a successful chain of cheese and wine shops in Oregon that specialize in...

CASE STUDY HOME DEPOT CASE This case has been produced for assessment purposes only. It has been sourced directly from the articles indicated within the bibliography, which are available in the...

Paragraph Styles Z CHEDOR Project Fall 2019 Also, prepare a corresponding data listing' for the prototype database. Identify where different fields/attribute names provide the same information and...

The specific heat of the metal was determined following Part A of the Experimental Procedure in this experiment. Complete the following table for Trial 1 (See Report Sheet.) for determining the...

Displacement fluid is given by (x+x+2)i See whether the strain field is possible. the strain component at point (1,2,3) A determine the co-ordinate ts

How much would you be willing to pay for preferred share that pace dollar 9 . 5 0 each year in a dividend assuming forever with no growth in the dividend and required rate of return of 7 . 6 9...

Complete Programming Exercise 7 at the end of Chapter 8 as elaborated on below in python. You'll submit a single .py file for this one exercise. Problem 7. Character Analysis If you have downloaded...