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