FIT 100
© Copyright University of
Washington 1999-2000
Terminology
vThe structure of a
data base is called a database schema
vThe schema specifies
…
;The list of table
names forming the database
;For each table, the
fields of its records
;For
each field, its attributes or properties, i.e. data type, key or not key,
default value, etc.
vA database as the
word is normally used, i.e. tables with specific contents, is known as a
database instance (of a data base schema)
vThere can be many
instances of a single database schema