Run the preparation statements before you perform the tasks. Some students may see an error message saying the table doesnt exist, ignore it.

Drop table jobs cascade constraints;

Drop table employees cascade constraints;

Drop table accounts cascade constraints;

CREATE TABLE employees

as select * from hr.employees;

CREATE TABLE jobs

as select * from hr.jobs;

CREATE Table accounts (cust_fname varchar(20),

cust_lname varchar(20),

acc_open_date date,

balance number(20,2));

3. Update commission_pct to 0.25 for employees whose job_id starting with AD. (employees table)