|
An example database would be a
good thing to have! It seems everyone agrees on that.
The question is , what would be a good
example. Which I suppose comes first to the question, as always, of
'the target audience' for Base. More precisely the target for the
example. Another way to look at it would be, what 'skill level' would
be needed to produce a given result. In defining the term 'skill
level', we would be describing these different user audiences.
Here
is a shot at a skill level list ( hopefully others can help refine
the thinking here )
Novice -
-
No experience with any type of DBMS.
-
Doesn't recognize the difference between a Base table grid view
and a Calc spreadsheet ( Hey they both have columns and rows -
right, so they must be the same.)
Flegling -
-
Has the basic concepts down,
comfortable with creating a table or simple form/sub-form with the use
of the wizards.
-
Can produce a multi-table query
using the designer and then use this to produce reports via the wizard.
-
Is NOT comfortable when having to
use SQL syntax.
-
Has difficulty creating custom
scripts.
-
Does not have a clue as to what is
meant by MVC architecture.
-
Has light experience creating personal forms in MSA, FMPro,
Approach, Paradox or the like. ( But not so much experience that
Base's handling of some functionality differently would be a huge
problem )
Apprentice -
-
Recognizes places in the schema
where normalization can be used to enhance data integrity.
-
Is using functions within SQL
statements to generate calculated fields.
-
Is creating 'applications', by
linking multiple forms together along with custom scipt functions in
libraries.
-
Has light to moderate experience creating these database
applications for use by self and others. This experience again may be
in MSA, FMPro, etc. but might also be skilled in PHP, Python, REXX. ( For
this user differences in approach between the package they are
experienced in and Base may actually pose more of a hurdle - if only
because of inertia. )
Journeyman -
-
Understands both the generalities of
database design and has implemented these using packages from more then
one vendor in the past.
-
Is creating 'applications' targeted
for a specific business field either as the member of an internal IS
group, or for resale in a vertical market.
-
This person is experienced in mixing features from differing
packages to attain a given result. ( For this user the differences
in Bases approach to a given task is not the problem, so long as it is
realtvely easy to get to the documentation - The developers Guide is
already this persons friend. )
Anyway, this is just my thinking on it. I would
suggest that it would be wise for us to try and relate our discussion
of what would make for a good base-line example back to these ( or some
defined set of ) user
groups. My initial thinking is that the example is best targeted to
someone in the Fledgling - Apprentice skill level, and if I had to
err on one side or the other, I would try to err on the Fledgling
side.
Trying to focus an example to the novice user might sound good, but
I think you end up losing them much to quickly. What makes more sense
to me is that once the example is created, then there is a wonderful
opportunity for someone to generate a tutorial targeted to this Novice
user that goes into not only the steps used to create it - but the
thinking behind the choices that where made in creating it.
Drew
|
- [dba-users] Example database Andrew Jensen
-