For example: Say you have a request table and a response table. Here are the steps writing to the DB.
1) Write request to request table and send XML request to vendor.
2) Wait for the response from vendor and then write response to response table.
Assume in this scenario that its a one to one relationship and each request should have a response. What should the ERD diagram show?
I have the request table with || to show min 1 and max 1. I think this is correct.
I have the response table O| to show min 0 and max 1. I think the max is correct but I don't know if the minimum of 0 is correct. I set it to 0 for min b/c its not required at the time the request is written.
Does my question make sense at all?