971 reputation
49
bio website
location
age
visits member for 3 years, 9 months
seen 19 hours ago

Retired. Once a programmer, then a DBA.


2d
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.
Nov
26
comment Additional info on some rows in the table
The techniques I describe here apply to the design of tables for a relational database. You can apply these techniques in an ms access situation. The actual building of tables is different if you use the access GUI than if you were using SQL DDL, but the design techniques are the same.
Nov
25
revised Additional info on some rows in the table
added subtypes tag
Nov
25
revised Additional info on some rows in the table
added 64 characters in body
Nov
25
answered Additional info on some rows in the table
Nov
25
suggested approved edit on Additional info on some rows in the table
Nov
24
comment Professor told us to store serialized Java objects as blobs instead of defining relational tables
What's the course? Is it Database Design or is it Object Oriented Programming?
Nov
23
comment Professor told us to store serialized Java objects as blobs instead of defining relational tables
Sure. This formulation amounts to objects pretending to be data. And they are data, but not very useful data.
Nov
23
comment Professor told us to store serialized Java objects as blobs instead of defining relational tables
What you said, plus my two cents. Reusability is about modularity and sharing. The object model focusses on sharing objects and reusing code. The database model focusses on sharing and reusing data. Neither model is completely moronic. Neither model is perfection. And it's very, very difficult to reconcile the two.
Nov
22
answered Database Normal Form (financial statement)
Nov
21
revised embedded wiki excerpt
added 83 characters in body
Nov
21
revised embedded wiki description
added 799 characters in body
Nov
21
wiki created embedded description
Nov
21
wiki created embedded excerpt