What I Really Want Is...
What I Really Want Is...
you need by using our
checklist to creating a
comprehensive database
system specification
Start at the very beginning
Work out the process you are
trying to automate with the
database, DO NOT DO ANY
PROGRAMMING UNTIL
YOU CAN SEE WHAT IS
NEEDED!
List the process on paper one
function at a time, in order, e.g.
1. Customer details come in
via application form,
2. The fields on application
form are: xxxxx
3. Therefore all the fields from
the form are to be added to
the database.
Attention to detail
You do not need to know how
to programme in order to
specify a database, but you do
need to be able to put into
words the details you would
like to get out of the database,
such as:
Labels: list sizes and shapes
Letters: standard and freeform
Reports: various types, with
all their field names, sort order,
search criteria, how often you
need the data, etc.
Searches: which types? Do
you need the searches printed,
viewed on screen, or exported?
Maximise your information
1. What information do you
want to analyse?
2. Who needs to get
information from you, and
what information do they
need?
3. In what format do they need
to get it?
4. What other applications do
you need to interface with?
5. Where is the information
coming from that is to be
used to populate your
database?
6. How can this data be gotten
into the database?
Include everything
If you can work out exactly
what information you need to
get out of the database, you
have already told the
programmer what he needs to
put in to the database. You can
not get stuff out that has not
been put in!
When should I use a
database?
Any process that has a logical
approach can be databased.
Database programming only
really gets into a mess when
the person specifying the
system is unsure of the process
they are asking to be
automated, or when the
programmer has not fully
understood the process.
If you cannot easily specify the
data flow that is required, or
need help in untangling
existing systems, consultancy
can enable you to do this.
Get the information right
Every company needs to be
able to designate a person who
is the key decision maker, and
who can confirm the processes.
Make sure both parties agree
the core functionality and key
processes.
A database specification report
should be drawn up, detailed if
possible to the last field name,
and signed off before any
programming starts.
Programming is always costed
on a time basis, “how long will
your spec take to make?”. So
remember that further
questions and amendments
beyond this agreed spec may
be charged for!
If your specification is sound
and logical, then you’ll get the
system you want - it’s as
simple at that!
What I Really Want Is - To learn more about this author, visit Paul Cruse's Website.
Like this article? Share it with your friends
Ensure you get the system
you need by using our
checklist to creating a
comprehensive database
system specification
Start at the very beginning
Work out the process you are
trying to automate with the
database, DO NOT DO ANY
PROGRAMMING UNTIL
YOU CAN SEE WHAT IS
NEEDED!
List the process on paper one
function at a time, in order, e.g.
1. Customer details come in
via application form,
2. The fields on application
form are: xxxxx
3. Therefore all the fields from
the form are to be added to
the database.
Attention to detail
You do not need to know how
to programme in order to
specify a database, but you do
need to be able to put into
words the details you would
like to get out of the database,
such as:
Labels: list sizes and shapes
Letters: standard and freeform
Reports: various types, with
all their field names, sort order,
search criteria, how often you
need the data, etc.
Searches: which types? Do
you need the searches printed,
viewed on screen, or exported?
Maximise your information
1. What information do you
want to analyse?
2. Who needs to get
information from you, and
what information do they
need?
3. In what format do they need
to get it?
4. What other applications do
you need to interface with?
5. Where is the information
coming from that is to be
used to populate your
database?
6. How can this data be gotten
into the database?
Include everything
If you can work out exactly
what information you need to
get out of the database, you
have already told the
programmer what he needs to
put in to the database. You can
not get stuff out that has not
been put in!
When should I use a
database?
Any process that has a logical
approach can be databased.
Database programming only
really gets into a mess when
the person specifying the
system is unsure of the process
they are asking to be
automated, or when the
programmer has not fully
understood the process.
If you cannot easily specify the
data flow that is required, or
need help in untangling
existing systems, consultancy
can enable you to do this.
Get the information right
Every company needs to be
able to designate a person who
is the key decision maker, and
who can confirm the processes.
Make sure both parties agree
the core functionality and key
processes.
A database specification report
should be drawn up, detailed if
possible to the last field name,
and signed off before any
programming starts.
Programming is always costed
on a time basis, “how long will
your spec take to make?”. So
remember that further
questions and amendments
beyond this agreed spec may
be charged for!
If your specification is sound
and logical, then you’ll get the
system you want - it’s as
simple at that!
What I Really Want Is - To learn more about this author, visit Paul Cruse's Website.
Like this article? Share it with your friends
 | |
 |
No article feedback found. |
| |
Leave Your Feedback |
 | |
| |||
|
To learn more about the Evan Elite Author Program please contact us. |
 | |
|  |
Subscribe to Paul's articles
 | |
|
|  |
 | |
|
| |
 | |||||||
|
 | ||
 |
||
 |
||
 |
||
|
| ||
 |
| Have you written articles that would be of value to entrepreneurs? Become an expert on our site by publishing them! Expose yourself to a wide audience, drive more traffic to your website and get more sales! Click Here for details. |
|
|
 |
| Modeling the Masters: Learn the true secrets behind Walt Disney's business success factors & grow your company! Video produced by Phanta Media |
|
|
 |
"Learn straight from Evan how you can Make a Full Time Income (And More) from a Website"
Click Here To Learn More |
|
|
|
|
Get advice & tips from famous business owners, new articles by entrepreneur experts, my latest website updates, & special sneak peaks at what's to come!
|
|
|
 Caprino Career Path Assessment 3 Deadly Traps How To Get Media Attention Green Realestate CSS Template Radical Green Business |
|
 | ||
 |
Top 50 SEO Posts - 2008
Top SEO Posts of the Year | |
 |
Top 50 Marketing Blogs
Top Blogs To Watch In 2008 | |
| ||
 | ||||
| ||||
|
| ||||
| ||||
|
|
|
|
|
||||||||||||
|
Email us your ideas on how to make our website more valuable! Thank you Sharon from Toronto Salsa Lessons / Classes for your suggestions to make the newsletter look like the website and profile younger entrepreneurs like Jennifer Lopez and Sean Combs!
|
|
|
| ||||||||||||
| ||||||||||||
|
|
||||||||||||