frank1 — 2013-03-30T07:15:41-04:00 — #1
What technique do you use to identify a weak entity type or relation while creating an er diagram
normally rough defination says
entity which is dependent on other entity to exist
and not having unique identifier of itself(only partial key)
but i am little bit confused as if we go by defination
in ecommerce system isn't orders a weak entity as it is meaning less with out customers or there is customer id as a foreign key in order table to uniquely identify it.
what about hotels and rooms.....
(room may have id but it is dependent upon hotel for existence)
so am i missing something in way i am thinking?
can there be weak relationship with out weak entity?
r937 — 2013-03-30T08:04:47-04:00 — #2
there cannot be a relationship without a foreign key, so the presence of the foreign key is a given
the only remaining question is whether the foreign key is part of the primary key, or separate
an orders table, for example, typically has its own primary key, so customers-orders is not a weak relationship