6,262 reputation
1821
bio website mooseware.ca
location Mississauga, Canada
age 51
visits member for 2 years, 11 months
seen 2 days 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


Jul
15
reviewed Edit suggested edit on Writing a Condition in a Stored Procedure Using If Exists
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.
Jul
14
comment Enforce referential integrity between two groups of data
The problem is that a foreign key needs to reference all of the columns in the key. You are trying to reference part of a candidate key. Obviously that doesn't make sense. If your intersection table is truly referencing just the group IDs, then you need to normalize the rule and action tables to make their group IDs unique without reference to other columns.
Jul
12
reviewed Approve suggested edit on what is '#' in create table statement?
Jul
8
reviewed Approve suggested edit on Order by alphabet and then by numbers
Jul
5
comment Personal and Global messaging database design
You should see my answer to this question on Stack Overflow, where I go into quite a bit of detail for essentially the same requirement: stackoverflow.com/questions/6541302/…
Jul
4
answered Is there a good way to select a row where the key represents the lower bound of a range?
Jun
30
reviewed Edit suggested edit on Different type of column
Jun
30
revised Different type of column
added para pointing to the table inheritance tags in SO and comment from answerer.
Jun
29
answered Best relationship database design to manage types for different entities
Jun
27
comment Different type of column
@yannis - Hmmm, hard to find a really great link. The terminology is what's used in James Martin's Information Engineering(TM) method. Some others call it a classifying attribute. The topic to read up is Entity Subtyping - this will cover the various ways that you could implement this model physically. The point of the partitioning attribute is to help enforce mutual exclusivity of subtypes. Each subtype is associated with a particular data value in the partitioning attribute.
Jun
26
answered Different type of column
Jun
26
comment Reviewing relational database tables
You need to think about (or state, if you know them) what your candidate keys are. What is the business key of your students_class table? It looks like it may not be normalized to me. Ask your friend what is the purpose of the additional table? All of the information it contains is already available in the other tables and can be retrieved through query or view.
Jun
23
answered Entity Relationship Model - double one to many
Jun
8
answered Train Fare Database Normalisation
May
30
answered How to store list of unknown size in database
May
29
comment Optimum design / structure for product data database?
Have a look at my answer to this question, which addresses your requirement for product attribute values: stackoverflow.com/questions/14194841/…
May
29
comment Optimum design / structure for product data database?
Also, see my answer to a very similar question on SO: stackoverflow.com/questions/11779252/…
May
29
comment Optimum design / structure for product data database?
There should be a third table containing attribute names so that a comparison can be made across products. This is called Entity Attribute Value and is generally frowned upon, but I consider it to be the perfect for product catalogs. See: stackoverflow.com/questions/11779252/…