- Terminology:
- External Schema =
data format used
by a group of users
- There are multiple
external schemas in
a database
(One external schema for one group of users)
- There are multiple
external schemas in
a database
- Conceptual Schema =
the data format
in which the database files
are stored
- The is only one conceptual schema in one database
- Internal Schema =
the file structures and
indexes used to
store the data in a
database
- The is only one internal schema in one database
- External Schema =
data format used
by a group of users
- Here is my
diagram of
the database system
annotated with the
database terms:
