-- create a table
CREATE TABLE branches (
  Bcode INTEGER PRIMARY KEY,
  Bname varchar (40) NOT NULL,

);

create table  (Sname varchar(20), Sids int , Slocation varchar(50), primary key (Sids,Slocation));

insert INTO branches values(100, 'JHB')
insert INTO branches values(101, 'CPT')
insert INTO branches values(102, 'DBN')
insert INTO branches values(103, 'BLM')