Results 1 to 2 of 2
Mar 30, 2013, 04:15 #1
Database design,ER and weak entity
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?