3. Design
the records and fields for each table
2. Design
the tables
1. Determine the purpose of the database
4. Determine
the relationships among
the tables
the tables
§Design tables on paper first
§Each table should contain
data about one subject
data about one subject
Database Administration
What are guidelines for
developing a database?
p. 540
Next
§Be sure every record has a unique
primary key
primary key
§Use separate fields for logically
distinct items
distinct items
§Do not create fields for information
that can be derived from entries in
other fields
that can be derived from entries in
other fields
§Allow enough space for each field
§Set default values for frequently
entered data
entered data