Consider the following database design concepts: foreign key, relationship types (1:1, 1:M, M:N), connectivity, cardinality, strong entity, weak entity, strong (identifying) relationship, weak (non-identifying) relationship, optional participation, manual participation.
I understand what
all these concepts are and what
is said to be important about them. But I just do not understand why
they are important. I presume it has something to do with the actual creation of the database, i.e., the DDL used to create the database objects. For example, does it have something to do with the order of table creation?
Or, perhaps the question is better posed as this: Once I have rendered a complete ERD (replete with all the concepts above), then how is the importance of all those concepts translated?
Oh wait, just thought of something. Please refer to the embedded ERD. How is the importance of the concepts translated?