建立“数学系”学生的视图,要求在进行修改、插入时保证该视图中只有数学系的学生。

Question

建立“数学系”学生的视图，要求在进行修改、插入时保证该视图中只有数学系的学生。

Answer 1

正确答案：CREATE VIEW MathStudent AS SELECT Sno Sname Sdept Sage Sex FROM Studem WHERE Sdept = Math' WITH CHECK OPTION;
CREATE VIEW MathStudent AS SELECT Sno, Sname, Sdept, Sage, Sex FROM Studem WHERE Sdept = Math' WITH CHECK OPTION;