4.   List the major components of a schema and explain what each means.

 

Tables

How the data is physically stored

Views

·   A subset of rows and columns

 

·   Not a physical entity (as are tables)

 

 

·   Can be treated as tables

 

·   C

reated by the DBMS each time they are  referenced by the user as a query

 

 

 

Authorization

Usernames allowed (and how allowed) to access the tables