Re: [libreoffice-users] Database Design

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