Reputation
1,666
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
6 12
Newest
 Necromancer
Impact
~105k people reached

2d
answered In a one-to-one relationship, where should the foreign key be placed?
Feb
6
revised Survey Database - Respondent Table (1NF or 3NF - Pros and Cons)
added 26 characters in body
Feb
5
answered Survey Database - Respondent Table (1NF or 3NF - Pros and Cons)
Jan
27
comment Is it useful to split a table into a frequently used and a archive table?
It depends on how the data is to be used. In some uses, splitting the table just adds overhead and complexity. In others, critical transactions may complete much faster.
Jan
27
comment ERD Diagram based on Crow's Foot model for Milky Way Jewelry
What was your wrong answer, and what was wrong with it?
Dec
16
comment Where/how do I save extra data per column?
The term metadata is not wrong here. Most of the metadata you encounter in database 101 is structural metadata, but there are other kinds as well.
Nov
26
answered Why not have Persons for every person in schema?
Nov
25
comment Class- and instance- type rows
If I knew of a way to simplify it without damage, I'd share it.
Nov
25
comment Discover missing foreign keys and/or indexes
Are you actually looking for undeclared FKs? An FK is an FK, whether the database builder declared it or not.
Nov
25
comment Discover missing foreign keys and/or indexes
As far as the apps goes, start listening to the complaints, and acting on some of them. As soon as people realize you are responsive, complaints will come pouring out of the woodwork.
Nov
25
comment Discover missing foreign keys and/or indexes
When I had to do that, the first step was to use the data dictionary to discover what PKs, FKs and indexes I did have. The next step was to reverse engineer an ER model (not a relational model) of the underlying subject matter. A tool called PowerDesigner had some reverse engineering features built in, and I got a lot of help from the subject matter experts. There are several steps after that, but this is a start. When you do database archaeology, you have to do a lot of digging.
Nov
20
comment Alternative to EAV to store data with an unknown structure
"Storing data with an unknown structure" has a multitiude of implications, easily requiring the effort of a bachelor thesis. Most of the arguments against EAV are given in cases where the structure of the data is known, at an intuitive level, by the subject matter experts, but unknown to the would be database architect. Discovering and formalizing the data structure is just too much work, so they resort to EAV as a way of shortening the development curve. Your case is entirely different. The arguments that people like me make against EAV do not apply to your case.
Nov
19
comment One table to rule them all, or thousand smaller?
The title is misleading. It's one table to contain them all, not to rule them all. and yeah, I get the LOTR reference, but cuteness aside, you are only confusing yourself.
Nov
19
answered Designing a database where records can reference different foreign keys
Nov
14
awarded  Necromancer
Nov
13
answered Understanding relations
Nov
13
comment Understanding relations
I hope this isn't rude, but you can help us by telling us what your first language is. It could be Japanese, or Greek, or Spanish, or something else. The way we phrase our answer might or might not help you understand, depending on where your strength lies.
Nov
10
comment Define a db before coding
I'm not sure how much you know about database design. Does the phrase "table decomposition" mean anything to you? How about "data normalization"?
Nov
10
answered Define a db before coding
Nov
7
comment How to represent foreign key in an ER diagram?
I like crows feet for ER diagrams as well. For relational diagrams, I prefer the arrowhead. note that a crows foot goes on the "many" end of a line, while an arrowhead goes on the "one" end of a line.