DROP VIEW StudentProf;

@createTable;

ALTER TABLE Professor DROP CONSTRAINT profPK;

-- ALTER TABLE Student DROP CONSTRAINT studentPK;

CREATE VIEW studentProf(student, professor) AS
SELECT sName, pName
FROM Student, Professor
WHERE professor=pNumber;
