The secret to
successful database design is to very carefully consider the requirements and specifications before doing anything
else.
Imagine if you have happily designed a whole
system and then discovered you have left out some
important function that is required by the
client.
Just adding the function may not be easy
since we are dealing with related data and
tables.
A single change may reverberate throughout
the entire system and be costly, time consuming and
frustrating to fix.
User Views
= person or group of users that will use the system
= a particular report the system must be able to
produce
=a type of transaction the system must be able to carry out
(not necessarily money transaction, just an
interaction between user and database)