‹header›
‹date/time›
Click to edit Master text styles
Second level
Third level
Fourth level
Fifth level
‹footer›
‹#›
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)
DBDL is one way of visually representing your information.
Another popular method is the use of E-R (Entity-Relationship) diagrams.