Answer to Question #91928 in Databases | SQL | Oracle | MS Access for lmm

Question

Create read only: VIEW_EMPS_NO_SAL

show all of the data from employee table, department id, department name from departments table Dont show salary and commission percent employees table.

4. Create a view called: VIEW_COUNTRY_REGION_INFO

Show the country id, country name, and region name that each country belongs to. Be sure to use syntax that will allow you to rerun the code without dropping the view and make the view read only.

Create READ ONLY view: VIEW_EMP_SAL_INFO

Calculate the following: The minimum, average, maximum, and sum of all salaries,a count to show records used. Have calculations grouped by department name. need to join with the departments table Give the read only constraint the name of vw_emp_sal_info_readonly.

Run the command to Query the data dictionary USER_VIEWS, showing only the view name and the text columns. Show me the results from your query.

Answer 1

Dear lmm, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order