You know your business Richard. We are just giving suggestions for good practices that made our lives easier.
You have more knowledge of the situation more than what you can convery over an email. =) Teddy On 1/12/07, Richard Dillman <[EMAIL PROTECTED]> wrote: > > But wouldn't this require someone to add a new date and select all the > children that are in that issue every month? > > Maybe a further clarification is in order... > > Kids become available and unavailable all the time. Sometimes a child > could > be added to the Pub and left there for years at a time. The pub in mind > is > printed by the client. Other pubs are printed Daily and the child might > appear once. Other pubs might be say a Monday night spot on the news. > Most > are Websites and therefor being updated constantly. without publication > date. > > so I guess I'm trying to cut corners by putting it all in the same table. > but seance I'm now working that backwards overtime for free I'm trying to > cut as many corners as possible. > > > On 1/12/07, Teddy Payne <[EMAIL PROTECTED]> wrote: > > > > I put in the ID fields on the bridge tables to give the relationships a > > unique key for ease of querying. > > > > I guess I am just lazy. =) > > > > Teddy > > > > > > On 1/12/07, Deanna Schneider <[EMAIL PROTECTED]> wrote: > > > > > > That's essentially what I was saying, Teddy just did a better job of > > > articulating the details. > > > (Whether or not you need periodicalissueid and periodicalChildId is a > > > matter of style. I tend not to do that and just use the composite ID's > > > instead.) > > > > > > > > > > > > On 1/12/07, Teddy Payne <[EMAIL PROTECTED]> wrote: > > > > I would agree with Deanna. That is a necessary step, but then I > would > > > > suggest normalizing one step further. > > > > > > > > tbl_Children (childID, ...) > > > > > > > > tbl_Periodical (periodicalID, ...) > > > > > > > > tbl_PriodicalIssue (periodicalIssueID, month, year, periodicalID) > > > > > > > > tbl_PeriodicalChild (periodicalChildID, childID, periodicalIssueID) > > > > > > > > You want to avoid duplicate information about a Periodical, so you > > > create a > > > > table that keeps track of every issue that has been published. > > > > > > > > Now you have a table that will avoid duplicates of periodicals and > > > children. > > > > > > > > Teddy > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266602 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
