Question
The goal of this assignment is to continue with SQL and acquire hands-on experience on a live DBMS environment. DBMS Environment: Use your Oracle DBMS
The goal of this assignment is to continue with SQL and acquire hands-on experience on a live DBMS environment. DBMS Environment: Use your Oracle DBMS environment from HW #4 Submit your answers for the following questions from our course textbook by Elmasri. Ch 5: 5.1 5.9 (10 points) Ch 6: 6.4, 6.10, & 6.13 (10 points each) 30 points. Pertaining to Figure 5.6 (page 162 from out class textbook and also shown below), start by creating and populating the EMPLOYEE table. Then, implement the SQL queries that produce answers to the following: a. Retrieve and display only the Ssn values of the male employees whose last name begins with the letter J. b. Retrieve and display only the employees first name only if he/she is a supervisor. c. Retrieve and display only the employees last name if he/she is older than 50 years. Do not hardcode the date value (hint: use Oracles sysdate global variable). Make sure to include ACTUAL screen shots of your DDL code and all your SQL and complete output. Make sure to define attribute Bdate as type Date. S
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started