Reputation
1,183
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 9
Newest
 Yearling
Impact
~57k people reached

Apr
21
comment How to get a surrogate key value in order to put a foreign key in and create relationship?
You need to clarify your intent. Are you trying to perform an insert, based on user inputs? Are the two reference tables already populated, and you are trying to fill in the linkage table? Do the users know the values of the surrogate keys (hopefully no)? Are there alternate handles the users can use to specify which quote and interest rate they are talking about?
Apr
18
revised Enhanced ER Model Supertype / Subtype modeling issue with inheritance and recursion
typo
Apr
17
comment Enhanced ER Model Supertype / Subtype modeling issue with inheritance and recursion
Unfortunately, when I did a google search on "reflexive relationship", what I got was a bunch of hits on "reflexive relation". This is a completely different concept, even though the names are almost identical.
Apr
17
revised Enhanced ER Model Supertype / Subtype modeling issue with inheritance and recursion
Major update based on comment on the original response.
Apr
17
comment Enhanced ER Model Supertype / Subtype modeling issue with inheritance and recursion
OK, I didn't get that from my reading of your question. I'll go back and edit my response.
Apr
17
comment Enhanced ER Model Supertype / Subtype modeling issue with inheritance and recursion
When you said "recursive relationship" did you mean "reflexive relationship"?
Apr
16
answered Enhanced ER Model Supertype / Subtype modeling issue with inheritance and recursion
Apr
8
answered Determining Functional and Transitive dependencies from Relational Model (with no sample data)
Mar
26
revised Normalization for three somehow identical tables
added subtypes tag
Mar
26
suggested approved edit on Normalization for three somehow identical tables
Mar
25
revised Designing database with Category and Tags for Posts - Seeking for guidance/advice
added 71 characters in body
Mar
25
answered Designing database with Category and Tags for Posts - Seeking for guidance/advice
Mar
23
revised How to enforce data consistency across one-to-one relationship in an inheritance hierarchy
Added subtypes tag, although the inheritance tag probably covers the ground.
Mar
23
suggested approved edit on How to enforce data consistency across one-to-one relationship in an inheritance hierarchy
Mar
20
comment Relationships for database tables in HR/Compliance Database using MS Access
This is a comment, not an answer. There are two possible kinds of issues that can arise out of an MS Access design. One is database design issues. The other is Application design issues. If you are like me, you rely on the wizards to help you with form/subform design. And if you design the tables properly, the wizards have all the info they need to help you get where you want to go. So what you need to do is find an example of an Access app that has the kind of 5 table structure you designed from an analysis of the case. See what their forms and subforms look like.
Mar
19
revised Why wouldn't I put the single preferred option into its own table, instead of having a 'Preferred' column?
typo
Mar
19
answered Why wouldn't I put the single preferred option into its own table, instead of having a 'Preferred' column?
Mar
17
revised Is an ER diagram an example of a conceptual, logical or physical schema?
typo
Mar
17
revised Is an ER diagram an example of a conceptual, logical or physical schema?
typos
Mar
17
comment Is an ER diagram an example of a conceptual, logical or physical schema?
All I can say is that the terms are not used consistently throughout the available literature. That is why I emphasized "the way I learned it", because that's by no means the only way the concepts are presented.