Question: CREATE TABLE Employee ssn CHAR (10) NOT NULL, first_name VARCHAR2 (20), last_name VARCHAR2 (20), birth_date DATE, salaried CHAR (5) gender CHAR(1), phone CHAR (12), PRIMARY


CREATE TABLE Employee ssn CHAR (10) NOT NULL, first_name VARCHAR2 (20), last_name VARCHAR2 (20), birth_date DATE, salaried CHAR (5) gender CHAR(1), phone CHAR (12), PRIMARY KEY (ssn)); CREATE TABLE Department ( dept_no NUMBER NOT NULL, dept_name VARCHAR(220), budget NUMBER, PRIMARY KEY (dept_no)); CREATE TABLE Works In ssn CHAR (10) NOT NULL, dept_no NUMBER NOT NULL, PRIMARY KEY (ssn, dept_no), FOREIGN KEY (ssn) REFERENCES Employee (ssn), FOREIGN KEY (dept_no) REFERENCES Department (dept_no)); CREATE TABLE Manager ( ssn CHAR (10) NOT NULL, dept_no NUMBER NOT NULL, PRIMARY KEY (ssn, dept_no), FOREIGN KEY (ssn) REFERENCES Employee (ssn), FOREIGN KEY (dept_no) REFERENCES Department (dpet_no)); 1- EXPLAIN IN CLEAR ENGLISH WHAT QUESTION THIS ASKS (NOT WHAT ANSWER IT PRODUCES). SELECT first name, last_name, birth date FROM Employee as e WHERE e.birth_date= (SELECT MAX(m.birth date) FROM Employee as mi
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
