S(S#, SNAME, STATUS, CITY) PRIMARY KEY (S#)

P(P#, PNAME, COLOR, WEIGHT, CITY)PRIMARY KEY (P#)

J( J#, JNAME) PRIMARY KEY (J#)

SPJ( S#, P#, J#, QTY) PRIMARY KEY (S#,P#,J#)

question. create a view consisting of supplier tuples for supliers that are located in London

Ans
create view vw_london

as
select * from s where city = 'london'

Is this right

Test it and find out.