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:266473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
