5,784 reputation
1721
bio website mooseware.ca
location Mississauga, Canada
age 51
visits member for 2 years, 7 months
seen 5 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


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.
Apr
25
revised One to at most one relation or multiple null columns?
Expanded answer to take into consideration extra information provided by OP.
Apr
1
revised How do I design a database for a resource scheduling and allocation application?
Expanded to show queries to answer statistical questions using date range design
Apr
1
revised How do I design a database for a resource scheduling and allocation application?
Expanded again to include query information per OP's question in comments.
Mar
31
revised How do I design a database for a resource scheduling and allocation application?
Expanded answer to reflect follow-up question from OP in comments.