Views are relations, except that they are not physically stored.

For presenting different information to different users

Employee(ssn, name, department, project, salary)

Payroll has access to Employee, others only to Developers

CREATE VIEW  Developers AS

   SELECT name, project

   FROM  Employee

   WHERE department = “Development”