2a. Create a view "View_Dept6090" which will display columns EmpNo, EName and Salary, by selecting the employee_id, First_Name and salary from Employees table, whose department_id is either 60 or 90 or the First_name contains letter 'a'. Assign or set a constraint to control the access of data, by ensuring that modifications (DMLoperations) are not allowed. 2b. Explain the purpose of creating views in your own words.

2a. Create a view "View_Dept6090" which will display columns EmpNo, EName and Salary, by selecting the employee_id, First_Name and salary from Employees table, whose department_id is either 60 or 90 or the First_name contains letter 'a'. Assign or set a constraint to control the access of data, by ensuring that modifications (DMLoperations) are not allowed. 2b. Explain the purpose of creating views in your own words.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Example of DBMS written in Utility Services
Why would you want to utilize a SQL database?
Data storage and retrieval can be performed using SQL alone or embedding SQL in a general-purpose programming language. Describe the circumstances in which you would choose to use i) embedded SQL ii) SQL alone
1- List the naming conventions in PL/SQL
Explain the significance of indexing in relational databases.
Salesforce Please describe the details when we receive the SOQL 201 Issue in the code. Salesforce Development
Differentiate between embedded sql and dynamic sql. Atleast 5 points.
Salesforce Please describe the details when we receive the SOQL 201 Issue in the code. Salesforce Development
Explain different types of DBMS
Explain Interviews and questionnaires of query techniques.
Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
Show a snippet of PHP code for disconnecting from the database. Explain the meaning of the code