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


Apr
15
answered Relations between a imeid, sim chip, and account from a cellphone company?
Apr
15
comment Relations between a imeid, sim chip, and account from a cellphone company?
IMEI identifies a device. SIM cards have an ID number too (ICC ID). A phone number (SSID) is assigned to one SIM (at a time). So there are lots of layers of abstraction. A person holding a phone has a phone number, but only because the phone (IMEI) has a SIM (ICC) in it and the SIM is assigned a phone number (SSID). Since the mobile operator wants to get paid, the SSID is linked to an account (some operator-specific account ID scheme). Note that an account (might) have many phone numbers. Each phone number probably has one plan (at any given time).
Apr
8
comment Implementing voting system like reddit/StackExchange?
If you want to make it like StackExchange, you'd also have to include a date/time when the vote was recorded.
Apr
6
answered Does redundancy exists in this table?
Mar
30
comment 3 way junction table and redundant value
@caramel1995 - This happens automatically. You don't assign a quantity of two laptops, you assign 2 specific laptops. This would manifest itself as two records in EMPLOYEE_OWNS_ASSET or as two ASSETs with an FK to EMPLOYEE depending on how you model it.
Mar
30
comment Attempting to identify transitive dependency
@crm - Yes. Looks good now.
Mar
30
answered 3 way junction table and redundant value
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
28
comment Designing a reservation system schema
Unless your bookings are for very carefully regimented blocks of time (days, hours, half hours, etc.) you're really better off recording what is booked, not what's available. Do you have an efficient, set-based query for calculating what's available, such as one from the answers to this question: stackoverflow.com/questions/9604400/… ?
Mar
26
comment Problem with reaching second normal form in a database
@ypercube is right. Take repeating groups out to get to 1NF. You can't be 2NF if you aren't 1NF yet, regardless of the definition/test for 2NF.
Mar
25
revised Attempting to identify transitive dependency
Added analysis of dependencies
Mar
25
revised Attempting to identify transitive dependency
Added analysis of dependencies
Mar
24
comment Attempting to identify transitive dependency
Product code is a foreign key to the PRODUCT table in your invoice detail. In the product table, product code is the determinant, in the invoice item table, it is just a dependent attribute.
Mar
24
answered Attempting to identify transitive dependency
Mar
5
answered Database Design
Feb
27
answered What is the difference between logical schema and physical schema?
Feb
24
awarded  Custodian
Feb
24
reviewed Approve suggested edit on Getting the exact edited data from a column in SQL Server
Feb
20
answered Database throughful design vs Quick and dirty design comparison
Feb
8
answered Why does data get corrupted in “large” text files - Reasons to use database