755 reputation
38
bio website
location
age
visits member for 2 years, 7 months
seen Oct 4 at 20:54

Mar
6
awarded  Yearling
Oct
25
comment How to manage primary key while updating
Your current design as I understand is not correct. Do you want a solution without changing your current design or do you want a solution that would change the current design?
Oct
11
comment How to show NULL results from query?
It is generally not a good practice (INMO) to allow nulls in a column named ID.
Oct
11
answered Best Practices for Testing Application Dashboard Data
Sep
20
awarded  Nice Answer
Mar
6
awarded  Yearling
Feb
8
accepted Looking for industry standard and/or tool to represent and export RDBMS metadata
Feb
6
comment Looking for industry standard and/or tool to represent and export RDBMS metadata
Thank you for your feedback. This is very close to what I wanted.
Feb
6
comment Looking for industry standard and/or tool to represent and export RDBMS metadata
Thank you for your feedback. I was looking for something more generic. Each vendor may have different format for reporting the results. I was looking for a generic format that would work across different vendors.
Feb
6
comment Looking for industry standard and/or tool to represent and export RDBMS metadata
@Phil, thanks for your input. If you care, you can make your comment an answer and I will up-vote it.
Feb
6
asked Looking for industry standard and/or tool to represent and export RDBMS metadata
Sep
25
comment Schema for an RBAC (Role-based Access Control System)
How do you define a module? Where is the "operation" equivalent in BARC?
Sep
22
comment Product Attribute List Design Pattern
What do you mean by "Authorized list of attributes"?
Sep
17
comment How do I optimize this database design?
Could you provide an English description of the tables and what the link represents?
Sep
16
comment Does 'Cities' deserve a separate table?
@NeilMcGuigan, City and state columns that you see in Customer represent 1 foreign key of the parent table (called city) in this diagram. This is not the only way to do this as mentioned elsewhere in this post.
Sep
14
comment Curious Database building Problem (ER Diagram)
It is not valid to remove the "Autoshop" as it represents the point of sale. Also for @JacobRich, please include what you already have in the body of your question. The association "Autoshop" has "Customer" may not be valid because a customer can visit any branch of the company (unless branches don't share customer data or branches are geographically located in such a way that makes sharing customer data meaningless). Also, a supplier may supply 1 or more "Stock Items" and a "Stock Item" may be supplied by 0,1 or more suppliers., It depends on your business rules.
Sep
12
answered An “unlimited” data model
Sep
10
answered Designing an Accumulating Snapshot with Repeated Groups, need advise
Sep
10
answered Updating data from a report: any potential pitfalls?
Sep
7
comment Why is a Star Schema more normalized than a 3NF Schema?
"3NF is the most normalized among common schema models", this is not true as there are more normal forms than 3.