@createTable;

CREATE VIEW MyStudent (num, name)
AS SELECT sNumber, sName FROM Student;

-- It is not possible to insert into view MyStudent1. INSERT into the view
-- will be translated into inserting into student with null values for
-- sNumber attribute.

CREATE VIEW MyStudent1(name)
AS SELECT sName FROM Student;
