Re: DBDesign Q

Too bad you're not.


"Bob Badour" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Alan,
>
> Very briefly, you are an ignoramus. Multiple foreign key references among
> relations and cyclical references among relations are perfectly normal and
> acceptable.
>
> "Alan" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > Very briefly. An ERD models business entities and relationships, and
there
> > can be > 1 relationship between the same enities. When you map the ERD
to
> a
> > realtional schema these multiple relationships combine into
non-redundant
> > tables.
> >
> >
> > "Bob Badour" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > > "Alan" <[EMAIL PROTECTED]> wrote in message
> > > news:[EMAIL PROTECTED]
> > > > It is correct on an ERD, but incorrect in a relational schema.
> > >
> > > That's a rather astounding statement. How do you propose to support
your
> > > assertion?
> > >
> > >
> > > > "Andy" <[EMAIL PROTECTED]> wrote in message
> > > > news:[EMAIL PROTECTED]
> > > > > Can two entities have more than one relationship between them?
> > > > >
> > > > > A(A_ID PK,..., bID FK)
> > > > >
> > > > > B(B_ID PK,..., aID FK)
> > > > >
> > > > > A.bID refers to B.B_ID
> > > > > B.aID refers to A_ID
> > > > >
> > > > > 2. Does it make sense?
> > > > >
> > > > > Product (ProductID PK, Name,., SpecialAttrID FK)
> > > > >
> > > > > Attribute (AttrID PK, Name,..,ProductID FK)
> > > > >
> > > > > Product can have many attributes. One attribute belongs to only
one
> > > > product.
> > > > > There is only one main("special") attribute for each product
> > > > >
> > > > > Thank you in advance,
> > > > > Andy
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>