Question: Lab (50 points) Preliminary Login into Linux machine (oraclelinux.eng.fau.edu) Connect to database (e.g., sqlplus username/password) ALTER SESSION SET CURRENT SCHEMAksyang Execute the following

Lab (50 points) Preliminary " Login into Linux machine (oraclelinux.eng.fau.edu) " Connect to database (e.g., sqlplus username/password) ALTER SESSION SET CURRENT SCHEMAksyang Execute the following SQL and identify all required tables SELECT table name from all tables where owner = 'KSYANG -" Change line size: SET LINESIZE 400 - Use Spool command to create log file for the output of SQL (e.g., SPOOL filename and SPOOL OFF) " Consider the following relational schema fhame CHARACTER VARYING name CHARACTER VARYING(S) works_on CHARACTER) bdate DATE atdress CHARACTER VARYINO 50) CHARACTER DATE dept locations salary NUMERIC pname CHARACTER VARYIN05) areta nd ae DATE plecation CHARACTER VARYINO(S) Write SQL statements for the following queries 1) (10 points) Retrieve essns of employees who worked more than 45 hours on projects 2) (10 points) Retrieve fnames of employees who have no working experience 3) (10 points) Retrieve fnames of employees who have the highest salary 4) (10 points) Retrieve the minimum, maximum and average salaries of employees whose department is 'Research' 5) (10 points) Retrieve fnames of employees who have more than two dependents
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
