6,725 reputation
1923
bio website mooseware.ca
location Mississauga, Canada
age 52
visits member for 3 years, 3 months
seen 18 hours ago

I'm a professional software developer with more than twenty years of experience across many industries and the entire systems development lifecycle. I'm the principal consultant at Mooseware Limited.

@joelabrown

google

facebook

linkedin


Nov
16
revised Advice on table structure change
Reformatted markdown and text to be more readable.
Nov
13
revised Database Design for Paper Submission System
Added more detailed ERD
Nov
2
revised Preventing duplicate data when usual normalization only makes sense for some of the records
Expanded and clarified.
Jul
14
revised Enforce referential integrity between two groups of data
Corrected spelling for clarity, especially in the title to improve searchability.
Jun
30
revised Different type of column
added para pointing to the table inheritance tags in SO and comment from answerer.
May
25
revised Is this many to many relationship correct?
Made explicit the differences between DMBS with and without DEFERRABLE.
Apr
15
revised Relations between a imeid, sim chip, and account from a cellphone company?
Fixed cardinality on one of the relationships in the ERD.
Mar
30
revised How to scatter/arrange all the tables in database model (workbench)?
Removed database design tag. This isn't a design question it's a question about a tool.
Mar
25
revised Attempting to identify transitive dependency
Added analysis of dependencies
Mar
25
revised Attempting to identify transitive dependency
Added analysis of dependencies
Jan
9
revised Inventory Management DB Design
Expanded answer to include info from comments as per OP's request.
Nov
14
revised Does my ERD account for my business logic
Added ERD to clarify the advice.
Sep
27
revised Configuration Table
Added more (quoted) illustration at the OP's request.
Aug
30
revised When to stop splitting tables?
expanded consideration of business rules
Aug
30
revised Is database normalization dead?
Grammar!
Aug
30
revised Removing “duplicates” within a time range
Added the solution for in and out
Aug
29
revised Removing “duplicates” within a time range
Another SQL Fiddle tweak
Aug
9
revised How to link a customer to a country when the city/state isn't known
Clarified language.
Aug
9
revised how to explain indexes
Clarified the "problem" being explained.
May
14
revised How to share resources among accounts?
Expanded answer to include ERD and recommendations for implementation.