Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


My $.05 (.02 adjusted for inflation):

I'm seeing 3 tables

SUBSCRIBERS
SUBSCRIBER_ID
SUBSCRIBER_NAME
SUBSCRIBER_ADDRESS


PUBLICATIONS
PUBLICATION_ID
PUBLICATION_NAME

SUBSCRIPTIONS
SUBSCRIBER_ID
PUBLICATION_ID
SUBSCRIPTION_START
SUBSCRIPTION_END
SUBSCRIPTION_DAYODELIVERY
SUBSCRIPTION_SPECIALINSTRUCTIONS


On 11/17/2013 2:20 PM, James E Lang wrote:
I have no experience designing a database. I hope this list is a satisfactory forum for my 
questions.

My son delivers a variety of newspapers with some subscribers getting more than one publication and 
with each publication's deliveries varied according to the day of the week.

I want to construct a database that will permit me to use eMail to send him a PDF file for a day's 
delivery list including instructions for driving the route. On a bad day I must be able to quickly 
apply as many as ~25 of these subscriber changes to the database:

• new subscription starts
• old subscription stops and restarts
• add/alter special delivery directives

I also need the ability later to resequence one or more subscriptions relative to the detailed 
driving instructions and to alter those driving instructions.

How much of this can be done using Base? What are the "gotchas" and design requirements? I expect 
that I will need a table of driving instructions, a table of publication delivery schedules, and a table of 
subscriptions with some kind of hooks interconnecting them.

I'm perfectly willing to take any discussion this may start off list after the initial round of 
responses if requested to do so with the understanding that I'll report back my final conclusions.



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.