6,262 reputation
1821
bio website mooseware.ca
location Mississauga, Canada
age 51
visits member for 2 years, 11 months
seen Jul 20 at 11:35

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


Jul
15
revised Writing a Condition in a Stored Procedure Using If Exists
added tags and code formatting and improved grammar and punctuation (and formatting)
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.
May
2
revised Many:Many with Shared Relation
Simplified based on comments.
May
2
revised Many:Many with Shared Relation
Expanded with diagrams and two alternative approaches depending on business need.