create database company;

create table employee(
    employee_name varchar(50) not null primary key,
    employee_street varchar(50),
    employee_city varchar(50)
);


create table company(
    company_name varchar(50) not null primary key,
    company_city varchar(50)
);

create table works(
    employee_name varchar(50) not null,
    company_name varchar(50) not null,
    salary int,
    foreign key (employee_name) references employee(employee_name),
    foreign key (company_name) references company(company_name)
);


create table manage(
    employee_name varchar(50) not null,
    manager_name varchar(50) not null,
    foreign key (employee_name) references employee(employee_name)
);


insert into employee values ('Murad Khan', 'Basila', 'Dhaka');
insert into employee values ('Murad Khan Khan', 'Basila', 'Dhaka');
insert into employee values ('Rahim', 'Basila', 'Dhaka');



insert into company values ('Khan', 'Basila');
insert into company values ('Amin', 'Basila');


insert into works values ('Murad', 'Khan', 5000);
insert into works values ('Murad Khan', 'Amin', 5000);

insert into works values ('Murad Khan Khan', 'Khan', 5000);


2)
a.

SELECT employee.employee_name, employee_city, salary
FROM employee
INNER JOIN works on employee.employee_name = works.employee_name
WHERE company_name = 'Prime Bank';



b.

UPDATE employee
SET employee_street = 'Shankar'
WHERE employee_name = 'Rahim';

c.

DELETE FROM works
WHERE salary < 18000;