1. employees table- emp_id is the primary key
2. department table-dept_id is the primary key.
3. Create or replace View emp_dept AS select e.emp_id, e.last_name, d.dept_id
From employees e, department d
4. update emp_dept
set last_name = 'munir'
where emp_id = 11
ORA-01779: cannot modify a column which maps to a non key-preserved table
Can someone pls tell me how i can fix it?