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 |