1,038 reputation
49
bio website
location
age
visits member for 3 years, 11 months
seen 23 hours ago

Retired. Once a programmer, then a DBA.


2d
comment Normalising shared entities and applying constraints
There is a tag called "subtypes" here in DBA. Customers, suppliers, employees, etc. sure sound like subtypes to me. If you add this tag to your question, you should get more answers.
Jan
25
answered select statement for subtype
Jan
24
comment Compare the structure of two MySQL Databases
Nice. I once detected a difference between two databases with about 500 columns in them where one column was variously defined as Int or Float. This pinpointed an elusive problem that had been bugging the administrators for a long time.
Jan
20
revised Daisy chaining two is-a relationships?
added detail about player/cricketer/bowler
Jan
20
answered Daisy chaining two is-a relationships?
Jan
19
answered How to reference categories table in products table?
Jan
12
revised Design a database with test table with different answer format
added subtypes tag.
Jan
12
comment Design a database with test table with different answer format
The generic answer, without reference to your specific case is to research two techniques, "single table inheritance" and "class table inheritance" in here, on StackOverflow, or on the web.
Jan
12
suggested approved edit on Design a database with test table with different answer format
Jan
9
revised What's worse, too many entities or too many tables?
deleted 2 characters in body
Jan
9
answered What's worse, too many entities or too many tables?
Jan
6
comment ER-Model for Borrowing-Lending-Network?
An ER model is more complete than an ER diagram.
Jan
6
comment ER-Model for Borrowing-Lending-Network?
Yes, you can have two relationships between the same pair of entities.
Dec
19
comment Relationship issue
What if there were a city that is in two states? Is "Kansas City" one city or two cities?
Dec
11
suggested rejected edit on What is the best way to represent an album and song entity in an e-commerce schema?
Dec
5
answered Field types database design best practice
Nov
30
comment Recipe Health risk Database ERD structure
Is your question about the subject matter or about the table design?
Nov
28
revised Should I put common fields in each specific tables or one common table then join when data selecting?
addedtag subtypes
Nov
28
suggested approved edit on Should I put common fields in each specific tables or one common table then join when data selecting?
Nov
26
comment avoiding unique key collisions across tables
I'm more of an Oracle person myself. But I think this conversation is going around in circles until we all clarify why partitioning is useful and why multiple tables with the same structure and semantics is an antipattern. You and Raymond are saying the right things, but it isn't getting through.