On Tue, 8 Feb 2005, SOTL wrote:
> I need to create a DB as my current usage of a spreadshead for one has hit the
> logical max number of entries of over 10,000 [Ten Thousand] entries.
... creating it is no problem -- I assume you wish to pull
reports out, pull a report based only on selected rows,
possibly add additional rows, and maybe update entries from
time to time -- you may also want access control; What about
UI: console local, GUI, network remote, webbish?
> The level of data base I am think of if viewed on a spread sheet should be
> about 5 lines wide and 10 or so lines long of the type:
> NAME, ADDRESS, CITY, STATE, TITLE
Specification of the task -- determining the Inputs, the
intermediate Procesing, and the desired forms of Output, can
be decomposed into progressive levels of detail in a process
(long since obsolete) called HIPO -- I learned it from an IBM
rep back in maybe '72.
With that spec in hand, one then successively implements, or
of the task is not broken down into a bite size chunk,
breaking it into further subtasks and recurseing to try an
implementation.
Finally, when you have met the spec you declare victory, and
are done -- or ready to extend the spec.
I use a cheatsheet I maintain at:
http://www.herrold.com/sql-cheat-sheet.txt
and an extension at:
http://www.herrold.com/mysql-cheat-2.txt
and a prior bit of code, and can prototype rather quickly.
Ask on the list if you can narrow the scope a bit, and hit a
hard spot.
-- Russ Herrold
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 18:47:42 EDT