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

2d
revised Which of these database designs is normalized?
added 456 characters in body
2d
answered Which of these database designs is normalized?
2d
comment Which of these database designs is normalized?
The question of whether Fiscal Year is dependent on company or not is a subject matter question. In my experience, different companies have different fiscal calendars, but a single company uses a single fiscal calendar throughout its branches (except during mergers and takeovers). So I would answer yes, but.
Apr
28
answered Database design/structure for address details
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