637 reputation
48
bio website
location
age
visits member for 3 years, 5 months
seen 1 hour ago

Retired. Once a programmer, then a DBA.


22h
comment Is it possible to automatically convert/load an Access database into a CSV or TXT file?
Is an interactive method an answer to your question? If not, why not? If so, have you tried going into Access and using "Table (right click), export..."?
2d
comment Converted ERD into Dependency Diagram 1NF, 3NF
When I learned the ER model, it did NOT include FKs. What your professor is teaching you is to use ERDs as a depiction of a relational design. That is, in fact, the mainstream today, but it is not the classical way.
Aug
14
comment Composite Primary Key column order
Back in the day, I tended to focus on correctness, completeness, and flexibilty during initial design, and to leave tuning for speed to a later point in time. At that time, I would test for the cost penalty of alternative designs, using data obtained from "real world" production. YMMV.
Aug
12
awarded  Yearling
Aug
12
answered Why WordPress use a column prefix?
Aug
11
answered Composite Primary Key column order
Aug
4
comment Right Outer Join (column name doubt)
In your title, does the word "doubt" really mean "question"? English speakers will usually not recognize "doubt" as a synonym for "question".
Jul
30
revised subtypes wiki excerpt
added 63 characters in body
Jul
30
revised subtypes wiki description
added 929 characters in body
Jul
30
wiki created subtypes description
Jul
30
wiki created subtypes excerpt
Jul
30
suggested suggested edit on subtypes tag wiki
Jul
30
suggested suggested edit on subtypes tag wiki excerpt
Jul
30
awarded  Organizer
Jul
30
revised Relationships between subtypes of an entity
Added new tag, subtypes
Jul
30
suggested suggested edit on Relationships between subtypes of an entity
Jul
26
comment Database Design for classifieds site
WRT subcategories, it sounds like they are like classes and subclasses in OOP. If so, check out the answers to This question.
Jul
13
revised Entity Relationship Model - double one to many
added 181 characters in body
Jul
13
comment Data modeling with many attributes where few apply to each record
Option 1 is convenient when you want to use data that pertains to all rows, regardless of subclass. The width of the table adds unnecessary bulk, slowing things down. But it's easy. See my Option 4 answer for an alternative.
Jul
12
comment Entity Relationship Model - double one to many
What normal form does LEAD violate?