Question: QUESTION 3 You have successfully implemented the database in your company. The management requested you to implement views and categorize your users so that the

QUESTION 3 You have successfully implemented the

QUESTION 3 You have successfully implemented the database in your company. The management requested you to implement views and categorize your users so that the users will not be able to access data that they are not supposed to. a) Based on your company's request, suggest FIVE (5) benefits from implementing views in the database. Give examples to support your suggestions. (15 marks) b) Explain with examples FIVE (5) consequences that might happen from improper implementation of views for your users when they access the database. (10 marks)

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 General Management Questions!

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Sanac Inc.: From ABC to Time-Driven ABC 1.1 Introduction We are competing in an environment with a wide variety of customers, many different products and complex services provided to the customers....

strategic approach to Sourcing in supply chain management Hennes \& Mauritz (H\&M): High Cost of Fast Fashion Sweden-based Hennes and Mauritz (H\&M), one of the leading fast fashion retailers in the...

Delow and answer the questions that follow. Hennes \& Mauritz (H\&M): High Cost of Fast Fashion Sweden-based Hennes and Mauritz (H\&M), one of the leading fast fashion retailers in the world, was...

Sweden-based Hennes and Mauritz (H\&M), one of the leading fast fashion retailers in the world, was staring at an uncertain future in 2018. As of November 2017, the company had unsold stock worth US...

Please read the case in the file BCPC_CASE.pdf and answer each question using maximum 1 page per question. Question 1) Put yourself in the shoes of the VP of Finance, Morgan Jones. Part A) Identify...

PRM301 Introduction to Project Management SLP Module 1: Project Selection and Initiation George F. Rosa The younger generation of the company's leadership wanted to see Woody's enlarged so it could...

Question 2 (30 Marks) "Project leaders across automotive giant Scania's European businesses have been empowered with a special new Project and Portfolio Management solution since moving to Microsoft...

I am working on a very specific case study regarding Celcon Axiat Berhad. A question on tthe grading rubric says "summarize the organizational, management and technology components that added to the...

Is it possible for the de Broglie wavelength of a particle to be greater than the dimensions of the particle? To be smaller is there any direct connection?

The risk-free rate is 2.99% and the expected return on the market portfolio is 7.5%. You have decided to invest in a portfolio of Apple, General Dynamics, Walmart, and Freeport-McMoran. The beta of...

Usten Lease A does not contain a bargain purchase option, but the lease term is equal to 9 0 . 0 percent of the estimated economic life of the leased property. Lease B does not transfer ownership of...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...