Andy wrote:
Elder Dan Lewis wrote:
I am still not satisfied with the outline as it is presently. The
name of the chapter seems to describe what is contained in it: the
planning for a database, and then the actual designing of it.
The later chapters should include the entering of test data in
each part to see what works and what needs to be changed to make it
work.
Reizinger Zoltán mentioned some people trying to use the wizards
to create a database for on office and failing because they did not
know what they were doing. Perhaps this would be an excellent
database to use as the relational database for the Base Guide. I'm
not sure what all this database would involve, but I would like to
see the table structure of such a database. So, if Reizinger would do
this much for the project, it would be very helpful. My databases are
usually personal in nature, but there are many people who need a
business type database.
Here is the link to my suggested outline:
http://www.oooauthors.org/english/userguide3/db3/base3_feedback/Chapter-2-outline_DEL_20091026.odt/view
Dan,
I have did a quick read of the document and will try to help fill in
the needed items. It may take some time but I will work up an
example of a business type database to use as well. I have another
project that I think I can work from to get a good example. This will
also give me a chance to see what, if any, limits exist on using the
GUI/Wizards for large scale databases.
I still have to read up on SQL for base but that should not take to
much time.
Good. I had just replied to Reizinger's email. We could use your
example. As we progress in developing the database, we will share all of
our results with you.
Very likely some SQL will be needed to create some of the queries,
but we will be using the GUI/Wizards as much as possible. I'm hoping the
structure of the database will be complex enough to require some SQL. I
would hate to use
SQL just to be using it. The reader needs to be able see that the
GUI/Wizards are only able to do so much. Beyond that, SQL has to be used
to get the desired results.
--Dan
